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…
Formatting SQL Scripts in a Directory Tree with SQLcl
Introduction Oracle’s SQL Developer can format code in any worksheet and PL/SQL editor. The formatter is highly configurable and the default formatting results are becoming better with every version. Oracle’s SQLcl is a command-line tool. It’s a stripped down version of SQL Developer and known…
Oracle 19c solves ORA-00026 when killing PDB sessions
Oracle Multitenant was a big architectural change for Oracle Database. I guess it was not so easy to introduce it to such a complex system. Unsurprisingly, there were some side effects introduced, but Oracle works hard to correct them. One example is ORA-00026: missing or…
Oracle Critical Patch Update Juli 2020 – Statistiken und Grafiken
Mit 443 Patches im Juli-CPU hat die Gesamtzahl der Patches in den Oracle Critical Patch Updates ein neues Allzeit-Hoch erreicht. Diese Patches verteilen sich auf die gesamte Produktpalette von Oracle und da auch die Anzahl der betroffenen Produkte mit 136 ein neues Maximum erreicht hat,…
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″…
Preplugin Backups and the Missing Piece
Subheading 1: Preplugin Backups for non-CDB to PDB Conversions and the RMAN-06054 Subheading 2: PrePlugin Backups and the need for “Trick 17” The following is coming from a customer project. Imagine you have a huge non-CDB database, assume some terabytes. And you want to bring…
Getting the most out of Oracle Database Express Edition (XE) 18c
Express Edition is a nice starter database which comes for free and does not need a license. Well, you do not get support for it either. There where XE databases in 10g and in 11g, but in this blog post I look into current XE…
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…
Names Matter
This is one of my favorite quotes: There are only two hard things in Computer Science: cache invalidation and naming things. — Phil Karlton IT is my daily live. And this quote is so true. Lately I’ve been thinking much more than usual about naming,…
Social Media @trivadis