Re: [Q] How RMAN restore control file from tape?

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@xxxxxxxxx> 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: 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 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: