 Failed verification check [message #404970] |
Mon, 25 May 2009 21:50  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
