-
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
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 .
Vinit
-
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!
-
I am not sure abt the exact syntex.. it goes like...
alter database clear unarchived logfile <>;
where n is group no. which got corrupted.
-nagarjuna
-
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.
Vinit
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|