Control File Recovery
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
Another post across multiple forums!
Personally, if I wanted to restore a controlfile I would look in the Oracle 8i Backup and Recovery manual to see if there was a section entitled "Restoring Controlfiles". When I found that section I would read it.
http://download-west.oracle.com/docs...eco.htm#440115
Having read it I would follow its advice and not need to post the same question to every Oracle forum I could find.
Tim...
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width
Bookmarks