Home » RDBMS Server » Backup & Recovery » RMAN Catalog Merge (10.2.0.4)
RMAN Catalog Merge [message #463068] Tue, 29 June 2010 10:22 Go to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
DB : 10.2.0.4
OS : Sun Solaris 5.8

Hello Folks,

In our environment, we have one rman catalog database and under that we few catalog schemas. I am planning to merge all those schema into one existing schema.

For eg. Diff RMAN Schema RMAN, RMAN1, RMAN2, RMAN3
Merge it from RMAN1, RMAN2, RMAN3 to RMAN.

My Action plan for this situation is
1> Take Export of all schemas
2> Re-Register respected databases (from RMAN1, RMAN2, RMAN3) to RMAN.
3> Modify backup scripts points to correct schema (i.e. RMAN).

Question for my clarification
1> Do I needs to de-register from previous catalog schemas ?
2> If I need to restore my db's after this process, from where RMAN get that information as I have new catalog and this catalog does not contain any previous backup information ??

Unfortunately we are not on 11g yet, In case of 11g we have command for IMPORT CATALOG.

What's a best options for this scenario ? Thanks for your time.


Re: RMAN Catalog Merge [message #463135 is a reply to message #463068] Tue, 29 June 2010 15:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I am planning to merge all those schema into one existing schema.
May I ask why? What are you trying to accomplish with this?
There are specific reasons for keeping information in separate catalogs.
Re: RMAN Catalog Merge [message #463264 is a reply to message #463135] Wed, 30 June 2010 07:55 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Reason for merge is to migrate catalog from one database to another database. We are planning to combine OEM and RMAN repository, before doing that we want to merge RMAN catalog so by that way we can easily pull RMAN report from one schema instead of getting it from 15 different schemas.

What implication you see by merging it to one?
Re: RMAN Catalog Merge [message #463274 is a reply to message #463264] Wed, 30 June 2010 08:44 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>What implication you see by merging it to one?
As said, there are specific reasons, depending on your business/shop.
Nothing generic.
It my case, I backup many database and duplicate/restore them much more times and use separate catalog for backup/restore/duplication.
One advantage is can just upgrade the specific catalog, instead of all.
Since no native methods are available to merge in 10g, I would not try it in a production environment.
The only other option is to unregister and register back. I would also leave the other catalog just intact for a while.
Previous Topic: RMAN throws RMAN-01009: syntax error: found "double-quoted-string": expecting one of: &
Next Topic: RMAN duplicate
Goto Forum:
  


Current Time: Thu Mar 28 06:48:54 CDT 2024