日期:2014-05-16  浏览次数:20471 次

逻辑DG之Standby角色转换

Primary:
1.检查当前Primary数据库的初始化参数:
SQL> show parameter fal

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
fal_client                           string      orcl_192.168.1.222
fal_server                           string      orcls_192.168.1.223
SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------

log_archive_dest_1                   string      location=/u01/arch_orcl

log_archive_dest_2                   string      service=orcls_192.168.1.223 lg
                                                 wr async valid_for=(online_log
                                                 files, primary_role) db_unique
                                                 _name=orclldg
2.修改log_archive_dest_1
SQL> alter system set log_archive_dest_1='location=/u01/arch_orcl valid_for=(online_logfiles,all_roles) db_unique_name=orclpre';

System altered.
Standby:
1.检查当前Standby数据库的初始化参数:
SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string      location=/u01/arch_ldg valid_f
                                                 or=(online_logfiles,all_roles)
              &nbs