How to Recover the Oracle 10g 11g Database from RMAN Cold Backup

advertisements

_____________________________________________________________________________________________________________________

Some facts on RMAN Cold Backup

• RMAN cold backup is taken on database mount state
• After RAMN cold backup Recovery database needs to be open with resetlogs option.

RMAN steps for Cold Backup

Connect to RMAN

rman target /

RMAN>

run {

shutdown immediate;

startup mount;

allocate channel c1 type disk;

allocate channel c2 type disk;

backup full tag BACKUPFULL

(database include current controlfile);

}

RMAN Steps to Recovery from Cold Backup

Step 1

Connect to sqlplus / RMAN and startup the database with nomount option.

Startup nomount;

Step 2

Restore the control file either from AUTOBACKUP or from Backup piece

Need to find out the backup piece name from the TAG. The below mentioned command will give you the backup piece details. Then you can restore the database.

RMAN> list backup tag BACKUPFULL;

You can use either one of the following to restore the control file

Option 1 From AUTOBACKUP

RMAN>

run {

startup mount;

restore controlfile from autobackup;

restore database;

recover database;

alter database open resetlogs;

}

Option 2 From Backup Piece.

RMAN>

Run {

Restore controlfile from ‘+RECO/backups/prod1_cf_c-1744152489-20111109-00’;

restore database;

recover database;

alter database open resetlogs;

     }

_____________________________________________________________________________________________________________________

Website Stats