-
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
|