Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do when there are ORA-01122 errors in oracle. I hope you will get something after reading this article. Let's discuss it together.

Phenomenon:

While doing the tablespace recovery walkthrough, you encountered the following error prompt:

SQL > alter database datafile 4 online

Alter database datafile 4 online

*

ERROR at line 1:

ORA-01122: database file 4 failed verification check

ORA-01110: data file 4:'/ ora/app/oracle/oradata/orcl/users01.dbf'

ORA-01210: data file header is media corrupt

Solution:

Analyze the reasons:

[oracle@test hotback] $oerr ora 1122

01122, 00000, "database file s failed verification check"

/ / * Cause: The information in this file is inconsistent with information

/ / from the control file. See accompanying message for reason.

/ / * Action: Make certain that the db files and control files are the correct

/ / files for this database.

[oracle@test hotback] $oerr ora 1110

01110, 00000, "data file% s:'% s"

/ / * Cause: Reporting file name for details of another error. The reported

/ / name can be of the old file if a data file move operation is

/ / in progress.

/ / * Action: See associated error message.

[oracle@test hotback] $oerr ora 1210

01210, 00000, "data file header is media corrupt"

/ / * Cause: The file header block is internally inconsistent. The beginning

/ / of the block has a header with a checksum and other data for

/ / insuring the consistancy of the block. It is possible that

/ / the last disk write did not operate correctly. The most likely

/ / problem is that this is not a datafile for any database.

/ / * Action: Have operating system make correct file available to database.

/ / If the trace file dump indicates that only the checksum is wrong

/ / restore from a backup and do media recovery.

Basically, the restored data file is incorrect. After careful examination, it was as follows:

Ho cp'/ ora/app/oracle/backup/hotback/con01.ctl''/ ora/app/oracle/oradata/orcl/users01.dbf'

The backup control file is restored as a data file!

Restore again:

SQL > ho cp'/ ora/app/oracle/backup/hotback/users01.dbf''/ ora/app/oracle/oradata/orcl/users01.dbf'

The next steps are performed correctly.

After reading this article, I believe you have a certain understanding of "what to do with ORA-01122 errors in oracle". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.