RE: RMAN: Unregister from one Catalog and register in a new one
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 27 Sep 2008 17:48:37 +0100
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
