Re: Accidentally created local df in RAC

From: Radoulov, Dimitre <>
Date: Sat, 10 Mar 2012 00:20:16 +0100
Message-ID: <>

[re-post because of over-quoting]

Hi Dave,
you mentioned this is a 20+ TB database, but if the objects in the tablespace that contains the local data file are not too big, you may try to move them to a new tablespace (online, if EE) and drop the entire tablespace
after that.

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). Those data files remained in this state until until we upgraded it
with export/import. We had to add "skip inaccessible" in the rman scripts ...

Best regards

Received on Fri Mar 09 2012 - 17:20:16 CST

Original text of this message