I have lost my spfile and controlfile which are stored in the ASM disk and now I am trying to restore the spfile & controlfile from the autobackup and it is not enabled with the recovery catalog. This article covers only the controlfile restore and i have updated another article with SPFILE restore.
Note: This is for the RAC database and I am started with one instance till I complete the entire process, i am not going to do anything on the second instance. I am doing the autobackup to the TAPE.
Note: when you are allocating the channel & no of channels, you have specifiedAccordingly to system perform. It can be either from disk & tape. In the below example i have used TAPE. so i have used the below option.
RESTORING CONTROLFILE (WITH OUT RECOVERY CATALOG & AUTOBACKUP ON MODE)
bhuora01[BHU_1]>rman target /
Recovery Manager: Release 18.104.22.168.0 - Production on Thu Oct 6 17:26:15 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: BHU (not mounted)
RMAN> set DBID 1726821198;
executing command: SET DBID
allocate channel 'dev_0' type 'sbt_tape'
parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=BHU_A,OB2BARLIST= bhuora01_ORA_BHU_ON_Weekly)';
restore controlfile from autobackup;
2> 3> 4> 5> 6>
using target database control file instead of recovery catalog
allocated channel: dev_0
channel dev_0: SID=67 instance=BHU_1 device type=SBT_TAPE
channel dev_0: Data Protector A.06.11/PHSS_41802/PHSS_41803/DPSOL_00435/DPLNX_
Starting restore at 06-OCT-11
channel dev_0: looking for AUTOBACKUP on day: 20111006
channel dev_0: AUTOBACKUP found: c-1726821198-20111006-00
channel dev_0: restoring control file from AUTOBACKUP c-1726821198-20111006-00
channel dev_0: control file restore from AUTOBACKUP complete
output file name=+BHU_DATA1/BHU_a/controlfile/current.271.763839227
output file name=+BHU_ARCH/BHU_a/controlfile/current.369.763839227
output file name=+BHU_RECO/BHU_a/controlfile/current.281.763839227
Finished restore at 06-OCT-11
released channel: dev_0
Note: Here the controlfile locations are picked up from the SPFILE.
Once you restore the control file, you have to check the control_files values and if it different in the ASM DISKGROUP then you have to modify the control_files values in the spfile. You have to issue a alter system command to update for entire instances with sid='*' and start the RAC database.