Backup and Recovery
Normally and generally, recovery catalog recognizes the databases by DBID which is a unique number among different databases. But there's a problem: the primary database… Read More »How does Recovery Catalog Recognize Databases Which is Which?
It depends, depends on what kind of backup mode that you had taken. If you took a full backup by the following ways, then you… Read More »Are All Oracle Full Backups Consistent?
You might mistakenly think the backup sets of full backup taken by RMAN online are always consistent and self-contained. No, they're not. Actually, they're usually… Read More »How to Make a Self-Contained and Consistent Full Backup Set
No, you can't, because 9i does not support these "Re-catalog" commands below that are supported by 10g onwards:CATALOG START WITHCATALOG BACKUPPIECECATALOG RECOVERY AREAYou can't even… Read More »How Can I Catalog Backup Sets in a Different 9i Database
ORA-27211 Saw ORA-27211 which caused the RMAN operation to fail. RMAN> ... ... ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to… Read More »How to Resolve ORA-27211: Failed to load Media Management Library
Let's say, our RMAN is currently running on the channel 'SBT_TAPE' by default. We're planing to switch the default channel to DISK before tapes for shortening… Read More »How to Switch the Default Channel From One to Another
ORA-19573 It's pretty easy to reproduce ORA-19573 because the solution is pretty easy, too. In this post, I will show you two run blocks on… Read More »How to Resolve ORA-19573: cannot obtain exclusive enqueue for datafile 1
If your database is running on Enterprise Edition, then you can have encryption and compression option. Let's see the version we are running first.SQL> select… Read More »How to Backup and Restore Under Encryption and Compression