Saturday, October 18, 2025

ORA-00236: snapshot operation disallowed: mounted control file is a backup

›
I f you try to take the backup of a controlfile and it returns ORA-00236, it means that you are trying to take backup of a controlfile tha...
Tuesday, September 2, 2025

ORA-19838: Cannot use this control file to open database

›
This error would come if you are trying to open a database with reset logs after you performed database duplication using DUPLICATE command...
Friday, July 25, 2025

ORA-38872: Cannot perform backup control file recovery if Flashback Database is enabled

›
RMAN-00571: ===========================================================   RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==========...
Sunday, June 22, 2025

ORA-39095: Dump file space has been exhausted

›
For datapumpt export, we use %U substitution variable when we intend to create multiple export dump files through parallel export or dump fi...
Saturday, March 29, 2025

Finding and Monitoring SQLs in Execution

›
  Dictionary view V$SQL_MONITOR is used to find out SQLs currently in execution and a little history of SQLs executed in the recent past. Th...
Thursday, March 6, 2025

ORA-65093: multitenant container database not set up properly

›
RMAN-00571: ======================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===...
Saturday, February 15, 2025

ORA-00058: DB_BLOCK_SIZE must be 16384 to mount this database

›
This error may be returned during different scenarios; however, the root cause may be the same. I was trying to use duplicate command to bui...
Saturday, February 1, 2025

ORA-31655: no data or metadata objects selected for job

›
  Whenever datapump export is initiated, it should (mainly) either by database level, schema level, or table level. If you omit to tell exp...
Monday, January 6, 2025

ORA-16086: Redo data cannot be written to the standby redo log

›
2024-11-22T07:09:14.930561+00:00 Errors in file /data/oracle/MYDB/admin/ diag / rdbms /MYDB/MYDB7/trace/MYDB7_lgwr_178713.trc: ORA-16086: Re...
Thursday, December 26, 2024

RMAN-06172: no AUTOBACKUP found or the specified handle is not a valid copy or piece

›
       RMAN> restore controlfile from '/home/oracle/current.257.1073287779_20240609_0030';       Starting restore at 12-JUN-24 ...