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
An error thrown by RMAN interrupted a run block which ran the restore and recovery of a database:Finished restore at 2015-06-03 19:04:14Starting recover at 2015-06-03… Read More »How to Resolve ORA-03114: not connected to ORACLE in RMAN
ORA-00257 A scheduler job which is refreshing materialized views threw an error ORA-00257 in the alert log like this: ORA-12012: error on auto execute of… Read More »How to Resolve ORA-00257: archiver error. Connect internal only, until freed.