[20170810]dg broker和db_file_name_convert参数.txt
--//注:前段时间写的,例行检查发现这个问题,忘记贴出,现在补上.
--//昨天在检查中,发现一个奇怪的情况.就是设置在主库的db_file_name_convert,log_file_name_convert为NULL.
--//我检查了安装我的日志,发现我在配置dg时是设置的,为什么会消失呢?自己做一些检查,顺便做一个记录:
1.环境:
SYS@xxxxxx> select * from v$version where rownum<=1;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
SYS@xxxxxx> show parameter convert
NAME TYPE VALUE
---------------------- ------- ------------------------------------------------
db_file_name_convert string
log_file_name_convert string
--//检查alert*.log文件,发现:
Wed Jan 25 15:56:02 2017
ALTER SYSTEM SET log_file_name_convert='/u01/app/oracle/oradata/xxxxxx','/u01/app/oracle/oradata/xxxxxx' SCOPE=SPFILE;
ALTER SYSTEM SET db_file_name_convert='/u01/app/oracle/oradata/xxxxxx','/u01/app/oracle/oradata/xxxxxx' SCOPE=SPFILE;
--//确实当时配置dg时,设置了参数log_file_name_convert,db_file_name_convert.而现在为什么是空呢?
--//继续检查alert.log文件发现:
Fri Feb 03 08:32:39 2017
RSM0 started with pid=103, OS id=24082
ALTER SYSTEM SET log_archive_dest_2='service="xxxxxxdg"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="xxxxxx"
ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='xxxxxx';
ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='xxxxxx';
ALTER SYSTEM SET standby_file_management='auto' SCOPE=BOTH SID='*';
ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_max_processes=4 SCOPE=BOTH SID='*';
ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';
ALTER SYSTEM RESET db_file_name_convert SCOPE=SPFILE SID='*';
ALTER SYSTEM RESET log_file_name_convert SCOPE=SPFILE SID='*';
ALTER SYSTEM ARCHIVE LOG
--//可以2017.02.03 08:32:39.修改参数配置文件.
--//还可以发现前面启动RSM0.
$ ps -ef | grep rs[m]
oracle 24082 1 0 Feb03 ? 08:23:00 ora_rsm0_xxxxxx
SYS@xxxxxx> select * from V$BGPROCESS where name like 'RSM%';
PADDR PSERIAL# NAME DESCRIPTION ERROR
---------------- ---------- ---- -------------------------------------------------- ---------
00 0 RSMN Remote Slave Monitor 0
00000000BD7DEE80 40 RSM0 Data Guard Broker Resource Guard Process 0 0
--//才想起来我春节前安装dg(2017.01.25),当时时间太紧没有配置dg broker,而节后2017.2.3配置dg broker,而配置dg broker会修改
--//spfile参数文件,取消db_file_name_convert,log_file_name_convert的设置.
--//我估计在做切换时,这两个参数会切换回来.根据dg standby的设置.