Loss of unarchived log file
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.
Re: Loss of unarchived log file
Quote:
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 .