Posted by: baskardba | May 28, 2010

ORA-01122: database file 16 failed verification check


Recently i faced this issue…

While opening the database

SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01187: cannot read from file 1 because it failed verification tests
ORA-01110: data file 1:

In alert log it shows

ORA-01186: file 16 failed verification tests
ORA-01122: database file 16 failed verification check
ORA-01110: data file 16: ‘/xxx/data/a_ref03.dbf’
ORA-01206: file is not part of this database – wrong database id
File 16 not verified due to error ORA-01122


SQL> startup mount;
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size                  1265844 bytes
Variable Size             432017228 bytes
Database Buffers          629145600 bytes
Redo Buffers               11313152 bytes
Database mounted.
SQL> recover database until cancel using backup controlfile;
ORA-00279: change 5965182104509 generated at 05/28/2010 07:17:43 needed for
thread 1
ORA-00289: suggestion :
ORA-00280: change 5965182104509 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
Media recovery cancelled.

SQL> alter database open resetlogs;

Database altered.

happy learning,



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: