OraFAQ Forum: Backup & Recovery » DB name is changed in Catalog DB

Home » RDBMS Server » Backup & Recovery » DB name is changed in Catalog DB (Oracle,10.2.0.4,windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB name is changed in Catalog DB [message #390758]

Mon, 09 March 2009 11:20

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

Report message to a moderator

Re: DB name is changed in Catalog DB [message #390761 is a reply to message #390758]

Mon, 09 March 2009 11:31

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: DB name is changed in Catalog DB [message #390927 is a reply to message #390758]

Tue, 10 March 2009 06:17

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

Report message to a moderator

Previous Topic:	Moving database with RMAN requires archive logs?
Next Topic:	Incomplete and Complete backup recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:34:51 CST 2024