Are you also backing up the controlfile specifically? What is the script used to create the backup? How does the backup get to tape, I only see device type disk? And even more salient, why don't you use a recovery catalog? What Oracle support told me; the recovery catalog will be going away. It isn't gone yet so it only makes sense to use one unless you enjou being on the bleeding edge. See Dennis' reply and I suggest you have another look at the Backup and Recovery Manual.
Good luck, Ruth
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)]On Behalf Of dba1 mcc Sent: Friday, August 19, 2005 11:37 AM To: oracle-l@(protected) Subject: [Q] How RMAN restore control file from tape?
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.
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
