Re: Coruppted system01.dbf

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 Received on Tue Apr 09 2002 - 08:47:21 CDT