ORA-1194, any idea?

From: <lkj741_at_my-deja.com>
Date: Wed, 15 Mar 2000 21:57:43 GMT
Message-ID: <8ap10l$avk$1@nnrp1.deja.com>

i'm tring to recover the database.
This is all the error I'm getting. Any idea how to solve them.

SVRMGR> startup mount
ORACLE instance started.

Total System Global Area                          8744464 bytes
Fixed Size                                          48656 bytes
Variable Size                                     7487488 bytes
Database Buffers                                  1126400 bytes
Redo Buffers                                        81920 bytes

Database mounted.
SVRMGR> recover database until time '2000-03-13:17:00:10' using backup controlfile;
ORA-00279: change 579476 generated at 03/13/00 17:36:46 needed for thread 1

ORA-00289: suggestion : /db0/u05/oradata/db01/archive/arch0000001737.log
ORA-00280: change 579476 for thread 1 is in sequence #1737
ORA-00308: cannot open archived

log '/db0/u05/oradata/db01/archive/arch0000001737.log' 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: '/db0/u01/oradata/db01/system01.dbf'

I also couldn't locate the arch#37. I have #36 and #37.

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 15:57:43 CST