Snap Dragon wrote:
> Oracle enterprise v 7.2.3.0.0
> Sun solaris 2.6
>
> One of the disks on the server had to be replaced - unfortunately there
> is no back up of the disk.
>
> I had lost controlfile, datafiles and log files. I have recovered the
> controlfile, recreated the datafiles (the data is not so important as it
> gets copied from another database weekly). Is there anyway I can
> recreate the logfile and get the database to open?
>
> There were three logfile groups each containing one logfile - all on
> this disk - I have dropped and recreated the other two but I don't know
> what to do about the current one.
>
> All suggestions gratefully received.
> Snap
>
>
The key is to 'reset' your redo log files. Try something like this (but
change to suit your environment):
SQLPLUS /NOLOG
CONNECT / AS SYSDBA
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS ARCHIVELOG
LOGFILE
GROUP 1 '/oracle/oradata/test/redo01.log' size 1m,
GROUP 2 '/oracle/oradata/test/redo02.log' size 1m,
GROUP 3 '/oracle/oradata/test/redo03.log' size 1m
DATAFILE
'/oracle/oradata/test/system01.dbf',
...[all your data files]...
CHARACTER SET WE8ISO8859P1;
Received on Tue Dec 03 2002 - 10:21:06 CST
