OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Recovery on DR (10g r2)

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

Recovery on DR [message #574565]

Sun, 13 January 2013 00:24

abbasgol
Messages: 3
Registered: January 2013

Junior Member

Hello World , i will till you what i have and i need help for my question because i already did alot of serach but no one mention my wondering and answer for it .

On production server i have the production database and i have another instance for recovery catalog database.and on DR server i have only one instance for production database .

In the scenario of recovery,
- i did export for recovery catalog user
- i have latest rman backup for production database

On the DR server as i mention up , i have only on instance , my question is , i need to create another instance for recovery catalog user to import it ? or on the same target database on DR i can import the recovery catalog ?

thank you

Report message to a moderator

Re: Recovery on DR [message #574568 is a reply to message #574565]

Sun, 13 January 2013 01:26

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You don't need the recovery catalog schema to be able to restore and recover the database.
All information about your backups are in the control files.
So on your DR site, forget it, it will simplify your DR management.

Note that to be useful, RMAN catalog schema MUST be in another database than those that is backed up with using this catalog.
Otherwise, it is (almost) useless.

Regards
Michel

Report message to a moderator

Re: Recovery on DR [message #574570 is a reply to message #574568]

Sun, 13 January 2013 01:33

abbasgol
Messages: 3
Registered: January 2013

Junior Member

thank you Michel , but let us say i want to use recovery catalog to restore the production database into DR server , may i know the scenario ?

Report message to a moderator

Re: Recovery on DR [message #574571 is a reply to message #574570]

Sun, 13 January 2013 01:36

Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is a section or chapter on the documentation named "restore a database on another server" (or the like), just read it.
With or without a recovery catalog, it does not change anything (but the connection to the catalog).

Regards
Michel

Report message to a moderator

Previous Topic:	how to change archivelog destination in oracle 10g
Next Topic:	How to find table is got restored on not

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 09:25:55 CDT 2025