DG修复:清理归档配置归档清理脚本
问题描述:DG同步断了十天,发现FRA归档盘符满了。需要清理下,重新增量恢复DG
Error 12528 received logging on to the standby FAL[client, ARC1]: Error 12528 connecting to racdb for fetching gap sequence Unable to create archive log file '+FRA' ARC4: Error 19504 Creating archive log file to '+FRA' Using STANDBY_ARCHIVE_DEST parameter default value as ?/dbs/arch Unable to create archive log file '+FRA' ARC2: Error 19504 Creating archive log file to '+FRA' ARC0: Archiving not possible: error count exceeded ARC3: Archiving not possible: error count exceeded ARC1: Archiving not possible: error count exceeded ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance racdg1 - Archival Error ORA-16038: log 9 sequence# 1326058 cannot be archived ORA-19504: failed to create file "" ORA-00312: online log 9 thread 2: '+DATA/racdg/standbylog/std_redo09.log' ARCH: Archival stopped, error occurred. Will continue retrying ORACLE Instance racdg1 - Archival Error ORA-16014: log 8 sequence# 1326059 not archived, no available destinations ORA-00312: online log 8 thread 2: '+DATA/racdg/standbylog/std_redo08.log' Archiver process freed from errors. No longer stopped Sun Jan 16 16:04:30 2022 RFS[1]: Assigned to RFS process 25642 RFS[1]: No standby redo logfiles available for thread 1 Sun Jan 16 16:05:02 2022 Decreasing number of real time LMS from 3 to 0 Sun Jan 16 16:05:05 2022 RFS[2]: Assigned to RFS process 25950 RFS[2]: No standby redo logfiles available for thread 2 Sun Jan 16 16:07:14 2022 ALTER DATABASE RECOVER managed standby database using current logfile disconnect from session
ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 5242880 1371450 0 1371450 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 1572864 0 0 0 0 N FRA/ MOUNTED EXTERN N 512 4096 4194304 6144 5696 0 5696 0 Y OCRDG/
ASMCMD> du 2021_12_03 Used_MB Mirror_used_MB 1278 1278 ASMCMD> ASMCMD> ls 2021_12_03/ 2021_12_04/ 2021_12_05/ 2021_12_06/ 2021_12_07/ 2021_12_09/ 2021_12_10/ 2021_12_11/ 2021_12_12/ 2021_12_13/ 2021_12_14/ 2021_12_15/ 2021_12_16/ 2021_12_17/ 2021_12_18/ 2021_12_19/ 2021_12_20/ 2021_12_21/ 2021_12_22/ 2021_12_23/ 2021_12_24/ 2021_12_25/ 2021_12_26/ 2021_12_27/ 2021_12_28/ 2021_12_29/ 2021_12_30/ 2021_12_31/ 2022_01_01/ 2022_01_02/ 2022_01_03/ 2022_01_04/ 2022_01_05/ ASMCMD> du 2021_12_04 Used_MB Mirror_used_MB 41926 41926 ASMCMD> ASMCMD> ASMCMD> du 2021_12_05 Used_MB Mirror_used_MB 285342 285342
ASMCMD> rm -rf 2021_12_06
ASMCMD> rm -rf 2021_12_07
ASMCMD> rm -rf 2021_12_09
ASMCMD> rm -rf 2021_12_10
重新增量恢复DG
配置归档清理脚本,每天零点执行一次脚本
vi del_arch.sh #!/bin/bash source ~/.bash_profile rman target / <<EOF crosscheck archivelog all; delete noprompt expired archivelog all; delete noprompt archivelog all completed before 'sysdate-15'; EOF echo -e "\n"
crontab -e 0 0 * * * /home/oracle/del_arc.sh