生产端
归档日志备份：
cat /rmancc/shell/rmanlog.sh
#! /bin/sh
export ORACLE_SID=cc
rman target / <<EOF
run{
allocate channel dev1 type disk;
sql 'alter system archive log current' ;
backup format '/rmancc/cc/%d_log_%T_%U' archivelog until time 'sysdate' delete all input ;
backup current controlfile format '/rmancc/cc/ctl_%d_%T_%s_%u';
delete noprompt obsolete;
release channel dev1;
}
quit;
EOF
全备：
cat /rmancc/shell/rmanfull.sh
#! /bin/sh
export ORACLE_SID=cc
rman target / <<EOF
run{
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
allocate channel dev4 type disk;
backup incremental level 0 format '/rmancc/cc/Oracle_%d_full_%T_%s_%u' database INCLUDE CURRENT CONTROLFILE;
sql 'alter system archive log current' ;
backup format '/rmancc/cc/%d_log_%T_%U' archivelog until time 'sysdate' delete all input ;
backup current controlfile format '/rmancc/cc/ctl_%d_%T_%s_%u';
delete noprompt obsolete;
release channel dev1;
release channel dev2;
release channel dev3;
release channel dev4;
}
quit;
EOF
容灾端
归档日志清理脚本：
cat /rmancc/shell/rmanlog_clear.sh
#!/bin/sh
export ORACLE_SID=cc
rman target / <<EOF
run{
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate';
}
quit;
EOF
注意： （1）当dr的mrp过程没有开始，但数据库起着作用（tnsname通），pr的归档会由pr的lns正常传输到dr，此时dr未应用程序的归档脚本不能删除，报错如下：
RMAN>
CROSSCHECK ARCHIVELOG ALL;
FILE
USING TARGET DATABASE CONTROL
OF
RECOVERY CATALOG
INSTEAD
ALLOCATED CHANNEL: ORA DISK 1
CHANNEL ORA DISK 1: SID-6845 DE
5 DEVICE TYPE-DISK
VALIDATION SUCCEEDED FOR ARCHIVED LOG
ARCHIVED 109 FILE NAME:/ARCH/ZMP/CC_L_122833_1055097907.ARC RECID-194491 STAMP-1108466477
VALIDATION SUCCEEDED FOR ARCHIVED LOG
STAMP1108466437
ARCHIVED LOG FILE NAME-/ARCH/ZMP/CC 2 50766 1055097907.ARC RECID-194489
VALIDATION SUCCEEDED FOR ARCHIVED LOG
ARCHIVED LOG FILE NAME:/ARCH/ZMP/CC 2 50767 1055097907.ARC RECID-194490 STAMP-1108466475
CROSSCHECKED 3 OBJECTS
DR归档删除日志
RMAN> DELETE NOPROMPT ARCHIVELOG ALL;
RELEASED CHANNEL: ORA DISK 1
ALLOCATED CHANNEL: ORA DISK 1
CHANNEL ORA DISK 1: SID-6845 DEVICE
TYPEDISK
RNAN-O8137: WARNING: ARCHIVED LOG NOT DELETED, NEEDEDED FOR STANDBY OR UPSTREAM CAPTURE PROCESS
1 122833 1055097907.ARC THREAD-1 SEQUENCE-122833
ARCHIVED LOG FILE NAME-/ARCH/ZMP/CC_I
RMAN-08137: WARNING: ARCHIVED LED
ED LOG NOT DELETED, NEEDED FOR STANDBY OR UPSTREAM CAPTURE PROCESS
ARCHIVED LOG FILE NANE-/ARCH/ZMP/CC_2 50766_1055097907.ARC THREAD-2 SEQUENCE-50766
RMAN-08137: WARNING: ARCHIVED LOG NOT DELETED, NEEDED FOR STANDBY OR UPSTREAM CAPTURE PROCESS
ARCHIVED LOG
FILE NAME-/ARCH/ZMP/CC_2 50767 1055097907.ARC THREAD-2 SEQUENCE-50767
RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process 所以dr归档目录很容易满，一旦dr归档目录满了，会导致归档目录满了pr无法继续传输归档，导致归档无法继续传输，导致归档无法继续传输归档pr端的归档不能正常删除，删除时也会报告RMAN-08137: warning: archived log not deleted, needed for stndby or upstream capture process，最后导致pr归档满，引发故障；
CHANNEL ORA DISK
STARTING PIECE 1 AT 27-JUN-22
PR备份归档日志
; FINISHED PIECE 1 AT 27-JUN-22
ORA DISK
CHANNEL
DIECE HANDLEE/BACKUP/RMANZMPLOG/ZHP LOA 20220627 NO113MUN 1 1 1 TAA:TAG20220627T112407 COMNENT-NOND
ORA DISK 1: BACKUP SET COMPLETE, ELAPSED TIME: 00:00:15
CHANNEL
RA DISK_1: DELETING ARCHIVED LOG(S)
CHANNEL ORA
SG FILE NAME三+ZMPDBARCH/ZMP/1 122826 1055097907.DBF RECID-278643 STAMP-1108463827
ARCHIVED LOG I
FILE NA
E NAME三+ZMPDBARCH/ZMP/2 50762 1055097907.AB于 RECID-278645 STAMP-1108464485
ARCHIVED LOG
NAME三+ZMPDBARCH/ZMP/1 122827 1055097907.DBF RECID-278647 STAMP-1108464512
ARCHIVED LOG FILE
FILE NAME二+ZMPDBARCH/ZMP/2 50763_1055097907 DBF RECID-278652 STAMP-1108465512
ARCHIVED LOG
FILE NAME-+ZMPDBARCH/ZMP/1 122828 1055097907.DBF RECID-278649 STAMP-1108465491
ARCHIVED LOG
ARCHIVED LOG FILE NAMEZ>ZMPDBARCH/ZMP/1_122829 1055097997997.DBF RECID-278653 STAMP-1108465514
D LOG
FILE NAME二+ZMPDBARCH/ZMP/1_122830_1055097907.DBF RECID-278657 STAMP-1108465686
ARCHIVED
NAME-+ZMPDBARCH/ZMP/2 50764 1055097907.DBF RECID-278656 STAMP-1108465685
ARCHIVED LOG FILE
FILE NAME-+ZMPDBARCH/ZMP/1_122831 1055097907 DBF RECID-278659 STAMP-1108466365
ARCHIVED LOG
FILE NAME三+ZMPDBARCH/ZMP/2-50765 1055097907.DBF RECID-278663 STAMP-1108466410
ARCHIVED LOG
ARCHIVED LOG FILE NAME>>ZMPDBARCH/ZMP/122832 1055097997997997.DBF RECID-278660 STAMP-1108466377
FILE NAME二+ZMPDBARCH/ZMP/1 122833 1055097907.DBF RECID-278669 STAMP-1108466477
10G
ARCHIVED
ARCHIVED LOG FILE
NAME三+ZMPDBARCH/ZMP/2 50766 1055097907.ABF RECID-278664 STAMP-1108466437
LE NAME三+7MPDBARCH/ZMO/2 50767 1055097997.DBF RECTD-778667 STAMP-1108466474
ARCHIVED LOD FILE NA
RMAN-08137: WARNING:ARCHI
ID: ARCHIVED LOG NOT DELETED, NEEDED FOR STANABY OR UPSTREAM AN AND
AM CAPTURE PROCESS
ARCHIVED LOG
FILE NAME三+ZMPDBARGH/ZMP/2 50768 1055097907.DB于 THREAD三Z SEQUENCE三50768
LOG FILE
ARCHIVED
NAME三+ZHFDBARGH/ZMP/L-122834-1055097907.DBF RECID-278671 STAMP-110846645
FINISHED BACKUP AT 27-JUN-22
（2）如果dr的监听异常，pr无法传输归档到dr，pr无法正常备份删除归档，导致pr的归档目录满，引发故障
若有收获，就点个赞吧