OraFAQ Forum: Backup & Recovery » Recovery Catalog related problem...

Home » RDBMS Server » Backup & Recovery » Recovery Catalog related problem...

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

Recovery Catalog related problem... [message #232536]

Sat, 21 April 2007 00:54

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.

Report message to a moderator

Re: Recovery Catalog related problem... [message #232543 is a reply to message #232536]

Sat, 21 April 2007 01:33

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: Recovery Catalog related problem... [message #232546 is a reply to message #232543]

Sat, 21 April 2007 01:38

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?

Report message to a moderator

Re: Recovery Catalog related problem... [message #232548 is a reply to message #232546]

Sat, 21 April 2007 01:40

Michel Cadot
Messages: 68650
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

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.

Report message to a moderator

Re: Recovery Catalog related problem... [message #232551 is a reply to message #232549]

Sat, 21 April 2007 02:07

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, you can.

Regards
Michel

Report message to a moderator

Re: Recovery Catalog related problem... [message #232554 is a reply to message #232551]

Sat, 21 April 2007 02:41

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.

Report message to a moderator

Re: Recovery Catalog related problem... [message #233026 is a reply to message #232554]

Tue, 24 April 2007 07:17

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

thank you very much sir Laughing

Report message to a moderator

Previous Topic:	HOW TO ALL TABLES IN DATABASE AT ONCE
Next Topic:	media recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 22:16:57 CDT 2024