Loss of unarchived log file

[Sharma]

Oracle 815/NT
Database is shutdown, when trying to start the database getting error in one of the redolog file.
Check the status of the redolog file in V$LOG and it looks like the logfile is not archived.
Issuing command
ALTER DATABASE CLEAR LOGFILE ‘c:\oracle\oradata\redo\redo11.ora’ unrecoverable datafile;
It also gives error message.
I can't drop the group as it is not archived. Group contains only one members.
Please tell me what are the options I have other than Incomplete recovery.

[vinit]

Originally posted by Sharma
Oracle 815/NT
Database is shutdown, when trying to start the database getting error in one of the redolog file.
Check the status of the redolog file in V$LOG and it looks like the logfile is not archived.
Issuing command
ALTER DATABASE CLEAR LOGFILE ‘c:\oracle\oradata\redo\redo11.ora’ unrecoverable datafile;
It also gives error message.
I can't drop the group as it is not archived. Group contains only one members.
Please tell me what are the options I have other than Incomplete recovery.

If the database was closed properly, all you need to do is drop the log and resetlogs. This will be a complete recovery since all information is already in the datafiles.
Also check out the disk space where the archivelogs are .

[Sharma]

Vinit,

I tried to drop the group but it does not allows to do so as that group is not archived.
I also tried to open the database with resetlogs, but it says you can only resetlogs after incomplete recovery.

Let me know if I am wrong any where.

Thanks!

[nagarjuna]

I am not sure abt the exact syntex.. it goes like...

alter database clear unarchived logfile <>;

where n is group no. which got corrupted.

[vinit]

Originally posted by Sharma
Vinit,

I also tried to open the database with resetlogs, but it says you can only resetlogs after incomplete recovery.

Let me know if I am wrong any where.

Thanks!

Sorry..I was wrong here.