RE: Upgrading Target Database in RMAN

Yep, new dbid will confuse rman every time.

-----Original Message-----
Sent: Sunday, February 16, 2003 9:54 PM
To: Multiple recipients of list ORACLE-L

Turned out to be as simple as 'register database'...

... because I had to recreate it to use the UTF8 charset, and it was then a 'new' DB, with a new DBID.

jared

On Sunday 16 February 2003 17:13, Jared Still wrote:
> 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).

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