Home » RDBMS Server » Backup & Recovery » Control file recovery
Control file recovery [message #196137] Wed, 04 October 2006 05:17 Go to next message
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


Re: Control file recovery [message #196647 is a reply to message #196137] Fri, 06 October 2006 06:25 Go to previous messageGo to next message
Frank Naude
Messages: 4502
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).
Re: Control file recovery [message #196740 is a reply to message #196647] Fri, 06 October 2006 23:18 Go to previous messageGo to next message
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?
Re: Control file recovery [message #196752 is a reply to message #196740] Sat, 07 October 2006 01:06 Go to previous messageGo to next message
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.
Re: Control file recovery [message #196771 is a reply to message #196752] Sat, 07 October 2006 03:58 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
but the problem is we are using 8i
and i think this option is not available in 8i
Re: Control file recovery [message #197520 is a reply to message #196137] Wed, 11 October 2006 10:45 Go to previous message
aladdha
Messages: 4
Registered: October 2006
Location: Mumbai
Junior Member

Hi

In ORacle 8i following commands can be used..

backup current controlfile;
or
database include current controlfile;
Previous Topic: Share: Rman backup scripts, version: 8.1.6 on windows32bit
Next Topic: DB is very slow
Goto Forum:
  


Current Time: Tue Dec 06 08:23:13 CST 2016

Total time taken to generate the page: 0.13533 seconds