Posted by: baskardba | May 28, 2010

ORA-01122: database file 16 failed verification check

hi,

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:
‘/xxx/data/system01.dbf’

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

Solution.

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 :
/xxx/data/archive/1_1_720170170.dbf
ORA-00280: change 5965182104509 for thread 1 is in sequence #1

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

SQL> alter database open resetlogs;

Database altered.

happy learning,

baskar.l

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

Categories

%d bloggers like this: