OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » RMAN restoration (11.2.0.2.0 )

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

RMAN restoration [message #571724]

Thu, 29 November 2012 11:03

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

We need to test mean time to restore from rman backup. So can we restore the data file to new location on the same server without effecting the Database.?

Please let me know if query is not clear.

Thanks

Report message to a moderator

Re: RMAN restoration [message #571725 is a reply to message #571724]

Thu, 29 November 2012 11:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

> So can we restore the data file to new location on the same server without effecting the Database.?
I give up.
Can you?
If you mess up, you could destroy existing DB.

Report message to a moderator

Re: RMAN restoration [message #571727 is a reply to message #571724]

Thu, 29 November 2012 11:25

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

Senior Member
Account Moderator

Yes, you can, just read the documentation.

Regards
Michel

Report message to a moderator

Re: RMAN restoration [message #571780 is a reply to message #571727]

Fri, 30 November 2012 05:26

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks Michel,

It is done.

RUN {
SET NEWNAME FOR DATAFILE 1 TO 'NEW_LOCATION';
RESTORE DATAFILE 1;
}

Only thing I find to be very sure not to execute 'switch datafile 1' command as this will update the controlfile with new location.

Thanks.

Report message to a moderator

Re: RMAN restoration [message #571781 is a reply to message #571780]

Fri, 30 November 2012 05:28

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

Senior Member
Account Moderator

Thanks for the feedback and hint.

Regards
Michel

Report message to a moderator

Previous Topic:	Query on Incremenatl Cumulative RMAN Backup
Next Topic:	Datafile deleted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 19:32:40 CDT 2023