same error message ORA-27046: file size is not a multiple of logical block
size
?
--
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.0203080918.7a91411e_at_posting.google.com...
> "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 - 12:08:29 CST
