How RMAN Compressed Backupset
You can enable the compression feature of RMAN by the following 2 ways: One time setting RMAN> show all; RMAN configuration parameters for database with… Read More »How RMAN Compressed Backupset
Backup and Recovery
How to Resolve ORA-19505: failed to identify file
ORA-19505 There're two error patterns of ORA-19505 in this post. Cloning a PDB Duplicating a Database 1. Cloning a PDB Tried to clone a Pluggable… Read More »How to Resolve ORA-19505: failed to identify file
How to Resolve ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
ORA-00265 I bet your database is 8i or 9i and you were trying to startup the database along with a set of procedure in a… Read More »How to Resolve ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
How to Check Oracle Data Files Healthy
Two ways that you can verify data files, one is using Oracle utility dbverify, the other is RMAN command.DbverifyWe can use dbv to check specific… Read More »How to Check Oracle Data Files Healthy
How RMAN Restore Archivelog to Different Location
Here is my case, I would like to resolve the gap between the primary and the standby database, but the log_archive_dest_1 is very limited, I… Read More »How RMAN Restore Archivelog to Different Location
How to Resolve RMAN-20242: specification does not match any archive log in the recovery catalog
Got an error RMAN-20242 when I tried to backup a specific range of online archived logs that have moved back from another temporary place. I… Read More »How to Resolve RMAN-20242: specification does not match any archive log in the recovery catalog
Don't Forget to Add Tempfiles Back After Restoring 9i Database
If your database is 10g onward, you don't have to worry about it, the control file will recreate the tempfiles after database restore, but for… Read More »Don't Forget to Add Tempfiles Back After Restoring 9i Database
Why Should I Know DBID of a Database
Different database has their own DBID that can make recovery catalog distinguish which is which, but in the same data guard infrastructure, the database, either… Read More »Why Should I Know DBID of a Database
How to Resolve ORA-01153 an incompatible media recovery is active
ORA-01153 Got an error ORA-01153 like this: SQL> recover standby database until cancel; ORA-01153: an incompatible media recovery is active Let's see the content of… Read More »How to Resolve ORA-01153 an incompatible media recovery is active
How to Resolve ORA-27192
If you met an error like the following.ORA-27192: skgfcls: sbtclose2 returned error - failed to close fileORA-19511: Error received from media manager layer, error text: … Read More »How to Resolve ORA-27192