| recovery [message #58801] |
Wed, 01 October 2003 06:05  |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
my database is corrupt .nothing left.since database is running on archive mode so that i can preserve archive log file,control file and redolog file.
to recover my database i create a new database taking all the system datafile from my corrupt database.now using above log file and control file i tried to recover database.i can mount the database.i make all the datafile as it was but while trying to put this command 'recover database' i see this type of error message...
ORA-00283:recovery session cancelled due to errors
ORA-0112:database file1 fail verification check
ORA-01110 :datafile1 '/oracle/oracle/oradata/omni/system01.dbf'
ORA-01207: file is more recent than controlfile - oldcontrolfile
please help
|
|
|
|
| Re: recovery [message #58803 is a reply to message #58801] |
Wed, 01 October 2003 08:30  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Are you sure you are using the restored system file and the backup controlfile ?
did you try 'recover database until cancel using backup controlfile; ' ?
How are you saying that your database is corrupt ? Is this a test recovery you are trying out , by not restoring your datafile backup ?
-Thiru
|
|
|
|
| Re: recovery [message #58816 is a reply to message #58803] |
Thu, 02 October 2003 04:54 |
M. Khaled
Messages: 67
Registered: April 2002
|
Member |
|
|
|
yes this is test recovery.control file and redolog was multiplexed.i took online system datafile.other datafile was created after mounting the database.finally 'recover database' used......
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
