Home » RDBMS Server » Backup & Recovery » catalog upgrade (Oracle 10g, Rel2 , Linux AS4)
catalog upgrade [message #361219] Tue, 25 November 2008 07:09 Go to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

We are having RMAN catalog database 10.2.0.3 . And we want to upgrade that to 10.2.0.5 . But before doing that we would like to know any precautions we need to take in doing that . And also how lomg does it take for that to complete .

And the steps what I've decided to do are as below

% rman CATALOG rcat/rcat@recdb

Recovery Manager: Release 10.1.0.5.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to recovery catalog database

RMAN> UPGRADE CATALOG

recovery catalog owner is rcat
enter UPGRADE CATALOG command again to confirm catalog upgrade

RMAN> UPGRADE CATALOG


Is that all to upgrade a catalog database.

Kindly help me out .

Regards,
Raj

[Updated on: Tue, 25 November 2008 07:30]

Report message to a moderator

Re: catalog upgrade [message #361224 is a reply to message #361219] Tue, 25 November 2008 07:37 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Wait a minute, don't do that! You just need to apply the relevant patch-set to upgrade from 10.2.0.3 to 10.2.0.5.

More info: The UPGRADE CATALOG part is actually listed in the patch-set's readme file. So, your instructions are correct.
Re: catalog upgrade [message #361227 is a reply to message #361224] Tue, 25 November 2008 07:45 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Yes Frank, we are in the process of doing that . And also my questions were that what should be the precautions we need to take in doing that . And also how lomg does it take for that to complete .
Re: catalog upgrade [message #361228 is a reply to message #361227] Tue, 25 November 2008 07:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Just curious...what is the patch number for 10.2.0.5 ? I didn't realize 10.2.0.5 was out.
Re: catalog upgrade [message #361238 is a reply to message #361228] Tue, 25 November 2008 08:22 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
sorry its, 10.2.0.4 .

Re: catalog upgrade [message #361364 is a reply to message #361224] Wed, 26 November 2008 01:29 Go to previous messageGo to next message
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Can you please let me know the precautions we need to take while upgrading the rman catalog , apart from the patch set .
And can we do online without shutting down the database.
kindly help me out.

Regards,
Raj
Re: catalog upgrade [message #361385 is a reply to message #361364] Wed, 26 November 2008 03:11 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
The normal precausions should apply:

1. Test the procedure on a development system
2. Backup the database before you start (maybe an export, please don't use RMAN!)

The RMAN catalog upgrade should abviously be done when the DB is online. However, don't try to do it while you have backups running.

Best of luck!

Frank

Previous Topic: Data Files Recovery
Next Topic: Can Oracle use recent build backup?
Goto Forum:
  


Current Time: Sun Dec 04 12:51:34 CST 2016

Total time taken to generate the page: 0.14507 seconds