Re: How to recover SYSTEM tablespace

Matthias Schrader (M_Schrader_at_t-online.de) wrote:
:
: 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). [..]
: Is there any hope to recover the database or any way to get the data
: from the usertablespaces?

Disaster indeed. The answer, in a nutshell, is no. You are out of luck. There is no way to do it.

In order to extract data from the data files you would have to reverse-engineer the Oracle data file format. This is a very complicated proposition.

You cannot start up a database without, at a minimum, the system tablespace, the online redo log file, and probably the rollback tablespace(s).

Go back to an earlier backup if you have one; otherwise it is time to cry.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"