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

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Fri, 19 Aug 2005 09:42:12 -0700 (PDT)
Message-ID: <20050819164212.62363.qmail@web80513.mail.yahoo.com>

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_at_yahoo.com> 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

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

Received on Fri Aug 19 2005 - 11:44:19 CDT