OraFAQ Forum: Backup & Recovery » Control file recovery

Home » RDBMS Server » Backup & Recovery » Control file recovery

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Control file recovery [message #196137]

Wed, 04 October 2006 05:17

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

i am using 8i and create a backup set with the following script without recovery catalog
run {allocate channel c1 type disk
format 'c:\backup\test_db_%U';
backup database include current controlfile;
copy current controlfile to 'c:\backup\control1.ctl';}

Now i have lost all of my control files and want to restore control file by using the following steps

1-C:\>rman nocatalog

2-RMAN> connect target sys/gateway@wizmen
RMAN-06193: connected to target database (not started)

3-RMAN> set dbid=3460708078
4-RMAN> startup nomount

5- RMAN> run{allocate channel c1 type disk;
restore controlfile;
sql 'alter database mount';}

And i got the error

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=10 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06003: ORACLE error from target database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 4461
ORA-06512: at line 1
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . setDatabase ( upp
er ( :dbname:dbname_i ) , :rlscn , :rltime , :fhdbi:fhdbi_i ) ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 9196

I have tried all to recover the control files but unable to do so
can anybody help me in this regard?
thanx in advance

Report message to a moderator

Re: Control file recovery [message #196647 is a reply to message #196137]

Fri, 06 October 2006 06:25

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Try to restore the control file manually by copying the backup to its proper locations (looks at the CONTROL FILES= parameter).

Report message to a moderator

Re: Control file recovery [message #196740 is a reply to message #196647]

Fri, 06 October 2006 23:18

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

if we have an RMAN backup of control file then why it is not possible to restore from that backup
is there something wrong in it?

Report message to a moderator

Re: Control file recovery [message #196752 is a reply to message #196740]

Sat, 07 October 2006 01:06

pareshjavkar
Messages: 7
Registered: October 2006
Location: Mumbai

Junior Member

Hi,

Try this:

set autobackup on

RMAN> configure controlfile autobackup on;

This will ensure that you always have an updated controlfile available that has been taken at the end of current backup and not during as it always does.

Report message to a moderator