SEO

Hello,

I am by no means a dba, I just inherited a Linux box that is running it.
The machine crashed a bit ago and the database doesn't want to start.

The error msg I get is a "ORA-01033 ORA-01033: ORACLE initialization or
shutdown in progress in"

The machine it was running on had a disk go offline (it's a raid) The
disk has been rebuild and everything seems to be working, except the
oracle database doesn't seem to start.

Is there a document that can guide you through the process of bringing
the database up again ? (as I said I don't even want to pretend I am a dba)

I tried some things, but what I get stuck with is :

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:
'/u01/app/oracle/oradata/helios/redo03.log'

any suggestions ?

thanks,

Ron




any suggestions are welcome,

thanks,
Ron