解決一次RMAN遲遲不能開始備份的問題

westzq1984發表於2009-12-22

今天真倒黴,一個資料的歸檔滿了,備份歸檔又一直失敗。
檢視RMAN日誌,發現是無法MOUNT磁帶

剛好今天備份DMP,佔用了2個驅動器,而且那臺機器無法配置LANFREE。tsm server又是100M網路卡,操
剛好另外一個庫做全備,要備3天。。。
這2個操作佔完了所有驅動器
剛好今天又在做資料處理,產生大量日誌。。。
什麼都磊到今天來。。。

先把今天做DMP備份的TSM程式給殺了,空2個驅動器出來,重新開始備份
等了半天,仍然不見備份開始,檢查RMAN端正常,檢查TSM,發現SESSION也正常
檢視了下後臺程式

tsm: TSM>q process

 Process     Process Description      Status                                          
  Number                             
--------     --------------------     -------------------------------------------------
  12,662     Space Reclamation        Volume Z12591L3 (storage pool ODS-DBBK), Moved  
                                       Files: 0, Moved Bytes: 0, Unreadable Files: 0, 
                                       Unreadable Bytes: 0. Current Physical File     
                                       (bytes): 34,079,210,561 Current input volume:  
                                       Z12591L3. Current output volume: 001090L3.     
  12,663     Space Reclamation        Volume A00011 (storage pool ORASTG), Moved Files:
                                       0, Moved Bytes: 0, Unreadable Files: 0,        
                                       Unreadable Bytes: 0. Current Physical File     
                                       (bytes): 4,720 Waiting for mount point in device
                                       class LTODEV (57 seconds).                     
  12,664     Space Reclamation        Volume A00016 (storage pool FSSTG), Moved Files:
                                       0, Moved Bytes: 0, Unreadable Files: 0,        
                                       Unreadable Bytes: 0. Current Physical File     
                                       (bytes): 2,147,737,399 Current input volume:   
                                       A00016.  
                                      
ODS-DBBK那個儲存池竟然在做Space Reclamation
於是把Space Reclamation的程式給cancel掉
tsm: TSM>cancel process 12662
ANR0940I Cancel request accepted for process 12662.

嘗試開始備份,但是其每完成一個備份片,就要重新做Space Reclamation

tsm: TSM>q stg ODS-DBBK f=d

               Storage Pool Name: ODS-DBBK
               Storage Pool Type: Primary
               Device Class Name: LTO3DEV
              Estimated Capacity: 95,637 G
                        Pct Util: 70.4
                        Pct Migr: 89.9
                     Pct Logical: 100.0
                    High Mig Pct: 90
                     Low Mig Pct: 70
                 Migration Delay: 0
              Migration Continue: Yes
             Migration Processes:
               Next Storage Pool:
            Reclaim Storage Pool:
          Maximum Size Threshold: No Limit
                          Access: Read/Write
                     Description:
               Overflow Location:
           Cache Migrated Files?:
                      Collocate?: No
           Reclamation Threshold: 40
 Maximum Scratch Volumes Allowed: 0
   Delay Period for Volume Reuse: 0 Day(s)
          Migration in Progress?: No
            Amount Migrated (MB): 0.00
Elapsed Migration Time (seconds): 0
        Reclamation in Progress?: Yes
 Volume Being Migrated/Reclaimed: Z12558L3
  Last Update by (administrator): ADMIN
           Last Update Date/Time: 12/12/08   15:39:17
        Storage Pool Data Format: Native
            Copy Storage Pool(s):
         Continue Copy on Error?:
                        CRC Data: No

回收的閥值是40

tsm: TSM>q vol stgpool=ODS-DBBK

看了下下還有空間能用

修改回收的閥值為100,暫時關閉回收

tsm: TSM>update stgpool ODS-DBBK reclaim=100
ANR2202I Storage pool ODS-DBBK updated.

備份正常,備份完成後修改會原閥值

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8242091/viewspace-623246/,如需轉載,請註明出處,否則將追究法律責任。

相關文章