RSS:
Publications
Comments

Category Archives: RMAN

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 [...]

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 [...]

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

RMAN Incomplete Recovery

RMAN Incomplete Recovery