kzsk31
asked on
How to recover Oracle database, getting ORA-01122, ORA-01110, ORA-01207
Here is how the problem began, when starting up the database we got the following error message:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u12/oradata/evolmo/syste m01.dbf'
ORA-01207: file is more recent than controlfile - old controlfile
I have re-created the controlfiles, however I cannot recover the database as the archive redo logs are no longer on disk.
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;
ORA-00279: change 88134829 generated at 04/07/2008 09:04:52 needed for thread 1
ORA-00289: suggestion : /u3/arch/evolmo/1_289.dbf
ORA-00280: change 88134829 for thread 1 is in sequence #289
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u12/oradata/evolmo/syste m01.dbf'
At this point I am unable to recover the db.
I do not know how to recover the database as I do not have an export of the SYS schema. I have nightly exports of the application schemas
Can someoine please help, I need to know the steps I would have to take to recover.
The database is in mount mode currently. What do I do now??
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u12/oradata/evolmo/syste
ORA-01207: file is more recent than controlfile - old controlfile
I have re-created the controlfiles, however I cannot recover the database as the archive redo logs are no longer on disk.
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;
ORA-00279: change 88134829 generated at 04/07/2008 09:04:52 needed for thread 1
ORA-00289: suggestion : /u3/arch/evolmo/1_289.dbf
ORA-00280: change 88134829 for thread 1 is in sequence #289
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u12/oradata/evolmo/syste
At this point I am unable to recover the db.
I do not know how to recover the database as I do not have an export of the SYS schema. I have nightly exports of the application schemas
Can someoine please help, I need to know the steps I would have to take to recover.
The database is in mount mode currently. What do I do now??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER