| catalog upgrade [message #361219] |
Tue, 25 November 2008 07:09  |
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  |
Frank Naude
Messages: 4579
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 |
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 #361364 is a reply to message #361224] |
Wed, 26 November 2008 01:29 |
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 |
Frank Naude
Messages: 4579
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
