rman restore controlfile error
AzarNov 15 2009 — edited Nov 16 2009hi,
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