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

Report message to a moderator

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: 4581
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.

Report message to a moderator

Previous Topic: Best backup Strategy
Next Topic: DUPLICATE DATABASE WITH RMAN
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 04:25:56 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.