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: 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: database not mounted RMAN> __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l