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:[EMAIL PROTECTED]] > > > > 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" <[EMAIL PROTECTED]> > > > > > 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? > > > > > > > > > > > > > > --- [EMAIL PROTECTED] 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: [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). > > > > > > > > > > > __________________________________________________ > > > > > > > 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: [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: Jared Still > > > > 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: Jared Still 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).
