-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|