How RMAN Restore Database from BackupSet
In this post, I will show you how to restore a single-instance database from a backup set by RMAN. For RAC restoration, you may check… Read More »How RMAN Restore Database from BackupSet
RMAN
How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
RMAN-06149 Trying to backup a database in the development environment. But failed with "RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode". RMAN> backup database tag 'BEFORE-IMPORT-PRODUCTION-2018Q1';… Read More »How to Resolve RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
Online Archived Logs vs Backup Archived Logs
Let me make it short first. If you can tell the difference between the following two RMAN statements, then you have already know the difference.… Read More »Online Archived Logs vs Backup Archived Logs
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
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 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
Switch Database To Copy
Move Database by RMAN In the previous post, we have talked about how to move data files in a tablespace to another place by RMAN.… Read More »Switch Database To Copy
Switch Tablespace To Copy
Move Tablespace by RMAN No like we move individual data file to another place by RMAN, changing the location of a tablespace by RMAN is… Read More »Switch Tablespace To Copy