Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: recovery
Theo
Without the SYSTEM tablespace, you're gone. All the data dictionary information showing what tables are where in the rest of the database and all that sort of thing is gone. Your only option is to restore the SYSTEM tablespace from backup then roll forward to a point in time prior to the crash, if you're running in ARCHIVELOG mode. If you're in NOARCHIVELOG mode, restore everything from the last backup.
Pete
HPT wrote:
> Hello,
>
> I'v had a system crash and lost the system tablespace . Is there any way to
> recover other tablespaces (I'v heard about utility that could read database
> files without oracle database engine)
>
> I'm running 7.3.4 database on WinNT.
>
> Thanks,
> Theo
Received on Wed Oct 20 1999 - 13:51:16 CDT