Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to recover SYSTEM tablespace
--------------BA81BE88227FB89D1C27BB14 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Can anyone help me out of the following disaster:
An Oracle Server 7.2 (HP-UX) instance was completely lost after HD crash. The available backup contains all needed files but not the SYSTEM tablespace (1 datafile). This one is truncated to zero bytes. The instance was never in archivelog mode. There is also no export available.
Is there any hope to recover the database or any way to get the data from the usertablespaces?
Many thanks in advance
Matthias
--------------BA81BE88227FB89D1C27BB14 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<HTML>
<P>Can anyone help me out of the following disaster:
<P>An Oracle Server 7.2 (HP-UX) instance was completely lost after HD crash.
The available backup contains all needed files but not the SYSTEM tablespace
(1 datafile). This one is truncated to zero bytes.
<BR>The instance was never in archivelog mode. There is also no export
available.
<BR>
<BR>Is there any hope to recover the database or any way to get the data
from the usertablespaces?
<P>Many thanks in advance
<P>Matthias</HTML>
--------------BA81BE88227FB89D1C27BB14-- Received on Sat Dec 06 1997 - 00:00:00 CST