RE: RMAN: Unregister from one Catalog and register in a new one

From: Vishal Gupta <vishal_at_vishalgupta.com>
Date: Sat, 27 Sep 2008 17:48:37 +0100
Message-ID: <787DD2F284E39D4FA3C2ABD2DAF1AB2D014E51@MAIL.vishalgupta.co.uk>

Ricardo,  

You don't need to register and unregister the databases. If unregister then you will lose all the backup information.  

Upgrade option:

1. Upgrade the oracle software for RMAN database.
2. Upgrade RMAN database.
3. Connect to RMAN catalog owner via rman executable and issue "upgrade catalog" command.

New Install Option:

1. Install 10.2.0.4 oracle software
2. Create a new database.
3. Export rman catalog owner schema from old 10.1.0.5 database.
4. Import in 10.2.0.4 database.
5. Connect to RMAN catalog owner via 10.2.0.4 rman executable and issue "upgrade catalog" command.

Regards,

Vishal Gupta

http://www.vishalgupta.com/blog <http://www.vishalgupta.com/blog>  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ricardo Santos Sent: 10 July 2008 18:59
To: ORACLE-L
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 all

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

Best Regards,

Ricardo.  

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Sep 27 2008 - 11:48:37 CDT