OracleNext - Solution to your Oracle problems

Oracle Installation guides, Linux Administration tips for DBAs, Performance Tuning tips, Disaster Recovery, RMAN, Dataguard and ORA errors solutions.
No contents from my website can be published anywhere else without my permission. Test every solution before implementing in the production environment.

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 ...
›
Home
View web version
Powered by Blogger.