Create Control Files Error ORA-01163 1

[molefen]

I have an Oracle database 10g (10.2.0.1.0) which has crashed due to the Windows Server 2003 box went bananas. Anyway I've since resintalled Oracle Database on a fresh box and I also managed to recover all database files except control files and redo logs. I set up a sample database in which I deliberately deleted the control files and redo logs for test purposes and issued a create controlfile script as follows:

CREATE CONTROLFILE DATABASE "Sample" RESETLOGS
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 8
MAXLOGHISTORY 300
DATAFILE
'C:\oracle\product\10.2.0\oradata\SAMPLE\sysaux01.dbf' size 256000K,
'C:\oracle\product\10.2.0\oradata\SAMPLE\system01.dbf' size 491520K,
'C:\oracle\product\10.2.0\oradata\SAMPLE\undotbs01.dbf' size 30720K,
'C:\oracle\product\10.2.0\oradata\SAMPLE\example01.dbf' size 102400K,
'C:\oracle\product\10.2.0\oradata\SAMPLE\users01.dbf' size 5120K,
;

Now here is the problem: ORA-01163: SIZE Clause indicates 12800 (blocks), but should match header 640. This is reported for the users01.dbf file. The strange part 640 blocks = 640*8192 bytes = 5242880 = 5120K which is exactly what I have used in my script.

Any ideas why this is happening?

Thanks a lot

 

[Turkbear]

Hi,
Same block size for all files?
Are you reusing any files?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[molefen]

Hi Turkbear,

Yes all my dbf files have the same block size of 8192 bytes.
I'm not reusing any files as I've lost control files and redo logs.

Thanks again

 

[Turkbear]

Hi,
Odd...

Just a thought, try removing the last comma ( the one after users01.dbf SIZE 5120K ) - it may be confusing the parser.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[molefen]

You know Turkbear, I've been starring at that script for hours and hours and I didn't notice that. And guess what! That was the problem.

Thanks a lot Mate

 

[Turkbear]

Hi,
Been there, done that.

Glad to help...





To Paraphrase:"The Help you get is proportional to the Help you give.."