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

etravels wrote:
> Hi all ,
>
> I have being reading lots of books/google it etc, but here is what i
> have done:
> ALTER DATABASE CREATE DATAFILE
> 'D:\database\data\_tsx1.dbf' AS 'c:\data\tsx1.db';
>
> I did this for all datafiles that the system thinks it can see? if you
> do a select * from v$datafiles, you can see these existing in the
> orignal folder, they take up the orignal size so that they effectively
> exis
>
> now I go to recover datafile c:\data\ts1.dbf
> get the following error:
>
> SQL> RECOVER DATAFILE 'C:\DATA\_ts1.dbf';
> ORA-00279: change 175222664 generated at 09/30/2005 15:13:07 needed for
> thr
> ORA-00289: suggestion : D:\DATABASE\ARCHIVE\IOT001S82635.ARC
> ORA-00280: change 175222664 for thread 1 is in sequence #82635
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>
> 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.
>
> if i got to the backups I can see the above ARC file, why won't this
> work and why the errors????
>
> Thanks again..
>

4 or 5 posts ago, you wrote:
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.

2 posts ago, this:
the archive folder is d:\database\data\archive\IOT001S82635.ARC' all the list of arc files, is this what you mean?

Now, clearly you put your archived redo logs somewhere else than the database believes they are...
Oracle thinks they are in D:\DATABASE\ARCHIVE, whereas the files actually reside in d:\database\data\archive.

If this is correct, you cannot (NOT!) auto recover; instead fill in the fully qualified path and filename when oracle suggests a file.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...