Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

rman restore controlfile error

AzarNov 15 2009 — edited Nov 16 2009
hi,

For testing purpose,

I created rman catalog and configure controlfile autobackup.after that i took backup using follow command.

sql>run

2 {
3 allocate channel c1 type disk format 'd:\oracle\rman\backup\%s_%p_%t';
4 backup database;
5 backup archivelog all;
6 release channel c1;
7 }
the data backuped. after backup i down the database and delete controlfile and tablespace and redolog file.
after that i plan to restore the control file.so that i using follow command and i get a error


C:\Documents and Settings\SUBAIH>set oracle_sid=orcl

C:\Documents and Settings\SUBAIH>rman target sys/sys

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Nov 16 13:53:54 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: orcl (not mounted)

RMAN> restore controlfile from autobackup;

Starting restore at 16-NOV-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/16/2009 13:54:12
RMAN-06495: must explicitly specify DBID with SET DBID command

RMAN>

How do i set the DBID? and when i take backup ,the above path ('d:\oracle\rman\archive\") having three files are located.which one i choose? or anyother way to restore the controlfile...


Regards

Azar
DBA
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2009
Added on Nov 15 2009
14 comments
6,833 views