Tuesday, June 23, 2015

Monitoring Oracle Dataguard Status

Received a tip from the gurus:
ON STANDBY:
v$dataguard_stats - various stats, including apply lag.
v$dataguard_status - status messages related to dataguard.
v$managed_standby - info on the standby 

ON PRIMARY
v$archive_gap - shows the # of archived redo logs the standby is
behind.  Since we're shipping in real-time, this should nearly always be 0.


















at



























Labels:
,
,


















No comments:











Post a Comment












        

      









Subscribe to:
Post Comments (Atom)











    

  • 

    

    Golang Calling Stack
    

      package main import ( 	 "fmt" 	 "runtime" ) func main() { 	 aa() } func aa() { 	 bb() } func bb() { 	 cc("hello&q...
    

    

    

    • 

  • 

    

    TimescaleDB
    

    https://docs.timescale.com/timescaledb/latest/#welcome-to-the-timescaledb-documentation TimescaleDB is a time-series database, built on top ...
    

    

    

    • 

  • 

    

    Notes from gittower "Undoing Git Mistakes" presentation
    

    Uncommited Local Changes 1. revert local changes git restore fname 2. accidentally deleted a file git restore fname 3. discarding chunks/lin...
    

    

    

    •