Archivelog deleted
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Archivelog deleted

  1. #1
    Join Date
    Apr 2012
    Posts
    2

    Archivelog deleted

    Dear all,
    I have a production DB which is backed up daily including archives , and will be deleted from the server using " delete input " command after backued up.

    The problem is when I tried to do restore , I faced those two error ( Rman-6053 - Rman-6025 )
    --> RMAN 6053 unable to perform media recovery because of missing log
    --> RMAN 6025 no backup of log thread 1 sequence 1554 lowscn ......

    and when I checked the alert log file , I found thouse archives deleted ,
    Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1554_7SMBB5Y6_.ARC
    Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1555_7SMBBDQD_.AR

    So how it's possible , since I have good space in the FRA

    What the reasons & assumptions that deleted this file ?

    Alert Log :
    Starting control autobackup
    Fri Apr 27 18:22:57 2012
    Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_3020.trc:

    Fri Apr 27 18:22:57 2012
    Errors in file c:\oracle\product\10.2.0\admin\mydb\mydb_ora_3020.trc:

    Fri Apr 27 18:22:57 2012
    Errors in file c:\oracle\product\10.2.0\admin\mydb\udump\mydb_ora_3020.trc:

    Control autobackup written to SBT_TAPE device
    comment 'API Version 2.0,MMS Version 1.2.0.0',
    media 'DD860HQ1.001.RO'
    handle 'c-921460516-20120427-00'
    Fri Apr 27 18:23:11 2012
    Thread 1 advanced to log sequence 1586
    Current log# 1 seq# 1586 mem# 0: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\mydb\ONLINELOG\O1_MF_1_7OVXNPSF_.LOG
    Thread 1 advanced to log sequence 1587
    Current log# 3 seq# 1587 mem# 0: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\mydb\ONLINELOG\O1_MF_3_7OVXO0SF_.LOG
    Fri Apr 27 18:23:13 2012
    Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1554_7SMBB5Y6_.ARC
    Deleted Oracle managed file D:\ARCHIVE\mydb\ARCHIVELOG\2012_04_26\O1_MF_1_1555_7SMBBDQD_.ARC
    Fri Apr 27 18:24:31 2012

    Best Regards

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    did you check if the missing archive logs are available in RMAN catalog using 'list archive log ' command? Please run the list archive log command and post the output.

    Regards,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    Dear Vijay Tummala ,

    Thanks for your reply

    I already issued this command & it doesn't show me the missing archives , it's deleted from there also.

    Regards

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    would you mind to run the same commad and post the output?

    Regards,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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