RMAN Restore

Using RMAN to restore from production to development env, using a cold backup

*Make Sure you put any maintenance jobs such as backup job ON_ICE before running this.

SQL>shutdown immediate
SQL>startup mount restrict
SQL> create pfile from spfile

cp pfile spfile to /dbbackups/backup_srj_10222013
SQL> select dbid,name,log_mode,open_mode from v$database;
SQL> drop database



RMAN TARGET /
RMAN> startup nomount;
RMAN> restore controlfile from '/dbbackups/SBLDEV3/backups/cf_SBLDEV3_309_20131019_9lomqll6_1_1_DB';
RMAN> alter database mount;
RMAN> restore database;
RMAN> alter database open resetlogs;
RMAN>