Subscribe Now

* You will receive the latest news and updates on your favorite celebrities!

Trending News

25 Nov 2020
ACED, Maximum Availability Architecture, Oracle, Oracle Cloud, Oracle Data Guard, Oracle Database, Oracle Database 19c, ...

Script to check Data Guard status from SQL 

In a previous blog post I have explained how to get the basic configuration from x$drc and display something like: OBJECT_ID DATABASE INTENDED_STATE CONNECT_STRING ENABLED ROLE RECEIVE_FROM SHIP_TO FSFOVALIDITY STATUS ——— ————– —————– —————————- ——- ——– ———— ————– ———— ——- 16842752 toolcdb1_site1 READ-WRITE-XPTON newbox01:1521/TOOLCDB1_SITE1 YES…