RE: Upgrading Target Database in RMAN

Jared,

Two key points here:

1. The catalog must be as new as, if not new than, the target db before a new rman backup will work.
2. No action is required on target database after the upgrade if requirement 1 is met. Since your RMAN is run by the rman executable on the target node, it (the catalog) knows what version it is backing up.
3. If you did need to restore the older version of the database, you would likely need to restore the old version of the oracle binaries.

No, unregister is not an attractive option for reasons you have already mentioned.

HTH,
-Ron-

-----Original Message-----
Sent: Sunday, February 16, 2003 1:04 AM
To: Multiple recipients of list ORACLE-L

Thanks Stephen, but 'upgrade catalog' is used to upgrade the RMAN catalog when the repository database is upgraded.

Jared

On Saturday 15 February 2003 21:18, Stephen Lee wrote:
> I've done this ... now if I can just remember ...
> The repository version has to be at least as high as the database
> version. That much I know for sure. It's easy to do. I think you
> just execute the "upgrade catalog" command. If this condition is met,
> then you will find out real fast if you need to re-register the
> database when you run a backup. I don't recall needing to do this.
> But if you think about it, restoring a pre-upgrade backup would put
> you back to your old version of the database while your binaries are
> at the new version. Hmmmm.....
>
> > -----Original Message-----
> > From: Jared Still [mailto:jkstill_at_cybcon.com]
> > Sent: Saturday, February 15, 2003 8:49 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Upgrading Target Database in RMAN
> >
> >
> >
> > Yeah, I guess that's an option also.
> >
> > Still seems like a workaround though.
> >
> > Jared
> >
> > On Saturday 15 February 2003 15:18, Tim Gorman wrote:
> > > How about running in NOCATALOG mode for a while?
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > Sent: Saturday, February 15, 2003 11:38 AM
> > >
> > > > Yes, I've thought of doing that.
> > > >
> > > > It just makes it much harder to restore the old database from
> > > > tape should the need arise.
> > > >
> > > > Maybe I'll export the repository and re-import it somewhere else
> > > > for a few weeks safe keeping.
> > > >
> > > > Jared
> > > >
> > > > On Saturday 15 February 2003 03:38, Rachel Carmichael wrote:
> > > > > without knowing too much about RMAN, but from things
> >
> > I've gathered from
> >
> > > > > the list....
> > > > >
> > > > > can you "unregister" the current db (after a backup of
> >
> > course) and then
> >
> > > > > register the new version once it's ready?
> > > > >
> > > > > --- Jared.Still_at_radisys.com wrote:
> > > > > > Here I am, still at work at 10:00 PM.
> > > > > >
> > > > > > A lovely upgrade likely to take all my time until
> >
> > sometime Tuesday.
> >
> > > > > > But enough about my problems.
> > > > > >
> > > > > > No wait, there's more... :)
> > > > > >
> > > > > > I'm going to upgrade a database from 8.1.6.4 to 8.1.7.4
> > > > > >
> > > > > > This database is currently being backed up via RMAN.
> > > > > >
> > > > > > It occurred to me a few minutes ago that I have no idea how
> > > > > > to make RMAN aware of the new version of database.
> > > > > >
> > > > > > I'm relatively sure it will balk at seeing the
> >
> > database suddenly
> >
> > > > > > upgraded, without having received some sort of
> >
> > notification first.
> >
> > > > > > I've been checking MetaLink, Robert's book, and the docs,
> > > > > > but have not yet determined how to care for this.
> > > > > >
> > > > > > Suggestions, advice and coffee gladly accepted.
> > > > > >
> > > > > > Pertinent platform info:
> > > > > >
> > > > > > Win2k Server SP 2
> > > > > > Oracle 8.1.6.3 EE -> 8.1.7.4 target DB
> > > > > >
> > > > > > RMAN catalog on Win2k Server SP2
> > > > > > Oracle 8.1.7.4
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Jared
> > > > > >
> > > > > >
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > > > --
> > > > > > Author:
> > > > > > INET: Jared.Still_at_radisys.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).
> >
> > > > > __________________________________________________
> > > > > Do you Yahoo!?
> > > > > Yahoo! Shopping - Send Flowers for Valentine's Day
> > > > > http://shopping.yahoo.com
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > > --
> > > > Author: Jared Still
> > > > INET: jkstill_at_cybcon.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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Yount
  INET: ronwy_at_swbell.net

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).