Home » RDBMS Server » Server Administration » Failed verification check (10g, LINUX)
icon5.gif  Failed verification check [message #404970] Mon, 25 May 2009 21:50 Go to next message
v_zaitsev
Messages: 12
Registered: May 2009
Location: Manila
Junior Member
Hello, I need help with this. One of our developers reported that when he accessed a certain database it returns an error:

ORA-01033: ORACLE initialization or shutdown in progress

I tried bouncing the oracle database but it returned an error:

ERROR at line 1:
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/ccb_oradata_01/CD22ARCH/system01.dbf'
ORA-01251: Unknown File Header Version read for file number 1

So tried restoring and recovering the datafile/tablespace but it also returned the same error above that the datafile failed the verification check. Researched on the net and I've encountered a solution that would require a back up to trace and get the sql from the trace file and ran it in nomount state. Below is the sql statement:

CREATE CONTROLFILE REUSE DATABASE "CD22ARCH" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2540
LOGFILE
GROUP 1 '/ccb_oradata_01/CD22ARCH/redo02.log' SIZE 10M,
GROUP 2 '/ccb_oradata_01/CD22ARCH/redo01.log' SIZE 10M,
GROUP 3 '/ccb_oradata_01/CD22ARCH/redo03.log' SIZE 10M
DATAFILE
'/ccb_oradata_01/CD22ARCH/system01.dbf' SIZE 301000K,
'/ccb_oradata_01/CD22ARCH/SYSTEM.dbf' SIZE 307200K,
'/ccb_oradata_01/CD22ARCH/UNDOTBS1.dbf' SIZE 122736K,
'/ccb_oradata_01/CD22ARCH/SYSAUX.dbf' SIZE 132968K,
'/ccb_oradata_01/CD22ARCH/CISTS_01.dbf' SIZE 307205K,
'/ccb_oradata_01/CD22ARCH/TEMP.dbf' SIZE 50000K ,
'/ccb_oradata_01/CD22ARCH/temp01.dbf SIZE 50000K'
CHARACTER SET WE8ISO8859P15
/

However somethings weird about this line >>>> '/ccb_oradata_01/CD22ARCH/CISTS_01.dbf' SIZE 307205K it keeps on saying that i have computed the incorrect number of blocks but I have used the correct parameters for the formula (e.g. 8192 bytes for the blocks) but it kept saying that I have computed wrong number of blocks.

Is there any other way to work around this problem? Or since it is a system datafile do I need to just recreate a database? Thanks for the he
Re: Failed verification check [message #404976 is a reply to message #404970] Mon, 25 May 2009 22:55 Go to previous message
BlackSwan
Messages: 25047
Registered: January 2009
Location: SoCal
Senior Member
http://www.dbforums.com/oracle/1643004-failed-verification-check.html#post6401401
Previous Topic: ORA-01092
Next Topic: Hit ORA-03232: unable to allocate an extent of 18 blocks from tablespace 3
Goto Forum:
  


Current Time: Wed Dec 07 14:43:05 CST 2016

Total time taken to generate the page: 0.28745 seconds