# 定期清理归档日志
rman target /
DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7’;

# 输出日志
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=123 device type=DISK
list of archived log files
==========================
name: /arch/fgedudb/1_100_1234567890.arc
name: /arch/fgedudb/1_101_1234567890.arc
…
Deleted 10 archived log files
Deleted 10 archived log files

# 检查DataGuard状态
dgmgrl sys/password@PRIMARY
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)

# 检查重做传输状态
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 ERROR ORA-12541: TNS:no listener

# 检查备用数据库监听器状态
ssh standby_server
lsnrctl status

# 输出日志
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on Fri Apr 1 10:00:00 2026
Copyright (c) 1991, 2019, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fgedu-standby.net.cn)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

# 启动监听器
lsnrctl start

# 输出日志
LSNRCTL for Linux: Version 19.0.0.0.0 – Production on Fri Apr 1 10:05:00 2026
Copyright (c) 1991, 2019, Oracle. All rights reserved.

Starting /oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 19.0.0.0.0 – Production
System parameter file is /oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Log messages written to /oracle/diag/tnslsnr/fgedu-standby/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fgedu-standby.net.cn)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=fgedu-standby.net.cn)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 – Production
Start Date 01-APR-2026 10:05:00
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File /oracle/diag/tnslsnr/fgedu-standby/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fgedu-standby.net.cn)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “fgedudb_stby” has 1 instance(s).
Instance “fgedudb_stby”, status READY, has 1 handler(s) for this service…
The command completed successfully

# 验证重做传输状态
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

# 检查重做应用状态
sqlplus / as sysdba@STANDBY
SELECT PROCESS, STATUS, ERROR FROM v$managed_standby WHERE PROCESS=’MRP0′;

# 输出日志
PROCESS STATUS ERROR
——— ———– ——————–
MRP0 ERROR ORA-16014: log 2 sequence# 101 not archived, no available destinations
ORA-00312: online log 2 thread 1: ‘/oradata/fgedudb/redo02.log’

# 检查主数据库的归档状态
sqlplus / as sysdba
ALTER SYSTEM ARCHIVE LOG CURRENT;

# 输出日志
System altered.

# 检查备用数据库的应用状态
sqlplus / as sysdba@STANDBY
SELECT PROCESS, STATUS, ERROR FROM v$managed_standby WHERE PROCESS=’MRP0′;

# 输出日志
PROCESS STATUS ERROR
——— ———– ——————–
MRP0 APPLYING_LOG

# 检查网络连接
ping primary_server

# 输出日志
PING primary_server (192.168.1.100) 56(84) bytes of data.
From standby_server (192.168.1.200) icmp_seq=1 Destination Host Unreachable

# 检查网络配置
ifconfig

# 输出日志
eth0: flags=4163 mtu 1500
inet 192.168.1.200 netmask 255.255.255.0 broadcast 192.168.1.255
inet6 fe80::a00:27ff:fe9b:4e7a prefixlen 64 scopeid 0x20 ether 08:00:27:9b:4e:7a txqueuelen 1000 (Ethernet)
RX packets 0 bytes 0 (0.0 B)
RX errors 0 dropped 0 overruns 0 frame 0
TX packets 0 bytes 0 (0.0 B)
TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

# 检查网络服务
systemctl status network

# 输出日志
● network.service – LSB: Bring up/down networking
Loaded: loaded (/etc/rc.d/init.d/network; bad; vendor preset: disabled)
Active: inactive (dead) since Fri 2026-04-01 10:00:00 CST; 5min ago
Docs: man:systemd-sysv-generator(8)

# 启动网络服务
systemctl start network

# 输出日志
● network.service – LSB: Bring up/down networking
Loaded: loaded (/etc/rc.d/init.d/network; bad; vendor preset: disabled)
Active: active (exited) since Fri 2026-04-01 10:05:00 CST; 1s ago
Docs: man:systemd-sysv-generator(8)

# 验证网络连接
ping primary_server

# 输出日志
PING primary_server (192.168.1.100) 56(84) bytes of data.
64 bytes from primary_server (192.168.1.100): icmp_seq=1 ttl=64 time=0.5 ms
64 bytes from primary_server (192.168.1.100): icmp_seq=2 ttl=64 time=0.4 ms