ORA-1122, ORA-1110, ORA-1207whileopenthedatabaseafterc

ORA-1122, ORA-1110, ORA-1207whileopenthedatabaseaftercrash

ORA-1122, ORA-1110, ORA-1207 while open the database after crash

ORA-1122, ORA-1110, ORA-1207 while open the database after crash

[Date:] Source: Linux community Author: carefree [Font:]

Symptoms:
ORA-1122: database file % s failed verification check
A ORA-1110: datafile:
ORA-1207: ORA 1207 file is more recent than control file

Cause:
The information in this file is inconsistent with information from the control file.
The datafile header CHECKPOINT count is beyond the controlfile CHECKPOINT count.

Solution:
1. Mount the database
SQL> Startup mount
2. Save the information from the control file:
SQL> Alter database backup controlfile to trace as '/u01/app/Oracle/controlfile.txt ';
3. Create a control file creation script from the tracefile generated in user_dump_dest.
Use the Noresetlogs option
4. Shutdown the database and start it in NOMOUNT mode
SQL> shutdown abort
SQL> startup nomount
5. Create the control file
Use the script generated by the 'backup controlfile to track' command above.
6. Recover the database
SQL> recover database;
7. Open the database
SQL> Alter database open;

Recommended reading:

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store

0

Oracle 10g patching (p5490848_10202_LINUX)

Authorize scott to enable execution

,