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

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 19 Aug 2005 15:21:33 -0400
Message-ID: <00eb01c5a4f3$3583b780$6759000a@vttaxnet.tax.state.vt.us>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of dba1 mcc Sent: Friday, August 19, 2005 11:37 AM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 19 2005 - 14:24:25 CDT