RE: [Q] How RMAN restore control file from tape?
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <mccdba1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Aug 2005 15:21:33 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of dba1 mcc
Sent: Friday, August 19, 2005 11:37 AM
To: oracle-l@xxxxxxxxxxxxx
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.
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
