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



The Eucharistic Miracles of the World
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
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


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer