Every Day of a DBA，第155期: 备库归档磁盘耗尽 DG 异常恢复记录

DGMGRL> show configuration

Configuration - ycjj2dg

  Protection Mode: MaxPerformance
  Databases:
    ycjj      - Primary database
      Error: ORA-16778: redo transport error for one or more databases

    ycjj2dg - Physical standby database
      Warning: ORA-16857: standby disconnected from redo source for longer than specified threshold

  Fast-Start Failover: DISABLED

Configuration Status:
ERROR

DGMGRL>

# 查看备库归档路径
sqlplus / as sysdba
show parameter log_archive_dest;
show parameter db_recovery_file_dest;

RMAN> crosscheck archivelog all;
# 删除7天前已应用归档
RMAN> delete noprompt archivelog until time 'sysdate-7' applied on standby;

df -h  # 校验归档所在文件系统使用率 <90%

-- 主库sqlplus
select sysdate fromdual@ycjj2dg;

-- 备库sqlplus
select sysdate fromdual@ycjj;

DGMGRL> connect sys/主库sys密码@ycjj
DGMGRL> edit database ycjj set property LogXptStatus=reset;
DGMGRL> edit database ycjj2dg set property StatusReport=reset;
DGMGRL> show configuration

-- 主库执行
altersystemset log_archive_dest_state_2 = defer;
altersystem switch logfile;
altersystemset log_archive_dest_state_2 =enable;
altersystem switch logfile;

DGMGRL> show configuration

select dest_id,status,error from v$archive_dest where dest_id=2;

-- 查看备库已接收归档
select sequence#,applied from v$archived_log order by sequence# desc;
-- 查看MRP恢复进程是否运行
select process,statusfrom v$managed_standby;

crosscheck archivelog all;
delete noprompt archivelog all completed before 'sysdate-5' applied on standby;

altersystemset log_archive_dest_2='service=ycjj2dg ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ycjj2dg REOPEN=30';