Subscribe Now

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

Trending News

22 Sep 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…

ACED, Data Guard, high availability, Multitenant, Oracle Database, Oracle Database 19c, Trivadis Blog...

Real-Time Cascade Standby Container Databases without Oracle Managed Files 

OK, the title might not be the best… I just would like to add more detail to content you can already find in other blogs (E.g. this nice one from Philippe Fierens http://pfierens.blogspot.com/2020/04/19c-data-guard-series-part-iii-adding.html). I have this Cascade Standby configuration: DGMGRL> connect / Connected to „TOOLCDB1_SITE1″…

ACED, Oracle Database, Oracle Database 12c, Oracle Database 18c, Oracle Database 19c, Trivadis Blog

How to get the Data Guard broker configuration from a SQL query? 

Everybody knows that you can get the Data Guard configuration in dgmgrl with the command: show configuration; but few know that this information is actually available in x$drc: SQL> desc x$drc Name Null? Type ————— ——– ————— ADDR RAW(8) INDX NUMBER INST_ID NUMBER CON_ID NUMBER…