Home » RDBMS Server » Backup & Recovery » Incomplete restore of datafile to external location
Incomplete restore of datafile to external location [message #181651] Tue, 11 July 2006 00:51 Go to next message
SweD
Messages: 3
Registered: April 2006
Junior Member
Hello,
I want to extract/restore a single datafile to an external location. The datafile, present in the RMAN backupset, should be extracted using set until and set newname, I suppose, to reflect the point in time to which the file should be relevant.

Is it possible to do this, to extract the file to /tmp, without touching the live and active file in the database?
I can live with setting the active and current file offline for whatever time is needed, should it come to that.

Regards,
/Dennis
Re: Incomplete restore of datafile to external location [message #185883 is a reply to message #181651] Fri, 04 August 2006 00:56 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Oh yes, it is possible.

However, for safety reasons, it would be better to do it on a different (non-prod) system.
Previous Topic: Best backup Strategy
Next Topic: DUPLICATE DATABASE WITH RMAN
Goto Forum:
  


Current Time: Sat Dec 03 10:12:26 CST 2016

Total time taken to generate the page: 0.21180 seconds