OraFAQ Forum: Backup & Recovery » Rman restore control files with oracle8.1.7

Home » RDBMS Server » Backup & Recovery » Rman restore control files with oracle8.1.7

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

Rman restore control files with oracle8.1.7 [message #253815]

Tue, 24 July 2007 23:14

chara
Messages: 81
Registered: April 2005
Location: th

Member

Dear all,

I had a problem with rman restore all control files as below step.

SQL> startup nomount

RMAN> run {
2> allocate channel ch1 type disk;
3> restore controlfile;
4> }

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

What happended? Pls advise me.
Thanks for advance
Chara

Report message to a moderator

Re: Rman restore control files with oracle8.1.7 [message #253838 is a reply to message #253815]

Wed, 25 July 2007 01:12

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to use "set dbid" to indicate to RMAN on which database it has to work.
As your database is not mounted (as you want to restore the control file), RMAN cannot get the DBID from the control file, so you have to tell it.

Regards
Michel

Report message to a moderator

Re: Rman restore control files with oracle8.1.7 [message #254136 is a reply to message #253815]

Wed, 25 July 2007 20:42

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thanks for your replied.I tried to set dbid=xxx ;It didn't work.

Can set dbid for oracle 8.1.7 ?

Rdgs,
Chara

Report message to a moderator

Re: Rman restore control files with oracle8.1.7 [message #254167 is a reply to message #254136]

Thu, 26 July 2007 01:06

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle8i Recovery Manager User's Guide and Reference
Chapter 10 Recovery Manager Command Syntax
Section set

Regards
Michel

Report message to a moderator

Re: Rman restore control files with oracle8.1.7 [message #254210 is a reply to message #253815]

Thu, 26 July 2007 03:09

chara
Messages: 81
Registered: April 2005
Location: th

Member

Hi Michel,
Its works well.

Thank you.
Chara.

Report message to a moderator

Previous Topic:	How Can Get Which Backup unnesessary to Delete Using RMAN
Next Topic:	Why it is searching SBT_TYPE?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 22:13:10 CDT 2024