Home » RDBMS Server » Backup & Recovery » RMAN restoration (11.2.0.2.0 )
RMAN restoration [message #571724] Thu, 29 November 2012 11:03 Go to next message
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
Re: RMAN restoration [message #571725 is a reply to message #571724] Thu, 29 November 2012 11:08 Go to previous messageGo to next message
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.

Re: RMAN restoration [message #571727 is a reply to message #571724] Thu, 29 November 2012 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can, just read the documentation.

Regards
Michel
Re: RMAN restoration [message #571780 is a reply to message #571727] Fri, 30 November 2012 05:26 Go to previous messageGo to next message
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.
Re: RMAN restoration [message #571781 is a reply to message #571780] Fri, 30 November 2012 05:28 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback and hint.

Regards
Michel
Previous Topic: Query on Incremenatl Cumulative RMAN Backup
Next Topic: Datafile deleted
Goto Forum:
  


Current Time: Thu Mar 28 16:40:32 CDT 2024