This discussion is archived
11 Replies Latest reply: Mar 16, 2013 2:02 AM by pj*433620*ng RSS

When will archivelog in fast_recovery_area been deleted

pj*433620*ng Newbie
Currently Being Moderated
Hi,
I configured fast_recovery_area for my instance,months ago, the old archivelog in fast_recovery_area will be auto deleted when the space in fast_recovery_area been used up,
but this suddenly stop working, I have to manually delete the archivelog to free up some space in fast_recovery_area.
The archivelogs in fast_recovery_area was backed up daily.

Anyone know what others factor will cause this?

Thanks

Pek
  • 1. Re: When will archivelog in fast_recovery_area been deleted
    Fran Guru
    Currently Being Moderated
    did you modified rman backups? or rman configuration (retention policy)?

    show
    rman> show all;
  • 2. Re: When will archivelog in fast_recovery_area been deleted
    moreajays Pro
    Currently Being Moderated
    Pek,

    You need to delete archives manually or you may use DELETE INPUT clause in RMAN backup archivelog command which will delete archives once backed up on disk or tape.

    If FRA used for backup then BACKUP RECOVERY AREA ( 11g ) using RMAN & then delete expired backups to clean it up

    Use v$flash_recovery_area_usage to monitor usage of FRA or increase db_recovery_file_dest_size


    Thanks,
    Ajay More
    http://www.moreajays.com
  • 3. Re: When will archivelog in fast_recovery_area been deleted
    pj*433620*ng Newbie
    Currently Being Moderated
    Hi,
    Pleaes see the alert log from my db, the archivelog file was deleted by Oracle itself.
    But somehow one of my instance stop doing this...

    2013-03-06 20:46:32.536000 +08:00
    Deleted Oracle managed file G:\OFSDB\OFS8\FLASH_RECOVERY_AREA\OFS8\ARCHIVELOG\20
    13_02_15\O1_MF_1_4169_8KTZ6LDN_.ARC
    2013-03-06 21:10:37.811000 +08:00
    Deleted Oracle managed file G:\OFSDB\OFS8\FLASH_RECOVERY_AREA\OFS8\ARCHIVELOG\20
    13_02_15\O1_MF_1_4170_8KTZYHO3_.ARC
    Archived Log entry 5066 added for thread 1 sequence 5066 ID 0x57dd47ff dest 1:
    2013-03-06 21:32:03.319000 +08:00
    Thread 1 cannot allocate new log, sequence 5068
    Private strand flush not complete
    Current log# 2 seq# 5067 mem# 0: G:\OFSDB\OFS8\ORADATA\OFS8\REDO02.LOG
    2013-03-06 21:32:06.397000 +08:00
    Thread 1 advanced to log sequence 5068 (LGWR switch)
    Current log# 1 seq# 5068 mem# 0: G:\OFSDB\OFS8\ORADATA\OFS8\REDO01.LOG
    2013-03-06 21:32:10.210000 +08:00
    Deleted Oracle managed file G:\OFSDB\OFS8\FLASH_RECOVERY_AREA\OFS8\ARCHIVELOG\20
    13_02_15\O1_MF_1_4171_8KV15HVP_.ARC
    2013-03-06 21:51:06.030000 +08:00
    Deleted Oracle managed file G:\OFSDB\OFS8\FLASH_RECOVERY_AREA\OFS8\ARCHIVELOG\20
    13_02_15\O1_MF_1_4172_8KV23M9T_.ARC
  • 4. Re: When will archivelog in fast_recovery_area been deleted
    moreajays Pro
    Currently Being Moderated
    Pek,

    Can you please confirm on below rman config value , which is responsible for auto deletion

    RMAN>show all;

    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF xx DAYS;

    CONFIGURE ARCHIVELOG DELETION POLICY TO xx;

    Thanks,
    Ajay More
    http://www.moreajays.com
  • 5. Re: When will archivelog in fast_recovery_area been deleted
    pj*433620*ng Newbie
    Currently Being Moderated
    Hi, Ajay
    Thanks for the reply.
    Both instances have the same setting

    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

    but one instance delete archivelog automatically, but another don't, it's weird...

    Pek
  • 6. Re: When will archivelog in fast_recovery_area been deleted
    Fran Guru
    Currently Being Moderated
    check your backups scripts. probably one of them are deleting archivelogs.

    deletion are execute at same hour everyday? check if you configured any script on cron ...
  • 7. Re: When will archivelog in fast_recovery_area been deleted
    moreajays Pro
    Currently Being Moderated
    Pek,

    Can you confirm below

    show parameter db_recovery_file_dest_size
    select * from v$flash_recovery_area_usage;
    select space_used/(1024*1024*1024),space_limit/(1024*1024*1024) from v$recovery_file_dest;
    select max(sequence#),max(FIRST_TIME),thread# from v$backup_redolog group by thread#;

    Is it RAC ? how many nodes ? As OMF Archives getting deleted from other instance does if includes other thread archives also ?

    Thanks,
    Ajay More
    http://www.moreajays.com
  • 8. Re: When will archivelog in fast_recovery_area been deleted
    jgarry Guru
    Currently Being Moderated
    Could something else on the device be using up space that Oracle doesn't know about? Are different instances sharing space? In addition to what Ajay asked for, also show us what the OS thinks is going on.
  • 9. Re: When will archivelog in fast_recovery_area been deleted
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Query V$RECOVERY_AREA_USAGE to see what the Oracle database instance thinks is the current usage of FRA. If the current usage is much higher (because of files that Oracle isn't aware of) you will see the actual free space much lesser than what Oracle expects. The database instance is aware only of files that it maintains in the FRA (control files, online redo logs, archivelogs, backuppieces) and monitors space usage by these files. When space usage exceeds a threshold, it starts deleting older archivelogs that are not required for recovery. However, if space is consumed by some other files, the database instance will assume that there is free space and will not delete older archivelogs.


    Hemant K Chitale
  • 10. Re: When will archivelog in fast_recovery_area been deleted
    pj*433620*ng Newbie
    Currently Being Moderated
    Hi,
    I am using ASM for the fast_recovery_area, in the RECO diskgroup
    Below is the output from v$recovery_area_usage, it's shown only abot 56% of space been used.
    But in the ASM EM page, it show 95.5% of the disk group been used.
    Should these two values different for that much?

    FILE_TYPE     PERCENT_SPACE_USED     PERCENT_SPACE_RECLAIMABLE     NUMBER_OF_FILES
    CONTROL FILE     0     0     0
    REDO LOG     0     0     0
    ARCHIVED LOG     55.25     55.25     336
    BACKUP PIECE     1.71     1.71     1
    IMAGE COPY     0     0     0
    FLASHBACK LOG     0     0     0
    FOREIGN ARCHIVED LOG     0     0     0


    Thanks

    Pek
  • 11. Re: When will archivelog in fast_recovery_area been deleted
    pj*433620*ng Newbie
    Currently Being Moderated
    Hi,
    I figured out the root cause, it's because I set the db_recovery_file_dest_size to a higher value than the available space in the diskgroup.

    Thanks for all the replies

    Pek

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points