In 9i, RMAN sets autobackup off as well device type to disk by default. since you got to restore from tape, you have to either allocate channel of type sbt or change the default device type to sbt to do any restores.
In your case, i'd do
rman target / set dbid <dbid> startup nomount; run { allocate channel ch1_tape type sbt; set controlfile autobackup format for device type sbt to 'path_to_controlfile/%F'; -- i assume you haven't changed controlfile format. otherwise, replace %F with custom format. restore controlfile from autobackup; alter database mount; restore database; recover database; release channel ch1_tape; } alter database open resetlogs; exit;
Note : Startup nomount will always list oracle's default RMAN configuration. you don't get to see any customized configuration unless you mount the database from the controlfile.
Regards, Stalin
On 8/19/05, dba1 mcc <mccdba1@(protected)> wrote: > I am doing RMAN backup/restore testing (ORACLE 9ir2). > I backup whole database to tape, but don't know how to > restore it back "diectly" from tape. > > The procedures I doing are: > > > RMAN> startup nomount > > Oracle instance started > > Total System Global Area 286766360 bytes > > Fixed Size 451864 bytes > Variable Size 167772160 bytes > Database Buffers 117440512 bytes > Redo Buffers 1101824 bytes > > RMAN> show all; > > using target database controlfile instead of recovery > catalog > RMAN configuration parameters are: > CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default > CONFIGURE BACKUP OPTIMIZATION OFF; # default > CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default > CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE > TYPE DISK TO '%F'; # default > CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default > CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK > TO 1; # default > CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE > DISK TO 1; # default > RMAN configuration has no stored or default parameters > RMAN configuration has no stored or default parameters > CONFIGURE MAXSETSIZE TO UNLIMITED; # default > RMAN-00571: > =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK > FOLLOWS =============== > RMAN-00571: > =========================================================== > RMAN-03002: failure of show command at 08/19/2005 > 11:28:22 > ORA-01507 (See ORA-01507.ora-code.com): database not mounted > > > > RMAN> set dbid 4026107299 > > executing command: SET DBID > > RMAN> restore controlfile from autobackup; > > Starting restore at 19-AUG-05 > > allocated channel: ORA_DISK_1 > channel ORA_DISK_1: sid=12 devtype=DISK > channel ORA_DISK_1: looking for autobackup on day: > 20050819 > channel ORA_DISK_1: looking for autobackup on day: > 20050818 > channel ORA_DISK_1: looking for autobackup on day: > 20050817 > channel ORA_DISK_1: looking for autobackup on day: > 20050816 > channel ORA_DISK_1: looking for autobackup on day: > 20050815 > channel ORA_DISK_1: looking for autobackup on day: > 20050814 > channel ORA_DISK_1: looking for autobackup on day: > 20050813 > channel ORA_DISK_1: no autobackup in 7 days found > RMAN-00571: > =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK > FOLLOWS =============== > RMAN-00571: > =========================================================== > RMAN-03002: failure of restore command at 08/19/2005 > 11:29:29 > RMAN-06172: no autobackup found or specified handle is > not a valid copy or piece > > > > > RMAN> configure CHANNEL device TYPE SBT > PARMS="SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u5/RMANTEST/CUPFLNX/TAPE)"; > > RMAN-00571: > =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK > FOLLOWS =============== > RMAN-00571: > =========================================================== > RMAN-03002: failure of configure command at 08/19/2005 > 11:30:59 > ORA-01507 (See ORA-01507.ora-code.com): database not mounted > > RMAN> > > __ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > -- > http://www.freelists.org/webpage/oracle-l > -- http://www.freelists.org/webpage/oracle-l
