Re: Newbie: Help I've lost my current logfile

Karsten Farrell <kfarrell_at_belgariad.com> wrote in message news:<SR4H9.30$7p4.4247760_at_newssvr13.news.prodigy.com>...
> 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;
You write that you have recovered the controlfile, so I think you will not need the CREATE CONTROLFILE command. In order to be able to start your DB, you can do what is called a "very incomplete recovery", but then, THE INFORMATION IN YOUR LOGFILE WILL BE LOST, YOU WILL ONLY HAVE THE DATA THAT WAS IN YOUR DATAFILES WHEN THE SYSTEM CRASHED!!! I've never done this, this command should be used very carefully, so look what the others say.  

    recover database until cancel
    cancel
    alter database resetlogs

Best Regards,
Uwe Received on Thu Dec 05 2002 - 06:13:37 CST