RE: RMAN: Unregister from one Catalog and register in a new one
Date: Sat, 27 Sep 2008 17:48:37 +0100
You don't need to register and unregister the databases. If unregister then you will lose all the backup information.
- Upgrade the oracle software for RMAN database.
- Upgrade RMAN database.
- Connect to RMAN catalog owner via rman executable and issue "upgrade catalog" command.
New Install Option:
- Install 10.2.0.4 oracle software
- Create a new database.
- Export rman catalog owner schema from old 10.1.0.5 database.
- Import in 10.2.0.4 database.
- Connect to RMAN catalog owner via 10.2.0.4 rman executable and issue "upgrade catalog" command.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ricardo Santos Sent: 10 July 2008 18:59
Subject: RMAN: Unregister from one Catalog and register in a new one
Hello to you all,
Due to infrastructure changes I want and have to start using another RMAN catalog for the backups of two Target Databases. But I don't want to loose the backup information I have, ie I still want to be able to access the oldest backups if I need them for some reason, for example for responding to a clone database request due to some law requirements.
Here we use RMAN with media manager IBM Data Protection for Oracle version 5.2 and the databases involved in this question are:
Target Database: 10.1.0.5
Old Catalog Database: 10.1.0.4
Old Catalog Schema: 10.1.0.4, created with RMAN executable 10.1.0.4 RMAN executable: 10.2.0.4
New Catalog Database: 10.2.0.4
New Catalog Schema: 10.2.0.4, created with RMAN executable 10.2.0.4 RMAN executable: 10.2.0.4
I'm planning the following procedure, during the night time:
1- Connect to the TARGET Database and OLD CATALOG Database 2- Take the configuration commands 3- Unregister Target Database with unregister command 4- Exit RMAN 5- Connect to the TARGET Database and NEW CATALOG Database 6- Register Target Database 7- Configure RMAN with the previosly taken RMAN commands 8- Perform a full database backup 9- Perform a crosscheck backup and a crosscheck archivelog allI would like to know if this procedure is safe and is enough for:
- Still be able to acess the oldest backups on the Media Manager, I may
still need them for syncronize a test database
- Don't loose any configuration
- Remove all the information from the old CATALOG Or if I need to take something more in consideration.
Thanks in advance for the help.
Ricardo.Received on Sat Sep 27 2008 - 11:48:37 CDT