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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
