SQL*Plus: Release 11.2.0.1.0 Production on Sun Feb 8 18:14:09 2015

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@localhost ~]$ rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Feb 8 18:14:36 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1380300748)

RMAN>

</div>\## Recovery Procedure ### 1. Create Backup Set <div>```
RMAN>backup as compressed backupset databse plus archivelog;

</div>\### 5. Adjust Parameter File Paths Modify the PFILE to reflect correct file locations for the new system. ### 6. Shutdown Database ### 7. Restart Databace in NOMOUNT State Use the updated PFILE to start the database in NOMOUNT mode. ### 8. Restore Control File <div>```
RMAN>restore controlfile from '/u01/app/testRMAN/autobackup/2015_02_08/o1_mf_s_871152044_bfgh9f42_.bkp';

</div>\### 10. Identify File Locations At this point, retrieve file paths from the restored control file: <div>```
(1) Check datafile locations
$ sqlplus / as sysdba;
select file#,name from v$datafile;

(2) Check online redo log files
select member from v$logfile;

(3) Check temporary files
SQL> select name from v$tempfile;

(4) List backup sets
RMAN>list backup;

(2) Restore datafiles with new paths RMAN> RUN { SET NEWNAME FOR DATAFILE 1 to '/u01/app/oracle/oradata/orcl/system01.dbf'; SET NEWNAME FOR DATAFILE 2 to '/u01/app/oracle/oradata/orcl/undotbs1.dbf'; SET NEWNAME FOR DATAFILE 3 to '/u01/app/oracle/oradata/orcl/sysaux01.dbf'; SET NEWNAME FOR DATAFILE 4 to '/u01/app/oracle/oradata/orcl/users01.dbf'; SET NEWNAME FOR DATAFILE 5 to '/u01/app/oracle/oradata/orcl/undotbs2.dbf'; RESTORE DATABASE; SWITCH DATAFILE ALL; };

(3) Update redo log file paths

su - oracle

$ sqlplus / as sysdba; SQL> alter database rename file '/u01/app/oracle/redo101.log' to '/u01/app/oracle/oradata/orcl/redo101.log';

(4) Perform incomplete recovery recover database until cancel; Note: If SCN mismatch occurs, enable hidden parameter _allow_resetlogs_corruption=true to start database and export required data via expdp.

</div></div>