Re: Accidentally created local df in RAC
From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Sat, 10 Mar 2012 00:28:47 +0100
Message-ID: <4F5A922F.6030603_at_gmail.com>
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).
Date: Sat, 10 Mar 2012 00:28:47 +0100
Message-ID: <4F5A922F.6030603_at_gmail.com>
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.
Regards
Dimitre
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 09 2012 - 17:28:47 CST