Re: Accidentally created local df in RAC

  • From: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • 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.


Other related posts: