Re: Help! Error in ORA file

Hi Szymon,

here is an Example:

CREATE CONTROLFILE REUSE
SET DATABASE order-db
LOGFILE GROUP 1 (’/users/redog1/mlog1.log’, ’/users/redog1/:mlog2.log’) SIZE 90M,
GROUP 2 (’/users/redog2/mlog1.log’, ’/users/redog2/mlog2.log’) SIZE 90M NORESETLOGS
DATAFILE ’/users/dbfile/ora1.dbf’ SIZE 100M MAXLOGFILES 5
MAXLOGHISTORY 100
MAXDATAFILES 10
MAXINSTANCES 2
ARCHIVELOG For more information refer to the Oracle SQL Language Reference or join a training for DBA.

Hope it helps

Tom

Szymon Budys schrieb:
>
> Thak You for answer!
> Sorry, but I don't know how should I recreate control file.
> I have tried to use servmgr30 and "recover datafile [myfile]" option but it
> didn't work. I have no backup copy of damaged file. In documentation I've read
> that in such ocassion I can create an empty file. But nor quite empty file (0
> kB) nor empty database ORA file created in another Oracle8 server was good.
>
> dstr016_at_ibm.net wrote:
>
> > You should recreate the control file excluding the damaged data file in the
> > list of files. Then you will be able to open the database.
>
> Szymon Budys (sorry for my english :-)
Received on Wed Sep 01 1999 - 08:42:45 CDT