Control file recovery, from RMAN

[greenchille]

Hi
(ORACLE VERSION 8.1.7.4)
I am testing my rman backup and recovery. Backup was successfull.
The script for my backup is
run {
${channel1}
${channel2}
backup incremental level ${inclevel}
filesperset 5
tag ${mytag}
format
'${format}.bus' database include current controlfile;
sql 'alter system archive log current';
backup filesperset 50
archivelog all
format
'${format}.bar'${format_arc_del};
release channel c1;
release channel c2;
}

as my format is *.bus
------------
Now to the question, I was able to recover the database using rman, if the controlfile is good. If I lost the control file?, so I want to test the recover the control file using the latest rman backup (here it is full backup).
I tried all the sorts.. couldn't
Any Ideas.
Thx
C

[davey23uk]

what did you try

[LKBrwn_DBA]

Just restore the cotrolfile:

CONNECT TARGET /
CONNECT CATALOG RMANCAT/FOOBAR@RMAN
STARTUP FORCE NOMOUNT PFILE=$ORACLE_HOME/DBS/INIT.ORA
RUN {
 ALLOCATE CHANNEL CH1 TYPE DISK;
 SET UNTIL SCN=1447485626;
 RESTORE CONTROLFILE;
 SQL ‘ALTER DATABASE MOUNT’;
} 

[greenchille]

hello Lkbrwn
I am connecting to rman with 'no catalog' option. Are the same steps do follow. How do we get the SCN?
Thx
Appreciate your responce
C

[LKBrwn_DBA]

Without catalog, you may need to supply the backup file name -- no SCN necesary (yet), but you need to set the dbid:

SET DBID=<integer>
RUN {
ALLOCATE CHANNEL CH1 TYPE DISK; 
RESTORE CONTROLFILE FROM FILE '<path>/<bkp file>'; 
SQL ‘ALTER DATABASE MOUNT’; 
} 

To restore the DB you may need an SCN or SET UNTIL TIME...


PS: Pls check for correct syntax.

[KenEwald]

Do you have a controlfile to recover?
Is your controlfile part of your backup?
Is AUTOBACKUP CONTROLFILE on?

Ken

[greenchille]

Hi Brwn,
I tried what you said but, it
RUN {
2> ALLOCATE CHANNEL CH1 TYPE DISK;
3> RESTORE CONTROLFILE FROM FILE '/backup/prod/backup/full/rman_PROD_601742701_0jhtrnbd.bus';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "tag"
RMAN-01008: the bad identifier was: FILE
RMAN-01007: at line 3 column 26 file: standard input

Got the above error.
Any idea?.

[greenchille]

hello Ken
As part of my backup. I did the following things
for there i am include the control file too
***
format
'${format}.bus' database include current controlfile;
sql 'alter system archive log current';
*****
(can check my Question on top)
format="$disk_full/rman_%d_%t_%u"
disk_full =/backup/xx/yy/full/

?? How to check AUTOBACKUP CONTROLFILE on?
Thx
C

[waitecj]

?? How to check AUTOBACKUP CONTROLFILE on?

"show all;" at the RMAN prompt.

[LKBrwn_DBA]

Hi Brwn,
I tried what you said but, it
RUN {
2> ALLOCATE CHANNEL CH1 TYPE DISK;
3> RESTORE CONTROLFILE FROM FILE '/backup/prod/backup/full/rman_PROD_601742701_0jhtrnbd.bus';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "tag"
RMAN-01008: the bad identifier was: FILE
RMAN-01007: at line 3 column 26 file: standard input

Got the above error.
Any idea?.

That is why I said "Check for correct syntax", I kinda posted from memory.

Try removing the "FILE" word.