# 监控重做传输状态
sqlplus / as sysdba
SELECT DEST_ID, DEST_NAME, STATUS, ERROR FROM v$archive_dest WHERE DEST_ID=2;

# 输出日志
DEST_ID DEST_NAME STATUS ERROR
——- ——————– ——— ——————–
2 LOG_ARCHIVE_DEST_2 VALID

# 监控重做应用状态
SELECT PROCESS, STATUS, CLIENT_PROCESS, SEQUENCE# FROM v$managed_standby;

# 输出日志
PROCESS STATUS CLIENT_PROCESS SEQUENCE#
——— ———– ————— ———-
ARCH CONNECTED ARCH 100
ARCH CONNECTED ARCH 100
ARCH CONNECTED ARCH 100
ARCH CONNECTED ARCH 100
RFS IDLE LGWR 101
RFS IDLE ARCH 100
MRP0 APPLYING_LOG N/A 101

# 监控应用延迟
SELECT NAME, VALUE FROM v$dataguard_stats WHERE NAME=’apply lag’;

# 输出日志
NAME VALUE
———- ———-
apply lag +00 00:00:00

# 使用DGMGRL监控DataGuard状态
dgmgrl sys/password@PRIMARY

# 输出日志
DGMGRL for Linux: Release 19.0.0.0.0 – Production on Fri Apr 1 10:00:00 2026
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type “help” for information.
Connected to “fgedudb”
Connected as SYSDBA.

# 查看配置状态
SHOW CONFIGURATION;

# 输出日志
Configuration – fgedudb_dg
Protection Mode: MaxAvailability
Members:
fgedudb – Primary database
fgedudb_stby – Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS (status updated 32 seconds ago)

# 查看数据库状态
SHOW DATABASE ‘fgedudb’;

# 输出日志
Database – fgedudb
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
fgedudb

Database Status:
SUCCESS

# 查看备用数据库状态
SHOW DATABASE ‘fgedudb_stby’;

# 输出日志
Database – fgedudb_stby
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Instance(s):
fgedudb_stby

Database Status:
SUCCESS

# 使用Enterprise Manager监控DataGuard
# 1. 登录Enterprise Manager
# 2. 导航到DataGuard管理页面
# 3. 查看DataGuard状态摘要
# 4. 查看详细的监控指标
# 5. 配置告警阈值
# 6. 查看历史性能数据

# 创建DataGuard监控脚本
cat > /oracle/scripts/dataguard_monitor.sh << 'EOF' #!/bin/bash # dataguard_monitor.sh # from:www.itpux.com.qq113257174.wx:itpux-com # web: http://www.fgedu.net.cn # 设置环境变量 export ORACLE_HOME=/oracle/product/19.3.0/dbhome_1 export ORACLE_SID=fgedudb export PATH=$ORACLE_HOME/bin:$PATH # 监控时间 DATE=$(date +"%Y-%m-%d %H:%M:%S") # 输出监控结果 echo "DataGuard监控报告 - $DATE" echo "==================================" # 检查主数据库状态 echo "\n1. 主数据库状态:" sqlplus -s / as sysdba << SQL SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM v$instance; SELECT DATABASE_ROLE, PROTECTION_MODE FROM v$database; SQL # 检查重做传输状态 echo "\n2. 重做传输状态:" sqlplus -s / as sysdba << SQL SELECT DEST_ID, DEST_NAME, STATUS, ERROR FROM v$archive_dest WHERE DEST_ID=2; SQL # 检查备用数据库状态 echo "\n3. 备用数据库状态:" sqlplus -s sys/password@fgedudb_stby << SQL SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM v$instance; SELECT DATABASE_ROLE, PROTECTION_MODE FROM v$database; SELECT PROCESS, STATUS, CLIENT_PROCESS, SEQUENCE# FROM v$managed_standby; SELECT NAME, VALUE FROM v$dataguard_stats WHERE NAME='apply lag'; SQL echo "\n==================================" echo "监控完成" EOF
# 赋予执行权限
chmod +x /oracle/scripts/dataguard_monitor.sh

# 执行监控脚本
/oracle/scripts/dataguard_monitor.sh

# 输出日志
DataGuard监控报告 – 2026-04-01 10:00:00
==================================

1. 主数据库状态:
INSTANCE_NAME STATUS DATABASE_STATUS
—————- ———— —————–
fgedudb OPEN ACTIVE

DATABASE_ROLE PROTECTION_MODE
—————- ——————–
PRIMARY MAXIMUM AVAILABILITY

2. 重做传输状态:
DEST_ID DEST_NAME STATUS ERROR
——- ——————– ——— ——————–
2 LOG_ARCHIVE_DEST_2 VALID

3. 备用数据库状态:
INSTANCE_NAME STATUS DATABASE_STATUS
—————- ———— —————–
fgedudb_stby MOUNTED ACTIVE

DATABASE_ROLE PROTECTION_MODE
—————- ——————–
PHYSICAL STANDBY MAXIMUM AVAILABILITY

PROCESS STATUS CLIENT_PROCESS SEQUENCE#
——— ———– ————— ———-
ARCH CONNECTED ARCH 100
ARCH CONNECTED ARCH 100
ARCH CONNECTED ARCH 100
ARCH CONNECTED ARCH 100
RFS IDLE LGWR 101
RFS IDLE ARCH 100
MRP0 APPLYING_LOG N/A 101

NAME VALUE
———- ———-
apply lag +00 00:00:00

==================================
监控完成