Re: recovering a database

"Ron Croonenberg" <ronc_at_depauw.edu> wrote in message news:cmdfur$fqc$1_at_news.csc.depauw.edu...
> 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:
> '/u01/app/oracle/oradata/helios/redo03.log'
>
>
> any suggestions ?
>
> thanks,
>
> Ron

It seems that u have losts archives needed for recovery !!!! (arch1_2356.dbf)

What is your daily backup routine? Do u have a backup that u can restore from it ? Do u have the archives or they have been lost ? Received on Fri Nov 05 2004 - 02:00:43 CST