how did you backup to tape. to restore from tape you would have to do something like run { allocate channel ch1 type sbt_tape; startup nomount restore controlfile ; alter database mount ; restore database; release channel ch1; }
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.
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
<DIV>how did you backup to tape.</DIV> <DIV>to restore from tape you would have to do something like </DIV> <DIV>run {</DIV> <DIV>allocate channel ch1 type sbt_tape;</DIV> <DIV>startup nomount </DIV> <DIV>restore controlfile ;</DIV> <DIV>alter database mount ;</DIV> <DIV>restore database;</DIV> <DIV>release channel ch1;</DIV> <DIV>}<BR><BR><B><I>dba1 mcc <mccdba1@(protected)></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER -LEFT: #1010ff 2px solid">I am doing RMAN backup/restore testing (ORACLE 9ir2). <BR>I backup whole database to tape, but don't know how to<BR>restore it back "diectly" from tape.<BR><BR>The procedures I doing are:<BR><BR><BR>RMAN> startup nomount<BR><BR>Oracle instance started<BR><BR>Total System Global Area 286766360 bytes<BR><BR>Fixed Size 451864 bytes<BR>Variable Size 167772160 bytes <BR>Database Buffers 117440512 bytes<BR>Redo Buffers 1101824 bytes<BR><BR>RMAN > show all;<BR><BR>using target database controlfile instead of recovery<BR >catalog<BR>RMAN configuration parameters are:<BR>CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default<BR>CONFIGURE BACKUP OPTIMIZATION OFF; # default<BR >CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default<BR>CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default<BR>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE <BR>TYPE DISK TO '%F'; # default<BR>CONFIGURE DEVICE TYPE D ISK PARALLELISM 1; # default<BR>CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK<BR>TO 1; # default<BR>CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE <BR>DISK TO 1; # default<BR>RMAN configuration has no stored or default parameters<BR>RMAN configuration has no stored or default parameters<BR >CONFIGURE MAXSETSIZE TO UNLIMITED; # default<BR>RMAN-00571:<BR>================ ===========================================<BR>RMAN-00569: =============== ERROR MESSAGE STACK<BR>FOLLOWS ===============<BR>RMAN-00571:<BR>==================== =======================================<BR>RMAN-03002: failure of show command at 08/19/2005<BR>11:28:22<BR>ORA-01507 (See ORA-01507.ora-code.com): database not mounted<BR><BR><BR><BR >RMAN> set dbid 4026107299<BR><BR>executing command: SET DBID<BR><BR>RMAN> restore controlfile from autobackup;<BR><BR>Starting restore at 19-AUG-05<BR> <BR>allocated channel: ORA_DISK_1<BR>channel ORA_DISK_1: sid=12 devtype=DISK<BR >channel ORA_DISK_1: looking for autobackup on day:<BR>20050819<BR>channel ORA_DISK_1: looking for autobackup on day:<BR >20050818<BR>channel ORA_DISK_1: looking for autobackup on day:<BR>20050817<BR >channel ORA_DISK_1: looking for autobackup on day:<BR>20050816<BR>channel ORA _DISK_1: looking for autobackup on day:<BR>20050815<BR>channel ORA_DISK_1: looking for autobackup on day:<BR>20050814<BR>channel ORA_DISK_1: looking for autobackup on day:<BR>20050813<BR>channel ORA_DISK_1: no autobackup in 7 days found<BR>RMAN-00571:<BR>======================================================= ====<BR>RMAN-00569: =============== ERROR MESSAGE STACK<BR>FOLLOWS ============= ==<BR>RMAN-00571:<BR>=========================================================== <BR>RMAN-03002: failure of restore command at 08/19/2005<BR>11:29:29<BR>RMAN -06172: no autobackup found or specified handle is<BR>not a valid copy or piece <BR><BR><BR><BR><BR>RMAN> configure CHANNEL device TYPE SBT<BR>PARMS="SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/u5/RMANTEST/CUPFLNX /TAPE)";<BR><BR>RMAN-00571:<BR>================================================= ==========<BR>RMAN-00569: =============== ERROR MESSAGE STACK<BR>FOLLOWS ======= ========<BR>RMAN-00571:<BR>===================================================== ======<BR>RMAN-03002: failure of configure command at 08/19/2005<BR>11:30:59<BR >ORA-01507 (See ORA-01507.ora-code.com): database not mounted<BR><BR>RMAN> <BR><BR>__ ____ ____ ____ _____ __ ____ ____ ____ ____ ____<BR>Do You Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around <BR>http://mail.yahoo.com <BR>--<BR>http://www .freelists.org/webpage/oracle-l<BR></BLOCKQUOTE>
