recovering a database

Hello,

We had a Linux server running oracle 8.1.7 crash because of a diskarray failing.

The disks are rebuilt, but the oracle server doesn't seem to start correctly. (after the machine crashed I saw a bunch of read/write errors appear)

Anyway, when ever I try to connect to the database I get :

ORA-01033: ORACLE initialization or shutdown in progress in ....

I tried recovering "stuff"

but I get stuck at :

SVRMGR> RECOVER DATABASE UNTIL CANCEL;
ORA-00279: change 2597620 generated at 10/11/2004 10:26:36 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/product/8.1.7/dbs/arch1_2356.dbf ORA-00280: change 2597620 for thread 1 is in sequence #2356 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/u01/app/oracle/product/8.1.7/dbs/arch1_2356.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: '/u01/app/oracle/oradata/helios/system01.dbf'

SVRMGR> recover datafile '/u01/app/oracle/oradata/helios/system01.dbf';

ORA-00283: recovery session canceled due to errors
ORA-00314: log 1 of thread 1, expected sequence# 2356 doesn't match 2353
ORA-00312: online log 1 thread 1: 

any suggestions ?

thanks,

Ron Received on Thu Nov 04 2004 - 08:52:48 CST