Re: Upgrading Target Database in RMAN

On Sunday 16 February 2003 08:23, Ron Yount wrote:
> 1) The catalog must be as new as, if not new than, the target db before a
> new rman backup will work.

Already done.

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

Thank you, this is the part I was looking for. I suspected this to be the case, but could find nothing to verify this. Still can't. Do you know where to find this in the fine docs?

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

Nah, just restore the database and upgrade it. Just went from 8.1.6.3 -> 8.1.7.4.

Thanks again,

Jared

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