Bugra Canbakal's Oracle Blog

  • Home
  • Contact
  • SITE MAP
You are here: Home / Oracle / 11.2.0.3 Otomatik archivelog deletion bug

11.2.0.3 Otomatik archivelog deletion bug

Haziran 12, 2013 By Bugra Canbakal Leave a Comment

1.AMAÇ VE KAPSAM

Oracle 11.2.0.3 versionunda bulunan FRA dolunca archiveloglarin silinmesini engelleyen bug’in cozumunu anlatacagim.

2.UYGULAMA

2.1. Normalde FRA dolma seviyesine gelip yere ihtiyac duydugunda veritabani archiveloglari inceleyip gereksiz gordugu archiveloglari silmeye baslar. 11.2.0.3 de bulunan bir bug’tan oturu veritabani hangi loglari silebileceginin analizini yapmamakta bunu yaptirmak icin duzenli olarak bir dbms package  calistirip viewu refresh etmemiz gerekiyor.

PUBLIC@CROORAFLP01:APMTMART_SBY: >SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                             27                         0               9
ARCHIVED LOG                      68.89                         0              35
BACKUP PIECE                        .09                         0               1
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0

7 rows selected.

2.2. Bu query’i standby databasimde calistirdim, calistirdigim sirada standby yeni archivelog beklemekteydi yani mevcut olan archiveloglarin hepsi silinebilir durumdaydi. Eger veritabani duzgun calissaydi ARCHIVED LOG satirinda  PERCENT_SPACE_RECLAIMABLE kolonu 0 yerine  68.89 gostermesi gerekirdi. Daha onceden bahsetmis oldugum dbms_backup_restore.refreshagedfiles  package’ini calistirip view’u manuel refresh yapacagim.

PUBLIC@CROORAFLP01:APMTMART_SBY: >exec dbms_backup_restore.refreshagedfiles ;

PL/SQL procedure successfully completed.

2.3. Simdi select query’imizi tekrardan calistiralim.

PUBLIC@CROORAFLP01:APMTMART_SBY: >SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE                          0                         0               0
REDO LOG                             27                         0               9
ARCHIVED LOG                      68.92                     68.92              40
BACKUP PIECE                        .09                         0               1
IMAGE COPY                            0                         0               0
FLASHBACK LOG                         0                         0               0
FOREIGN ARCHIVED LOG                  0                         0               0

7 rows selected.

2.4. View’u refresh yapmadan once FRA da alan sikintisi yasamaktaydim, simdi tekrardan alert log u kontrol edelim.

Deleted Oracle managed file /oradata/APMTMART/fast_recovery_area/APMTMART_SBY/archivelog/2013_04_23/o1_mf_1_744_8qft2zkl_.arc
RFS[2]: Selected log 11 for thread 1 sequence 785 dbid -1961087772 branch 799952871
Archived Log entry 761 added for thread 1 sequence 784 ID 0x8b1d6fb5 dest 1:
Deleted Oracle managed file /oradata/APMTMART/fast_recovery_area/APMTMART_SBY/archivelog/2013_04_24/o1_mf_1_745_8qgffjbw_.arc

2.5. Alert logda gereksiz gorulen archiveloglarin silinmeye baslamis oldugunu goruyoruz, dbms_backup_restore.refreshagedfiles
package’ini crontab a veya db job olarak schedule edip bu sorunu asabilirsiniz.

Bunu paylaş:

  • Linkedln üzerinden paylaşmak için tıklayın (Yeni pencerede açılır) LinkedIn
  • X'te paylaşmak için tıklayın (Yeni pencerede açılır) X

Filed Under: Oracle Tagged With: 11.2.0.3, archivelog bug, archivelog deletion.archivelog deletion bug, bug, oracle

Bir Cevap YazınCevabı iptal et

This site uses Akismet to reduce spam. Learn how your comment data is processed.

About Me



Dil:

  • English
  • Turkish

Kategoriler

  • Oracle
    • RAC – Real Application Cluster
    • RMAN
    • Single Node
    • Standby – Dataguard
  • OS
    • Linux

Blogroll

  • Emre Baransel
  • Gökhan Atıl
  • H. Tonguc Yılmaz
  • Kamil Türkyılmaz
  • Tanel Poder
  • Turkce Oracle
  • Turkish Oracle User Group
  • Uwe Hesse
  • Zekeriya Beşiroğlu

Arşivler

  • Nisan 2014
  • Mart 2014
  • Ağustos 2013
  • Haziran 2013
  • Mart 2013
  • Ocak 2013
  • Aralık 2012
  • Kasım 2012
  • Temmuz 2012
  • Haziran 2012
  • Mayıs 2012
  • Ocak 2012
  • Kasım 2011
  • Ekim 2011
  • Ağustos 2011
  • Temmuz 2011
  • Haziran 2011
  • Şubat 2011
  • Ocak 2011
  • Aralık 2010
  • Kasım 2010
  • Haziran 2010
OCP
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Çerez Politikası

[footer_backtotop]

Copyright © 2010-2014 Bugra Canbakal. All rights reserved.