recovery question: ORA-00308

From: <susana73_at_hotmail.com>
Date: Mon, 23 Oct 2000 23:47:47 GMT
Message-ID: <8t2in1$tnm$1@nnrp1.deja.com>

Hi,

My Sun server crashed suddenly. When I tried to restart database, it gave me "need media recovery" message. Since I have a week of archives kept in the file system, I tried to do a "recover database until cancel" directly from server manager without restoring any datafiles. I applied most of the archives until it returned "T0001S0000002896.ARC not found". I looked into the filesystem and the most recent archive was 2895. I am wondering why it ask me for 2896?

Anyway, after I applied all archives(except 2896), I was able to open the database by "alter database open resetlogs". But I am just curious why it couldn't find the archive file and it didn't even exist?

I am on 8.1.6 on Solaris 7. I am doing cold backup in archive modes.

Thanks,

Susan

Specify log: {<RET>=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log
'/oradb/ora1/archive/T0001S0000002896.ARC' ORA-27037: unable to obtain file status
SVR4 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: '/oradb/ora1/data1/system/system01.dbf'

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 23 2000 - 18:47:47 CDT