Hi All

I am playing wiht Oracle 9i DB wir RH 7.2 and while testing recovery procedure I have taken an online backup (using trace file) and data file backup. I was aborting and starting the db again to check the point in time recovery. However I got the following error and I could not open the daabase at all.

ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/opt/oracle/product/9.0.1/oradata/kendb/system01.dbf'

I searched the help and founfd that the datafile has to be restored from recent backups. I did that as I had already taken online backup (I dont have any old backup). I copied the system01.dbf to the original database and then and again started the database and got the same error again.

I did try the incomplete recovery but it is not working as database cannot be opened at all. What are various ways to recover it?

If I need to recreate the entire database again then how to do it?

Amol