Home » RDBMS Server » Backup & Recovery » DB name is changed in Catalog DB (Oracle,10.2.0.4,windows)
DB name is changed in Catalog DB [message #390758] Mon, 09 March 2009 11:20 Go to next message
dass8484
Messages: 18
Registered: February 2009
Location: India
Junior Member
Pro and probe db's are registered with rmandb catalog database...Actually we have refreshed probe db with pro db using User managed hot backup....

After changing the DBID of probe, we have the registered the DB again in catalog database..... But suddenly,pro db name
was changed to probe...


Probe should be pro....

Is there any option to change the DB name in catalog and use the backups
Re: DB name is changed in Catalog DB [message #390761 is a reply to message #390758] Mon, 09 March 2009 11:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
By "probe db" is suppose you are meaning test/dev db.
By "pro db" is suppose you are meaning a production db.

Quote:
But suddenly,pro db name
was changed to probe...
Probe should be pro....

Have no idea what you are talking about.
Rephrase the question.

After refreshing, I would change dbname and everything related by using nid utility. Register the database back.
Though it is perfectly okay to use same catalog for multiple databases,
I just do not prefer it for the said issues.
Use separate catalog for each database (inside the same RMAN catalog database).
And,
Unless you are backing up the "probe db" again, there is no need for that
to be registered in database.
Re: DB name is changed in Catalog DB [message #390927 is a reply to message #390758] Tue, 10 March 2009 06:17 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
hi,

If you don't care about the old backups, that doesn't exist in control file, unregister both db from the catalog, then register them again.
Regards,
Alex
Previous Topic: Moving database with RMAN requires archive logs?
Next Topic: Incomplete and Complete backup recovery
Goto Forum:
  


Current Time: Mon Dec 05 19:21:24 CST 2016

Total time taken to generate the page: 0.06545 seconds