Re: Coruppted system01.dbf

see my other reply if you have corrupted the system tablespace (note that dbv is telling you system01.dbf is not in fact corrupt but inconsistent) however I suggest you try

startup mount
recover database;

and see what error message(s) you get if any.

all being well you will see a message Media Recovery complete and you can then type
alter database open;

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote in message
news:a8uree$ljc$1_at_news.tpi.pl...


> i had coruppted file undotbs01.dbf., so  mounted database and drop this

file


> offline.

> now when i start database:

> SQL> startup

> i get:

> Database mounted.

> ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

>

> than i type:

> SQL> alter database open resetlogs;

> alter database open resetlogs

> *

> ERROR at line 1:

> ORA-01194: file 1 needs more recovery to be consistent

> ORA-01110: data file 1:

> '/u01/app/oracle/product/9.0.1/oradata/BANK/system01.dbf'

>

> if I type:

> bash-2.05$ dbv FILE=./system01.dbf BLOCKSIZE=8192

> I get:

> DBVERIFY: Release 9.0.1.0.0 - Production on Tue Apr 9 15:41:17 2002

> (c) Copyright 2001 Oracle Corporation.  All rights reserved.

> DBVERIFY - Verification starting : FILE = ./system01.dbf

> DBVERIFY - Verification complete

> Total Pages Examined         : 41600

> Total Pages Processed (Data) : 29520

> Total Pages Failing   (Data) : 0

> Total Pages Processed (Index): 8660

> Total Pages Failing   (Index): 0

> Total Pages Processed (Other): 1246

> Total Pages Processed (Seg)  : 0

> Total Pages Failing   (Seg)  : 0

> Total Pages Empty            : 2174

> Total Pages Marked Corrupt   : 0

> Total Pages Influx           : 0

>

>

> What to do, to run my database?

>

> SM

>

>

>