Re: how to recover/restore a database using archive logs & control files 8i

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 04 Oct 2005 22:41:13 +0200
Message-ID: <a2q5k1ti97m45fkj0ef2sdontc3vqjcn8k@4ax.com>

On 4 Oct 2005 09:54:39 -0700, "etravels" <emerryan_at_yahoo.co.uk> wrote:

>AUTO
>ORA-00308: cannot open archived log
>'D:\DATABASE\ARCHIVE\IOT001S82635.ARC'
>ORA-27041: unable to open file
>OSD-04002: unable to open file
>O/S-Error: (OS 2) The system cannot find the file specified.

You said you had archives, didn't you?
The message tells you the archive doesn't exist at the specified location.
You need to make sure it is at location pointed to by the log_archive_dest parameter, or don't type AUTO, but specify the full file_name instead.
If you don't have the archive, complete recovery is no longer possible,and you will need
recover ..... using backup controlfile until cancel /
and
alter database open *resetlogs*

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Oct 04 2005 - 15:41:13 CDT