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

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.. Received on Wed Oct 05 2005 - 05:52:08 CDT