RE: 9.2.0.7 RMAN blues

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Wed, 21 Sep 2005 10:17:39 -0400
Message-ID: <A2C7821363A0544987988F6BCCE941B5060839@pegasus.lawaudit.com>

See for yourself:

RMAN> set echo on

2> connect target /
3> startup force nomount
4> set dbid=2675037873;
5> run {
6> allocate channel c1 device type disk format

'/u05/tas_hot_bkp/bkp_hot_%U';
7> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u05/tas_hot_bkp/b
kp_hot_cont_%F';
8> restore controlfile from autobackup;
9> alter database mount;

10> restore database;
11> }
12>

echo set on

connected to target database: TAS (not mounted)

Oracle instance started

Total System Global Area 756029144 bytes

Fixed Size                      456408 bytes
Database Buffers             637534208 bytes
Redo Buffers                    598016 bytes

executing command: SET DBID

using target database controlfile instead of recovery catalog allocated channel: c1
channel c1: sid=10 devtype=DISK

executing command: SET CONTROLFILE AUTOBACKUP FORMAT

Starting restore at 20-SEP-05

channel c1: looking for autobackup on day: 20050920
channel c1: looking for autobackup on day: 20050919
channel c1: looking for autobackup on day: 20050918
channel c1: looking for autobackup on day: 20050917
channel c1: looking for autobackup on day: 20050916
channel c1: looking for autobackup on day: 20050915
channel c1: autobackup found:

/u05/tas_hot_bkp/bkp_hot_cont_c-2675037873-2005091 5-02
channel c1: controlfile restore from autobackup complete replicating controlfile
input filename=/u01/app/oracle/product/oracle9i/dbs/control1.ctl output filename=/u01/app/oracle/product/oracle9i/dbs/control2.ctl Finished restore at 20-SEP-05

database mounted

Starting restore at 20-SEP-05

released channel: c1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/20/2005 17:42:12
RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 79 found to restore RMAN-06023: no backup or copy of datafile 78 found to restore .....
^@MAN-06023: no backup
Recovery Manager complete.

--

Mladen Gogala
Ext. 121

-----Original Message-----

From: Vitalis Jerome [mailto:vitalisman_at_gmail.com] Sent: Wednesday, September 21, 2005 10:07 AM To: gogala_at_sbcglobal.net
Cc: oracle-l
Subject: Re: 9.2.0.7 RMAN blues

Even after restoring a controlfile backup from before the upgrade??
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 21 2005 - 09:18:08 CDT