Home » RDBMS Server » Backup & Recovery » Recovery Catalog related problem...
Recovery Catalog related problem... [message #232536] Sat, 21 April 2007 00:54 Go to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

i have to register 2 databases with Recovery catalog. databases name is same.

How to register them with recovery catalog.

its a IBM interview question.
Re: Recovery Catalog related problem... [message #232543 is a reply to message #232536] Sat, 21 April 2007 01:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
connect to rman and use "register database".
Database name must not be unique; DB ID must.

Regards
Michel
Re: Recovery Catalog related problem... [message #232546 is a reply to message #232543] Sat, 21 April 2007 01:38 Go to previous messageGo to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

i know the database name must not be same......that is the problem. that how i'll register both to catalog?
Re: Recovery Catalog related problem... [message #232548 is a reply to message #232546] Sat, 21 April 2007 01:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
My sentence should be read as database name have not to be different, so you can have 2 databases with the same name.

Regards
Michel

[Updated on: Sat, 21 April 2007 01:41]

Report message to a moderator

Re: Recovery Catalog related problem... [message #232549 is a reply to message #232548] Sat, 21 April 2007 01:44 Go to previous messageGo to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

sorry sir actully i want to say that can we register database whose db_name is same with catalog? i think we can't.
Re: Recovery Catalog related problem... [message #232551 is a reply to message #232549] Sat, 21 April 2007 02:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can.

Regards
Michel
Re: Recovery Catalog related problem... [message #232554 is a reply to message #232551] Sat, 21 April 2007 02:41 Go to previous messageGo to next message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Gentleman,
For Recovery catalog db_name has no meaning. It identifies the databases using DB ID only.
For eg.
Say we have 2 databases in the same name as "test", when we register the databases, recovery catalog goes by DB ID.

DB_NAME1 = test DB ID = 2000
DB_NAME2 = test DB ID = 2001

In this case recovery catalog see 2 databases, one as 2000 and another as 2001.

THis is what Michel is repeatedly telling u.
Re: Recovery Catalog related problem... [message #233026 is a reply to message #232554] Tue, 24 April 2007 07:17 Go to previous message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

thank you very much sir Laughing
Previous Topic: HOW TO ALL TABLES IN DATABASE AT ONCE
Next Topic: media recovery
Goto Forum:
  


Current Time: Sun Dec 04 06:47:28 CST 2016

Total time taken to generate the page: 0.08170 seconds