Re: system file recovery

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 19 Sep 2002 18:49:41 +0200
Message-ID: <2uvjous0fg18oh5naptgsro0e4voign7p6@4ax.com>

On 19 Sep 2002 09:12:18 -0700, nygini_at_yahoo.com (Gin) wrote:

>While installing webdb, we crashed Oracle 8i. Unfortunately the backup
>was uncomplete. Ws are trying to recover the data base. After strating
>up, we get a message saying : Oracle instance started, ..., database
>mounted but then:
>
>ORA-01113: file 1 needs media recovery
>ORA-01110: data file 1: "/oracle/oradata/coastal/system01.dbf
>
>we do have a system01.dbf, it might be corrupted; its size is ~260 M
>(what it should be I guess).
>Any suggestions?

Just issue the
recover database
command
which will ask you to apply your redologs. If you are not running in archivelog mode and you need offline redologs you are evidently toast, and you will loose anything beyond the last complete backup.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 19 2002 - 11:49:41 CDT