Re: Accidentally created local df in RAC
Date: Sat, 10 Mar 2012 00:28:47 +0100
On 10/03/2012 00:18, Radoulov, Dimitre wrote:
> Some time ago we lost some data files from a big critical production
> database because of media failure.
> We lost the filesystem with the latest archivelogs too. In that case
> we left the data files offline,
> we identified the objects that had extents in those data files and we
> imported them from an export
> (we lost some data of course).
Just to add (not so obvious detail): we had a backup, but given the size
of the entire database,
and the loss of the latest archive logs (the time between backup schedules) we choose the lesser
of two evils: faster recovery and lesser data loss.