Restore Controlfile to specific location using RMAN

Restore Controlfile to specific location using RMAN

1. Restore controlfile to a location

RMAN> restore controlfile to '/u01/app/oracle/oradata/orcl/control01.ctl' 
from '/back/rman/controlfile.bkp';

2. Connect sqlplus as sysdba and controlfile location

[oracle@localhost ~]$ sqlplus / as sysdba  
  
SQL*Plus: Release 11.2.0.2.0 Production on Fri Nov 9 07:54:50 2012  
  
Copyright (c) 1982, 2010, Oracle.  All rights reserved.  
  
Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production  
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter control_files  
  
NAME                                 TYPE        VALUE  
------------------------------------ ----------- ------------------------------  
control_files                        string      /home/oracle/app/oracle/oradata/orcl/control01.ctl,   

3. Change controlfile location where restored using spfile and shutdown instance

SQL> alter system set control_files='/u01/app/oracle/oradata/orcl/control01.ctl' scope=spfile;  
  
System altered.   


SQL> shutdown immediate;  
ORA-01507: database not mounted  
  
  
ORACLE instance shut down.

4. start it again in MOUNT mode using RMAN. 

[oracle@localhost ~]$ rman target /  
  
Recovery Manager: Release 11.2.0.2.0 - Production on Fri Nov 9 07:56:56 2012  
  
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.  
  
connected to target database (not started)  
  
RMAN> startup mount;  
  
Oracle instance started  
database mounted  
  
Total System Global Area     456146944 bytes  
  
Fixed Size                     1344840 bytes  
Variable Size                364907192 bytes  
Database Buffers              83886080 bytes  
Redo Buffers                   6008832 bytes  

5. We have to perform a recovery of the database after the restore of the control file, 
even if any datafile was restored. 

RMAN> recover database;  

6. After the restore of the control file you have to open the database with RESETLOGS option. 

RMAN> alter database open resetlogs;  
  
database opened

SQL> show parameter control_file  
  
NAME                                 TYPE        VALUE  
------------------------------------ ----------- ------------------------------  
control_file_record_keep_time        integer     7  
control_files                        string      /u01/app/oracle/oradata/orcl/control01.ctl


Thats it.....