3806.主库switchover_status是failed destination
原创董小姐2025-02-21
24
问题描述
巡检发现主库状态异常，显示switchover_status是failed destination
分析过程
查下主备库状态
主库状态
set linesize 999
col open_mode for a30
select name,open_mode,database_role,protection_mode,switchover_status from v$database;
NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS
DXJ READ WRITE PRIMARY MAXIMUM PERFORMANCE FAILED DESTINATION
备库状态
set linesize 999
col open_mode for a30
select name,open_mode,database_role,protection_mode,switchover_status from v$database;
NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS
DXJ READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM PERFORMANCE NOT ALLOWED
v$database 中 switchover_Status参数含义说明
值 含义
NOT ALLOWED 当前的数据库不是带有备用数据库的主数据库
PREPARING DICTIONARY 该逻辑备用数据库正在向一个主数据库和其他备用数据库发送它的重做数据，以便为切换做准备
PREPARING SWITCHOVER 接受用于切换的重做数据时，逻辑备用配置会使用它
RECOVERY NEEDED 备用数据库还没有接收到切换请求
SESSIONS ACTIVE 在主数据库中存在活动的SQL会话；在继续执行之前必须断开这些会话
SWITCHOVER PENDING 适用于那些已收到主数据库切换请求但是还没有处理该请求的备用数据库
SWITCHOVER LATENT 切换没有完成并返回到主数据库
TO LOGICAL STANDBY 主数据库已经收到了来自逻辑备用数据库的完整的字典
TO PRIMARY 该备用数据库可以转换为主数据库
TO STANDBY 该主数据库可以转换为备用数据库
参考链接：https://blog.csdn.net/Ruishine/article/details/119955711
主备网络测试
主库网络测试
#主
sq1p1us sys/oracle@dxj as sysdba
sqlplus sys/oracle@xjd as sysdba
tnsping xjd #xjd 备库服务名
输出如下：
[oracle@dxjp:/home/oracle]$ sqlplus sys/oracle@dxj as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 21 09:28:17 2025
Copyright © 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
sys@DXJ 2025-02-21 09:28:17> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@dxjp:/home/oracle]$ sqlplus sys/oracle@jxd as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 21 09:28:27 2025
Copyright © 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12541: TNS:no listener
备库网络测试
#备
sq1p1us sys/oracle@dxj as sysdba
sqlplus sys/oracle@xjd as sysdba
tnsping xjd #xjd 主库服务名
解决办法
启动备库监听后再次查看主库状态恢复
备库启动监听
lsnrctl start
输出如下：
[oracle@dxjs:/home/oracle]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-FEB-2025 09:28:37
Copyright © 1991, 2013, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0/db/bin/tnslsnr: please wait…
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dxjs/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dxjs)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 21-FEB-2025 09:28:39
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dxjs/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dxjs)(PORT=1521)))
Services Summary…
Service “jxd” has 1 instance(s).
Instance “jxd”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
[oracle@dxjs:/home/oracle]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 21-FEB-2025 09:53:12
Copyright © 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
查看主库状态
set linesize 999
col open_mode for a30
select name,open_mode,database_role,protection_mode,switchover_status from v$database;
NAME OPEN_MODE DATABASE_ROLE PROTECTION_MODE SWITCHOVER_STATUS
DXJ READ WRITE PRIMARY MAXIMUM PERFORMANCE TO STANDBY
墨力计划
