sbutty
asked on
DBF MORE RECENT THAN CONTROL FILES
I have a serveur Windows 2003 with Oracle 10g. Wich is not in production anymore but that we use sometimes to get old data.
The database was initially installed on 3 physical disks C:\ D:\ E:\. But few months ago, we added a phsycal disk H:\ because there was no more space in the other disks.
As in the diusk, on H:\ I have .dbf files (data and index).
The database is in NOARCHIVELOG.
As backup I make an Acronis image disk of C:\ D:\ E\: but not H:\.
I also make a daily datapump of the full database.
The RAID controller of the server crashed and I must reinstall the server on a new machine. I rent a virtual machine to restore the Acronis backup. Disks C:\ D:\ E\: were correctly restored but H:\ was not included oin the image disk.
The H:\ physical disk was in good shape and I connected to the VM.
Now in the restored server, I have all my disks but I cannot start the database because the dbf files on H:\ on more recent than the control files.
I have error message when I start the db:
ORA-01122
ORA-01110
ORA-01207
Is that possible to resynchronize the control files and dbf ?
The database was initially installed on 3 physical disks C:\ D:\ E:\. But few months ago, we added a phsycal disk H:\ because there was no more space in the other disks.
As in the diusk, on H:\ I have .dbf files (data and index).
The database is in NOARCHIVELOG.
As backup I make an Acronis image disk of C:\ D:\ E\: but not H:\.
I also make a daily datapump of the full database.
The RAID controller of the server crashed and I must reinstall the server on a new machine. I rent a virtual machine to restore the Acronis backup. Disks C:\ D:\ E\: were correctly restored but H:\ was not included oin the image disk.
The H:\ physical disk was in good shape and I connected to the VM.
Now in the restored server, I have all my disks but I cannot start the database because the dbf files on H:\ on more recent than the control files.
I have error message when I start the db:
ORA-01122
ORA-01110
ORA-01207
Is that possible to resynchronize the control files and dbf ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you were in archive log mode and had archives, you should be able to do it. But, without that, you cannot force consistency.
ASKER