RE: 9.2.0.7 RMAN blues

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 21 Sep 2005 11:54:49 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD5FAA@ecogenemld50.Org.Collegeboard.local>

If you have a binary copy (or RMAN backup) of the controlfile *after* the last backup, but *before* the 9207 upgrade and all of the RMAN (datafile) backupsets you should be fine. Well you probably need a few backed up arch logs, but you should be good.

If you have a good controlfile...
all the backup sets of datafiles...
and a few arch logs...
this is a rather easy restore and recovery.

On the restored (replicated) crontrolfile by RMAN, do a;

$>strings /u01/app/oracle/product/oracle9i/dbs/control1.ctl | grep [BACKUP SET NAME]
This is how you can see if the controlfile you has restored is aware of the datafile backup sets. Also you can use some RMAN :list" commands with the restored controlfile.

Also I assume you still have and are pointed the 9205 Oracle binaries?

hth

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Gogala, Mladen Sent: Wed 9/21/2005 10:17 AM
To: 'vitalisman_at_gmail.com'; gogala_at_sbcglobal.net Cc: oracle-l
Subject: RE: 9.2.0.7 RMAN blues  

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 - 10:58:55 CDT