Home » RDBMS Server » Backup & Recovery » Rman restore control files with oracle8.1.7
Rman restore control files with oracle8.1.7 [message #253815] Tue, 24 July 2007 23:14 Go to next message
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
Re: Rman restore control files with oracle8.1.7 [message #253838 is a reply to message #253815] Wed, 25 July 2007 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Rman restore control files with oracle8.1.7 [message #254136 is a reply to message #253815] Wed, 25 July 2007 20:42 Go to previous messageGo to next message
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
Re: Rman restore control files with oracle8.1.7 [message #254167 is a reply to message #254136] Thu, 26 July 2007 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: Rman restore control files with oracle8.1.7 [message #254210 is a reply to message #253815] Thu, 26 July 2007 03:09 Go to previous message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Hi Michel,
Its works well.

Thank you.
Chara.
Previous Topic: How Can Get Which Backup unnesessary to Delete Using RMAN
Next Topic: Why it is searching SBT_TYPE?
Goto Forum:
  


Current Time: Thu Dec 08 00:30:29 CST 2016

Total time taken to generate the page: 0.08184 seconds