because you said until cancel
--
Dave A
<susana73_at_hotmail.com> wrote in message news:8t2in1$tnm$1_at_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 - 21:31:36 CDT
