Data Guard, Easy Connect and the Observer for multiple configurations
EZConnect One of the challenges of automation in bin Oracle Environments is dealing with tnsnames.ora files. These files might grow big and are sometimes hard to distribute/maintain properly. The worst is when manual modifications are needed: manual operations, if not made carefully, can screw up…
Data Guard, Easy Connect and the Observer for multiple configurations
EZConnect One of the challenges of automation in bin Oracle Environments is dealing with tnsnames.ora files. These files might grow big and are sometimes hard to distribute/maintain properly. The worst is when manual modifications are needed: manual operations, if not made carefully, can screw up…
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…
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…
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″…
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″…
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…
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…
Awk to format the files .ora (listener.ora, tnsnames.ora, etc)
Tired of formatting the tnsnames.ora to make it more readable, I have taken the nice awk examples from Jeremy Schneider: https://ardentperf.com/2008/11/28/parsing-listenerora-with-awk-and-sed/ and created a function to format all files .ora (lisp-like config files). Example, before: $ cat tnsnames.ora LUDOCDB1_SITE2 = (DESCRIPTION = (ADDRESS = (PROTOCOL…
Awk to format the files .ora (listener.ora, tnsnames.ora, etc)
Tired of formatting the tnsnames.ora to make it more readable, I have taken the nice awk examples from Jeremy Schneider: https://ardentperf.com/2008/11/28/parsing-listenerora-with-awk-and-sed/ and created a function to format all files .ora (lisp-like config files). Example, before: $ cat tnsnames.ora LUDOCDB1_SITE2 = (DESCRIPTION = (ADDRESS = (PROTOCOL…