Loss of unarchived log file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Loss of unarchived log file

  1. #1
    Join Date
    Nov 2000
    Posts
    224

    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.

  2. #2
    Join Date
    Oct 2000
    Posts
    467

    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

  3. #3
    Join Date
    Nov 2000
    Posts
    224
    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!

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    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

  5. #5
    Join Date
    Oct 2000
    Posts
    467
    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
  •  



Click Here to Expand Forum to Full Width