Category Archives: RMAN
RMAN Restore Preview
The PREVIEW option of the RESTORE command allows you to identify the backups required to complete a specific restore operation. The output generated by the command is in the same format as the LIST command. In addition the PREVIEW SUMMARY command can be used to produce a summary report with the same format as the [...]
Migrate from 32 bit to 64 bit using RMAN
Migrate from 32 bit to 64 bit using RMAN
RMAN – Recatalog – Flash Recovery Area
RMAN – Recatalog – Flash Recovery Area
RMAN Notes
1.1. Where should the catalog be created? The recovery catalog to be used by rman should be created in a seperate database other than the target database. The reason been that the target database will be shutdown while datafiles are restored. 1.2. How do I create a catalog for rman? First create the user rman. [...]
RMAN-6038 and RMAN-20003 after Alter Database Open Resetlogs
You must use the reset database command in RMAN to create a new database incarnation record in the recovery catalog. % rman connect target user/pwd catalog user/pwd RMAN> reset database; Immediately back up the database. This will give the database a new incarnation. Explanation: If you issue the ALTER DATABASE OPEN RESETLOGS but do not [...]
Oracle Backup and Recovery on Windows, Disaster Recovery using RMAN
Oracle Backup and Recovery on Windows, Disaster Recovery using RMAN
RMAN -Recovery from missing or corrupted control file
RMAN -Recovery from missing or corrupted control file
RMAN – Recovery from missing or corrupted redo log group
RMAN – Recovery from missing or corrupted redo log group
RMAN- Recovery from block corruption
RMAN- Recovery from block corruption
RMAN – Recovery from missing or corrupted datafile
RMAN – Recovery from missing or corrupted datafile
I have attended Ask Tom Live seminar about 11g Rel2 at Tokyo, Japan. Do you believe it I have got an opportunity to take a snap with him. I am very happy to share with you.