Change CDB name from DEVCDB to TESTCDB ********************************************* Backup database before performing this action *********...
Read the full lessonJuly 04, 2022 · dataguard · dba · monitoring · oracle · scripts
Script to Monitor Dataguard Log Gap
=> SQL to fetch the log gap [oracle@hostname ~]$ cat /home/oracle/scripts/standby-lag.sql select to_char(sysda...
Read the full lessonJuly 02, 2022 · backup · dba · oracle · rman · scripts
Sample RMAN backup script
#!/bin/bash #Declare your environment variables #export ORACLE_SID= #export ORACLE_HOME= #export PATH=$PATH:${ORAC...
Read the full lesson
Subscribe to:
Posts (Atom)
-
By Gowthami | apps-dba.com | Oracle Administration Series A common issue after Oracle Database 19c patching is a Pluggable Database (PDB) o...
-
By Gowthami | apps-dba.com | Oracle Performance Series Oracle Parallel Query (PQ) allows a single SQL statement to be executed by multiple ...
-
By Gowthami | apps-dba.com | Oracle Exadata Series If you work with Oracle Exadata, one of the most transformative features you will encou...
Oracle DBA Lesson 32D — Choosing a Point-in-Time Recovery
Point-in-time recovery deliberately returns the database to an earlier consistent state. Choose the boundary from the incident and the ...
