11 Replies Latest reply: Mar 16, 2013 4:02 AM by pj*433620*ng RSS

    When will archivelog in fast_recovery_area been deleted

    pj*433620*ng
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            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
                              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