RMAN> @oraarchyzz.sh
-- 內容範例:
RUN {
ALLOCATE CHANNEL t1 TYPE DISK;
BACKUP ARCHIVELOG ALL DELETE INPUT FORMAT '/backup/arch_%s_%p';
RELEASE CHANNEL t1;
}
RUN {
ALLOCATE CHANNEL t1 TYPE 'SBT_TAPE'
PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
CONNECT 'backup/bk1949coal@PROD1';
ALLOCATE CHANNEL t2 TYPE 'SBT_TAPE'
PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
CONNECT 'backup/bk1949coal@PROD2';
BACKUP FILESPERSET 10
(ARCHIVELOG ALL SKIP INACCESSIBLE DELETE INPUT FORMAT '/arch_%s_%p/');
RELEASE CHANNEL t1; RELEASE CHANNEL t2;
}
手工腳本每次從「最近歸檔」開始,若前次備份中斷導致早期歸檔未備份,後續執行**不會自動補齊**。
-- 1. 檢查目錄與實際備份一致性
CROSSCHECK ARCHIVELOG ALL;
CROSSCHECK BACKUPSET;
-- 2. 列出備份詳情
LIST BACKUP OF ARCHIVELOG ALL;
LIST BACKUP OF ARCHIVELOG FROM SEQUENCE 8116 THREAD 2;
-- 3. 刪除過期/不可用備份記錄
DELETE EXPIRED ARCHIVELOG ALL;
DELETE OBSOLETE;
-- 4. 補備漏掉的歸檔(指定序列範圍)
BACKUP ARCHIVELOG FROM SEQUENCE 100 UNTIL SEQUENCE 200 THREAD 1;
CONFIGURE ARCHIVELOG BACKUP COPIES + BACKUP ARCHIVELOG ALL),避免手工遺漏。CROSSCHECK 同步目錄與實體媒體狀態。CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY 確保 Data Guard 環境下歸檔不被過早刪除。V$ARCHIVE_DEST_STATUS、V$RECOVERY_FILE_DEST 空間使用率。