Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to recover SYSTEM tablespace

How to recover SYSTEM tablespace

From: Matthias Schrader <M_Schrader_at_t-online.de>
Date: 1997/12/06
Message-ID: <66cjqo$tg3$1@news00.btx.dtag.de>#1/1

--------------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>&nbsp;
<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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US