View Other Posts

Disclaimer

All data and information provided on this blog is for informational purposes only. Oracleapps11idba.blogspot.com makes no representations as to accuracy, completeness, currentness, suitability, or validity of any information on this site and will not be liable for any errors, omissions, or delays in this information or any losses, injuries, or damages arising from its display or use. All information is provided on an as-is basis.Please use your discretion before taking any decisions based on the information in this blog.

Monday, August 31, 2009

How to Resolve ORA-27063 ORA-01114 ORA-01110 Errors


During hardware failure we got following error while starting one of our instances.

ALTER DATABASE OPEN
Thu Aug 6 23:21:00 2009
Errors in file /u01_orcltest/db/10.2.0/admin/ORCLTEST_orcltestdb01/udump/orcltest_ora_8866.trc:
ORA-01110: data file 407: '/u02_orcltest/data/apps_ts_queues_001.dbf'
ORA-01114: IO error writing block to file 407 (block # 1)
ORA-27063: number of bytes read/written is incorrect
Additional information: 8192
Thu Aug 6 23:21:00 2009
ORA-01201: file 407 header failed to write correctly
ORA-1113 signalled during: ALTER DATABASE OPEN...

We thought that the above file got currepted and we need to do media recovery and when we tried to recover database we got the same error again.

Thu Aug 6 23:48:28 2009
ALTER DATABASE RECOVER database
Thu Aug 6 23:48:28 2009
Media Recovery Start
Thu Aug 6 23:48:28 2009
Errors in file /u01_orcltest/db/10.2.0/admin/ORCLTEST_orcltestdb01/udump/orcltest_ora_13199.trc:
ORA-01110: data file 407: '/u02_orcltest/data/apps_ts_queues_001.dbf'
ORA-01114: IO error writing block to file 407 (block # 1)
ORA-27063: number of bytes read/written is incorrect
Additional information: 8192
Thu Aug 6 23:48:28 2009
Media Recovery failed with error 1201
ORA-283 signalled during: ALTER DATABASE RECOVER database ...


At this point we asked our Unix team to unmount and mount file system again for this instance. Once file system remounted we tried to open database but failed with ORA error again. In order to save our database at this point we recovered database using online redo log files.

ORA-279 signalled during: ALTER DATABASE RECOVER database using backup controlfile until cancel ...
Fri Aug 7 01:33:12 2009
ALTER DATABASE RECOVER LOGFILE '/u02_orcltest/data/log01a.log'
Fri Aug 7 01:33:12 2009
Media Recovery Log /u02_orcltest/data/log01a.log
Fri Aug 7 01:33:14 2009
Incomplete recovery applied all redo ever generated.
Recovery completed through change 1136061258397
Fri Aug 7 01:33:14 2009
Media Recovery Complete (ORCLTEST)
Completed: ALTER DATABASE RECOVER LOGFILE '/u02_orcltest/data/log01a.log'
Fri Aug 7 01:33:26 2009
alter database open resetlogs
Fri Aug 7 01:33:27 2009
RESETLOGS after complete recovery through change 1136061258397
Resetting resetlogs activation ID 2533705982 (0x970548fe)

No comments:

Post a Comment