Oracle ADG切换检查及操作

一、配置检查

1、数据库名称及log_archive_config检查

使用命令

show parameter name;

show parameter log_archive_config;

查看点

1. 查看数据库db_unique_name、db_name、service_names 设置
2. 查看log_archive_config是否配置了正确的生产及容灾db_unique_name

确认点

生产show parameter name;输出如下：

一般db_unique_name、db_name、service_names 三者一致:

SQL> show parameter name; NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ cell_offloadgroup_name               string db_file_name_convert                 string      /oradata/DATAFILE/, +DATA/CBSD                                                  B/DATAFILE/, /oradata/TEMPFILE                                                  /, +DATA/CBSDB/TEMPFILE/ db_name                              string      cbsdb db_unique_name                       string      cbsdb global_names                         boolean     FALSE instance_name                        string      cbsdb1 lock_name_space                      string log_file_name_convert                string      /oradata/LOGFILE/, +DATA/CBSDB                                                  /ONLINELOG/ pdb_file_name_convert                string processor_group_name                 string service_names                        string      cbsdb

SQL> show parameter log_archive_config; NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ log_archive_config                   string      dg_config=(cbsdb, dr_cbsdb)

容灾侧：

根据命名规则，一般容灾侧db_unique_name为 dr_dbname,同时，为保障服务名称的一致性，在service_names中，应存在一个与生产一致的servername，即下文的CBSDB

SQL> show parameter name; NAME                                 TYPE                             VALUE ------------------------------------ -------------------------------- ------------------------------ cell_offloadgroup_name               string db_file_name_convert                 string                           +DATA/CBSDB/DATAFILE/, /oradat                                                                       a/DATAFILE/, +DATA/CBSDB/TEMPF                                                                       ILE/, /oradata/TEMPFILE/ db_name                              string                           cbsdb db_unique_name                       string                           dr_cbsdb global_names                         boolean                          FALSE instance_name                        string                           cbsdb1 lock_name_space                      string log_file_name_convert                string                           +DATA/CBSDB/ONLINELOG/, /orada                                                                       ta/LOGFILE/ pdb_file_name_convert                string processor_group_name                 string service_names                        string                           DR_CBSDB, CBSDB

SQL> show parameter log_archive_config; NAME                                 TYPE                             VALUE ------------------------------------ -------------------------------- ------------------------------ log_archive_config                   string                           dg_config=(cbsdb,dr_cbsdb)

2、查看log_archive_dest_2 、 log_archive_dest_state_2配置

使用命令

show parameter log_archive_dest_2;

show parameter log_archive_dest_state_2;

如有必要，对1 3也进行检查；

查看点

查看log_archive_dest_2 中的service、db_unique_name、log_archive_dest_state_2配置

确认点

（1）service应为到对端的tns、db_unique_name是否为对端的db_unique_name，如不是，需要修改。

（2）确认log_archive_dest_state_2处于enable状态

示例如下：

生产侧：

SQL> show parameter log_archive_dest_2; NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2                   string      service="DR_CBSDB", LGWR ASYNC                                                   AFFIRM delay=0 optional compr                                                  ession=disable max_failure=0 m                                                  ax_connections=1 reopen=300 db                                                  _unique_name="dr_cbsdb" net_ti                                                  meout=30, valid_for=(all_logfi                                                  les,primary_role) service="DR_CBSDB" 是TNS中配置到容灾的TNS，db _unique_name="dr_cbsdb"是配置的容灾的db_unique_name SQL>  show parameter log_archive_dest_state_2 NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_state_2             string      ENABLE VALUE处于ENABLE状态。

容灾侧：

SQL> show parameter log_archive_dest_2; NAME                                 TYPE                             VALUE ------------------------------------ -------------------------------- ------------------------------ log_archive_dest_2                   string                           service="PR_CBSDB", LGWR ASYNC                                                                        AFFIRM delay=0 optional compr                                                                       ession=disable max_failure=0 m                                                                       ax_connections=1 reopen=300 db                                                                       _unique_name="cbsdb" net_timeo                                                                       ut=30, valid_for=(all_logfiles                                                                       ,primary_role) service="PR_CBSDB" 是TNS中配置到生产的TNS，db _unique_name="cbsdb"是配置的生产db_unique_name。 SQL> show parameter log_archive_dest_state_2 NAME                                 TYPE                             VALUE ------------------------------------ -------------------------------- ------------------------------ log_archive_dest_state_2             string                           enable VALUE处于enable或者ENABLE状态。

使用TNSPING命令对上述两个TNS进行PING，查看是否通。

3、查看fal_server参数

使用命令：