Re: [Q] How RMAN restore control file from tape?
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 19 Aug 2005 09:42:12 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
