Oracle Dataguard


--Nikhil Tatineni——Dataguard—

Query's to monitor standby databases

https://memorydatabase2023.blogspot.com/2016/10/querys-to-monitor-standby-database.html


Applying logs with delay # Standby database #

https://memorydatabase2023.blogspot.com/2016/07/dataguard-delay-parameter.html


Physical Standby # Active Dataguard11g

https://memorydatabase2023.blogspot.com/2016/07/physical-standby-active-dataguard-11g.html


Snapshot standby # 11g

https://memorydatabase2023.blogspot.com/2016/07/dataguard-converting-physical-standby.html


Dataguard Broker # DMON

https://memorydatabase2023.blogspot.com/2016/12/dataguard-broker-dmon.html


Query's / Managing Oracle Physical Standby Databases

https://memorydatabase2023.blogspot.com/2016/08/managing-oracle-physical-standby.html


Troubleshooting #


Media Recovery terminated with error 28365 # TDE

https://memorydatabase2023.blogspot.com/2016/10/media-recovery-terminated-with-error.html


Dataguard # oldest online log sequence 0

https://memorydatabase2023.blogspot.com/2016/07/dataguard-oldest-online-log-sequence-0.html


--Nikhil Tatineni——Dataguard—
Subscribe to: Posts (Atom)

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...

  • Skip transaction GoldenGate replicat 12c
    syntax for skipping transaction # ggsci> start replicat skiptransaction  GGSCI (red.gg.ora.com) 14> info all Program     St...
  • ORA-24324, ORA-24323, ORA-01090
    scenario # trying to startup / shutdown database encountered with following error # ORA-24324: service handle not initialized ORA-243...
  • ERROR OGG-01454
    Today GoldenGate Extract abended on Servers During my initial investigation,  goldengate error report says as follows  2016-02...