Dataguard生产、容灾端备份脚本

以cc为例：

生产端

归档日志备份：

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 standby 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的归档目录满，引发故障

若有收获，就点个赞吧