Re: Broken database?

Try changing your db_block_size in init.ora and issue the command again. Your init.ora may not be in synch with your .dbf files. common values are 2048, 4096, 8192

Make sure you do a backup of all your files before you fool around with them!

HTH

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"Graeme Barnett" <gbarnett_at_csl.co.uk> a écrit dans le message de news:
47120ba9.0203070514.36a87959_at_posting.google.com...


> I'm a developer with no DBA experience - until now.

> I've had to try and initialise a database which has been out of order

> for a while. I've found out that the database control files don't

> exist anymore. I learnt from searching old

> 'comp.databases.oracle.server' messages how to use the create

> controlfile command.

>

> The command I'm running brings up the following error:

>

> ORA-1053: CREATE CONTROLFILE failed

> ORA-01565: error in idenfifying file '...'

> ORA-27046: file size is not a multiple of logical block size

>

> I am concerned as the data files don't show the standard system data

> files that I'm used to seeing. I.e. system01.dbf and users01.dbf etc.

> Am I up the proverbial canal without a paddel?

>

> The list of the oradata directory is included below:

>

> ts_1.ora

> ts_2.ora

> etc..

> ts_6.ora

> data01.dbf

> index01.dbf

> rollback_01.dbf

> temp.ora

>

> (and .log files)

>

> In my create controlfile statement I only included the 'data01.dbf' in

> the DATAFILE section and it created the error.

> Does this mean it is totally corrupt?

>

>

> Any help or suggestions much appreciated.

>

>

> Regards,

>

>

> Graeme