OraFAQ Forum: Backup & Recovery » refresg using rman

Home » RDBMS Server » Backup & Recovery » refresg using rman

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

refresg using rman [message #277910]

Thu, 01 November 2007 03:16

lm_suresh
Messages: 24
Registered: September 2007
Location: Chennai,India

Junior Member

Hi

I have 3 instances A, B and C. "C" is cloned from "A". All the instances are running in no archive mode. I have taken the full database back up of "A" with control file using rman after normal shutdown.

I just need to refresh the data of my instance "c" using the rman backup of "A". I am using RMAN with recovery catalog.
could someone please guide me or provide some source to read the procedure to do the refresh.

Thanks
Suresh

Report message to a moderator

Re: refresg using rman [message #277921 is a reply to message #277910]

Thu, 01 November 2007 04:02

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

Senior Member
Account Moderator

No refresh possible, you have to recreate the database each time as you did it the first time.

By the way, what is the purpose of B? you don't talk about it.

Regards
Michel

Report message to a moderator

Re: refresg using rman [message #277926 is a reply to message #277910]

Thu, 01 November 2007 04:27

lm_suresh
Messages: 24
Registered: September 2007
Location: Chennai,India

Junior Member

Thank you Michel. Please ignore B.

First time I did the cloning using "backup control file to trace".
I have not used RMAN to create the instance "C" from "A".
I need to refresh the instance "C" very frequently from A.
As of now i am recreating the control file using trace file and copying the all the datafiles from "A" for refresh.

Is there any other better way of doing refresh other than i am doing now. i am trying to implement RMAN. Is the anyother process in RMAN which i can implement.

Report message to a moderator

Re: refresg using rman [message #277931 is a reply to message #277926]

Thu, 01 November 2007 04:40

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

Senior Member
Account Moderator

You can use RMAN duplicate command.

Regards
Michel

Report message to a moderator

Re: refresg using rman [message #278016 is a reply to message #277931]

Thu, 01 November 2007 08:02

kudur_kv
Messages: 75
Registered: February 2005

Member

Michel,

Should not the target database at least be in archive log mode for using the Duplicate command?.

The answer is most probably no.

Just wanted to confirm though.

Thank you.

[Updated on: Thu, 01 November 2007 08:06]

Report message to a moderator

Re: refresg using rman [message #278028 is a reply to message #278016]

Thu, 01 November 2007 09:35

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

Senior Member
Account Moderator

You can do it with a target in mount and not open mode.
But I could be wrong, just try it.

Regards
Michel

Report message to a moderator

Re: refresg using rman [message #278040 is a reply to message #278016]

Thu, 01 November 2007 10:58

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Actually the target database should be OPEN or at least mounted. There are several ways to perform the duplicate database, however if you intend on doing it with the database OPEN, then you will need to be in archivelog mode.

Report message to a moderator

Previous Topic:	No errors displayed in Alert log
Next Topic:	how to force the old backup for recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 07:56:52 CDT 2024