Oracle数据库的主从两个实验库,长时间未同步,且两个服务器节点均重启。
在从库以只读方式打开时,耗时较常,最后报错,打开失败
SQL> alter database open read only; alter database open read only * ERROR at line 1: ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due to a failed media recovery session ORA-01110: data file 1: '/oradata/SYK/system01.dbf'
从库日志一直停留在
Wed Jan 06 16:05:30 2021 alter database open read only Beginning standby crash recovery. Serial Media Recovery started Managed Standby Recovery starting Real Time Apply Media Recovery Log /oraarch/1_64_1057859074.dbf Media Recovery of Online Log [Thread=1, Seq=65] Recovery of Online Redo Log: Thread 1 Group 12 Seq 65 Reading mem 0 Mem# 0: /oradata/stby_redo12.log
主库日志重复
Fatal NI connect error 12543, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.18.5.48)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=AMY)(CID=(PROGRAM=oracle)(HOST=dbaas-dev073-10.18.5.47)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.3.0 - Production TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production Time: 06-JAN-2021 16:05:29 Tracing not turned on. Tns error struct: ns main err code: 12543 TNS-12543: TNS:destination host unreachable ns secondary err code: 12560 nt main err code: 513 TNS-00513: Destination host unreachable nt secondary err code: 113 nt OS err code: 0 Error 12543 received logging on to the standby PING[ARC2]: Heartbeat failed to connect to standby 'amy'. Error is 12543.
两台机器的防火墙未配置正确,重启后防火墙自动启动,连接被拒绝。