oracle 带库,ORACLE RMAN下针对带库装置的操作

ORACLE RMAN下针对带库设备的操作

带库或VTL作为关键业务的备份，虽在普通用户接触较少，但总体使用量还是比较大。

很多实例在做专业备份软件的同时会采用disk方式在本地或共享地址上再备一次，如果专业备份软件采用的是带库或VTL方式进行存储，在cross check后发现存在大量的备份集仍然无法删除，可以参考本文。

export ORACLE_SID=bzzh1

date >> /home/oracle/rman_log/rman_delete.log

rman target / append << EOF

configure device type disk parallelism 16;

allocate channel for maintenance device type disk;

run

{

crosscheck backup;

delete expired backup;

crosscheck archivelog all;

delete noprompt obsolete device type disk;

delete noprompt expired archivelog all;

}

release channel;

##for TAPE##

allocate channel for maintenance device type 'sbt_tape';

run

{

crosscheck backup;

delete expired backup;

crosscheck archivelog all;

delete noprompt obsolete device type 'sbt_tape';

delete noprompt expired archivelog all;

}

release channel;

EOF

date >> /home/oracle/rman_log/rman_delete.log

需要注意，仅当backupset的Device Type为SBT_TAPE是参考本文才有意义。

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

3177    Incr 0  256.00K    SBT_TAPE    00:00:47     30-JUL-15

BP Key: 3137   Status: AVAILABLE  Compressed: NO  Tag: HOT_DB_BK_LEVEL0

Handle: bk_3229_1_886451722   Media:

SPFILE Included: Modification time: 10-JUL-15

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

3179    83.75M     SBT_TAPE    00:00:57     30-JUL-15

BP Key: 3139   Status: AVAILABLE  Compressed: NO  Tag: TAG20150730T203744

Handle: al_3230_1_886451865   Media:

List of Archived Logs in backup set 3179

Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

---- ------- ---------- --------- ---------- ---------

1    4005    12030094721658 30-JUL-15 12030095358801 30-JUL-15

1    4006    12030095358801 30-JUL-15 12030095373861 30-JUL-15



版权声明：本文为博主原创文章，未经博主允许不得转载。