Re: Broken database?

"Syltrem" <syltrem_at_videotron.spammenot.ca> wrote in message news:<pIKh8.2443$a04.13078_at_tor-nn1.netcom.ca>...
> 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
>

This hasn't worked. Any other thoughts?

Regards,

Graeme

> 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
Received on Fri Mar 08 2002 - 11:18:20 CST