rac dg节点2在修改完alert_oracle_sid.log文件名,主库切换日志后备库节点2不产生新的日志文件

问题描述:rac dg节点2在修改完alert_oracle_sid.log文件名,主库切换日志后备库节点2不产生新的日志文件.
主库:主机名hisdb1&hisdb2 + oracle 11.2.0.4 rac
备库:主机名hisdb3&hisdb4 + oracle 11.2.0.4 rac dg
1、问题重现
--备库节点2修改日志文件名.
[oracle@hisdb4 trace]$ ll |grep alert
-rw-r----- 1 oracle asmadmin 47473 Nov 28 13:39 alert_heacom.cn/tag/ld" target="_blank">ldg2.log
[oracle@hisdb4 trace]$ mv alert_healdg2.log alert_healdg2.log20221128
--主库节点1切换日志.
SQL> alter system switch logfile;

System altered.
--备库节点2查看alert文件
[oracle@hisdb4 trace]$ ll |grep alert
-rw-r----- 1 oracle asmadmin 47473 Nov 28 13:39 alert_healdg2.log20221128
[oracle@hisdb4 trace]$ mv alert_healdg2.log20221128 alert_healdg2.log

说明:可以看到备库节点2并未产生新的日志文件.
--在来验证备库节点1的情况.
[oracle@hisdb3 trace]$ ll |grep alert
-rw-r----- 1 oracle oinstall 184984 Nov 28 13:50 alert_healdg1.log
[oracle@hisdb3 trace]$ mv alert_healdg1.log alert_healdg1.log20221128
--主库节点1切换日志.
[oracle@hisdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 28 21:59:23 2022

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> alter system switch logfile;

System altered.
--备库节点1确认日志文件.
[oracle@hisdb3 trace]$ ll |grep alert
-rw-r----- 1 oracle asmadmin 472 Nov 28 21:58 alert_healdg1.log
-rw-r----- 1 oracle oinstall 184984 Nov 28 13:50 alert_healdg1.log20221128

说明:可以看到备库节点1在主库切换日志后,有新的日志文件产生.
2、mrp进程
值得注意的是mrp进程,查备库节点2该进程情况.
[oracle@hisdb4 trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 28 21:50:45 2022

Copyright (c) 1982, 2013, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select process,status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED

说明:在备库节点2上并未找到mrp进程.
--查备库节点1该进程情况.
SQL> select process,status from v$managed_standby

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
ARCH CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
MRP0 APPLYING_LOG

11 rows selected.

说明:在备库节点1上可以看到该进程.
--查数据库状态.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

说明:虽然mrp进程只在备库节点1存在,但两个rac备库状态均在实时应用状态中.
3、验证转移mrp
经确认,当备库为rac环境时,mrp进程只能在一个节点上运行.测试环境中该进程在备库节点1上,所以该节点会产生新的日志文件.验证若将该进程转移到备库节点2,确认该节点是否会产生新的日志文件.
--备库节点1停止实时应用.
SQL> alter database recover managed standby database cancel;

Database altered.

SQL> select process,status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CONNECTED
ARCH CLOSING
ARCH CLOSING
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE

10 rows selected.
--备库节点2开启实时应用.
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> select process,status from v$managed_standby;

PROCESS STATUS
--------- ------------
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
ARCH CONNECTED
MRP0 APPLYING_LOG
--备库节点2修改日志文件名.
[oracle@hisdb4 trace]$ ll |grep alert
-rw-r----- 1 oracle asmadmin 50012 Nov 28 22:03 alert_healdg2.log
[oracle@hisdb4 trace]$ mv alert_healdg2.log alert_healdg2.log20221128
--主库节点1切换日志.
SQL> alter system switch logfile;

System altered.
--备库节点2查看alert文件
[oracle@hisdb4 trace]$ ll |grep alert
-rw-r----- 1 oracle asmadmin 265 Nov 28 22:04 alert_healdg2.log
-rw-r----- 1 oracle asmadmin 50012 Nov 28 22:03 alert_healdg2.log20221128

结论:如上所示,当mrp进程转移到备库节点2时,该节点会产生新的日志文件.