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

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;
     }
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google