RE: RMAN Upgrading to 8.1.74. Voices in my head.

Mike - Did you consider doing a recovery using just the control file? It might sound odd, but even if you are doing a catalog backup, the backup information is still stored in the target database's control file.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, February 18, 2003 3:54 AM To: Multiple recipients of list ORACLE-L

RMAN (non)compatability,

Recently I ran into a problem myself:
o Target DBs (NT & W2k) were at 8.1.7.0 and catalog (Solaris) was at 8.1.7.2
(backups controlled from here using cron).
o Test recovery scenarios completed OK
(Voice in head says, 'NEW TO RMAN, GOTTA TEST!).
o A couple of months ago some NT DBs were upgraded to 8.1.7.4 but RMAN did not complain!
o Last week a restore of an 8.1.7.4 datafile was required but RMAN kept giving an error including the text: "...PLS-00302: Component 'LOCKFORCKPT' must be declared..."
(voices in head says, Got that CV up to date?)

Solution:
Luckily - we still had nightly cold backups that we hadn't got around to stopping yet!
So I was able to do a full cold restore (Also luckily only a test DB) Voice in my head says to me,
'MIKE THIS IS YOUR WARNING - UPGRADE RMAN CATALOG BEFORE A LIVE DATABASE GOES SCREWY!'
I upgraded RMAN catalog DB to 8.1.7.4 and issued the upgrade catalog command.

SOMETIMES INCOMPATIBILITY WILL LET YOU BACK UP BUT NOT RESTORE!
(Voice in head asks, 'RMAN - What is it good for, huh?'.

        There's an RMAN compatibility matrix on metalink (a bit confusing) and a note that is quite clear regarding 8.1.7.4. I've lost the doc ids but a search will find them.

• Mike.

-----Original Message-----
Sent: 18 February 2003 04:14
To: Multiple recipients of list ORACLE-L

We are upgrading to 8.1.7.4. There are many databases and my DBA college who is in charge of the RMAN Database that is currently 8.1.6. tells me that it is no problem that RMAN (Seperate database by the way) is in 8.1.6 and the Target is in 8.1.7.4. As RMAN is hot topic right now and before I go RTFM can anybody verify this or advise

thanks

Sam

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: rabbit_at_emirates.net.ae

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jenner Mike
  INET: M.Jenner_at_southampton.gov.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).