> should I just enter data01.dbf or
> should I also include the other .dbf files and what about the ts_X.ora
> files (presuming these are table space files should I include these
> too??)
>
You can test with just one to straighten out your db_block_size problem, but
eventually you`ll have to include all the files if you want a complete,
workable database. Just don`t try to open the db until you have all the file
names in there.
You`ll also have to include the redo log names in your controlfile command
and then once the db is atarted mount, do an alter database open resetlogs
to create those files.
--
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.0203080244.4e341f2f_at_posting.google.com...
> > > ts_1.ora
> > > ts_2.ora
> > > etc..
> > > ts_6.ora
> > > data01.dbf
> > > index01.dbf
> > > rollback_01.dbf
> > > temp.ora
>
> > > 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?
>
> Following on from my original comment, using the create controlfile
> command in the DATAFILE section should I just enter data01.dbf or
> should I also include the other .dbf files and what about the ts_X.ora
> files (presuming these are table space files should I include these
> too??)
>
> Thanks for your response,
>
> I'll let you know how I get along.
>
>
> Thank you,
>
>
> Graeme
Received on Fri Mar 08 2002 - 10:34:32 CST
