Archive log error in alert log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Archive log error in alert log

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Archive log error in alert log

    I was running out of space on my server so i deleted some archive log on the disk.

    I have valid backups on tape.(cold backup + full exports)

    But i see those errors in my alert file.


    "Wed Oct 18 15:33:07 2006
    Thread 1 advanced to log sequence 571
    Current log# 1 seq# 571 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLASP\ONLINELOG\O1_MF_1_2CH74GXL_.LOG
    Current log# 1 seq# 571 mem# 1: D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCLASP\ONLINELOG\O1_MF_1_2CH74PFH_.LOG
    Wed Oct 18 15:33:23 2006
    WARNING: Cannot delete Oracle managed file D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCLASP\ARCHIVELOG\2006_08_17\O1_MF_1_122_2G91QLNX_.ARC
    Wed Oct 18 15:33:23 2006
    Errors in file d:\oracle\product\10.2.0\admin\orclasp\bdump\orclasp_arc1_4256.trc:
    ORA-01265: Unable to delete ARCHIVED LOG D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCLASP\ARCHIVELOG\2006_08_17\O1_MF_1_122_2G91QLNX_.ARC
    ORA-27056: could not delete file
    OSD-04029: unable to get file attributes
    O/S-Error: (OS 3) The system cannot find the path specified.
    "


    Wow can i tell oracle that i deleted archive logs?

    Or is there a way to delete those files with Oracle Enterprise Manager 10g?

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    You should launch RMAN:

    Code:
    D:\>rman target /
    and run the following:

    Code:
    RMAN> CROSSCHECK ARCHIVELOG ALL;
    RMAN> DELETE EXPIRED ARCHIVELOG ALL;

  3. #3
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88
    ebrian, I would agree...

    and Steve123, for future references, use RMAN to remove backup and archivelogs and you shouldn't have this problem again.



    smoothyc of NC.

  4. #4
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    Hi Friends,,,,thanks for the commands...iwas able to use it too

    I'm just curious...what others "crosscheck" commands available?

    I only only know....
    crosscheck backup;
    crosscheck archivelog all;

    Is there also crosscheck controlfile? and any other crosschecks?

    Thanks
    Behind The Success And Failure Of A Man Is A Woman

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