Re: LogFille corrupted

Helmut Hahn (helmut.hahn_at_bitoek.uni-bayreuth.de) wrote:
> Hallo,
 

> I have a Oracle 7.3.2 database on NT4.0 > 5GB on a raid 5 system. I have
> two redologgroups with 1 member each. I did a complete copy of the db but
> only one logfile.
> Then I did some tests with the db. I copied back the original db, but the
> one logfile doesn't match the original db, because it was used during my
> tests. Now I can't open the db, because the missed logfile was online
> during copyieng. I have tried to drop the logfile and to disable the thread
> which uses this logfile. The doku says that I can disable a thread when the
> db is mounted, but servermanager says that the db must be open to do this.
> Is there a chance to open the db? Please help me!

you may be able to...when you did a complete copy of the db w/o the one logfile, did you do a cold backup and was the cold backup after you did a shutdown normal or immediate (NOT abort)? If so, what you could do is force the database to reset the online redo logs.

To do this, you will need to mount the restored database, and fake a manual recovery by doing:

SVRMGRL> recover database using backup controlfile until cancel;

It will then prompt you to apply a redo log. Type 'cancel' here and it should bring you back to the prompt. Then issue:

SVRMGRL> alter database open resetlogs;

Assuming the above assumptions were indeed correct, your database should open, though there could be some lost transactions.

Good luck.

Johnny Chan
Independent Oracle Specialist Received on Wed Jun 11 1997 - 00:00:00 CDT