How to Backup and Recovery Using Backup as Oracle RMAN Image Copy

advertisements

_____________________________________________________________________________________________________________________

RMAN image copy backup will take more space than the normal RMAN backup as it takes the entire datafile file as backups. But some situations we can use this method to backup and restore the database. Here is the method and RMAN command syntax for the same.

1.   Backup the database

rman / as sysdba 

Backup copy of database;

2.   Restoration Steps

RMAN> restore controlfile from '/export/nonprd/BACKUP/PRODDB/cntl_PRODDB_20160306

_o5qvqsan_1_1';

output file name=+DATA/PRODDBX3S/CONTROLFILE/current.1147.905804585

output file name=+RECO/PRODDBX3S/CONTROLFILE/current.14063.905804587

rename the files in mount state as per the physical to the as in the control file.

list copy of database;

recover database 

alter database open resetlogs;

Push the files to To asm 

run {

backup as copy database format '+DATA' ;

switch datafile all ;

}

 switch database to copy;

 delete copy of database;

_____________________________________________________________________________________________________________________

Website Stats