Re: ORA-1194, any idea?

Seems like Oracle can't find the archived log file arch0000001737.log. Perhaps it is moved on the tape. You must restore your archived redo logs before recovery. I noticed that you are using backup controlfile, this is not good idea, better use the most recent version of controlfile.

Juhan

lkj741_at_my-deja.com wrote:
>
> 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
Received on Thu Mar 16 2000 - 11:42:08 CST