sitemap

RSS地图

收藏本站

设为首页

Oracle研究中心

当前位置:Oracle研究中心 > 产品DBA > Oracle DG >

详细讲解Oracle11g dataguard(LOGICAL STANDBY)配置过程案例

时间:2016-03-25 22:30   来源:Oracle研究中心   作者:惜分飞   点击:

天萃荷净

    Oracle 11g data guard(LOGICAL STANDBY)配置

  1、Create a Physical Standby Database

  11g dataguard(PHYSICAL STANDBY)配置
         
http://oracleplus.net/arch/aljjOracle_11g_dataguard_PHYSICAL_STANDBY_pz_25.html

  2、Stop Redo Apply on the Physical Standby Database

  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

  3、Prepare the Primary Database to Support a Logical Standby Database

  1)Prepare the Primary Database for Role Transitions

  *.log_archive_dest_1='LOCATION=/u01/archive valid_for=(online_logfiles,all_roles) db_unique_name=first'

  *.log_archive_dest_3='LOCATION=/u01/archive/standby VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=first'

  *.log_archive_dest_state_3='enable'

  --其他不修改

  2)Build a Dictionary in the Redo Data

  EXECUTE DBMS_LOGSTDBY.BUILD;

  4、Transition to a Logical Standby Database

  1)Convert to a Logical Standby Database

  ALTER DATABASE RECOVER TO LOGICAL STANDBY db_name;

  Note:

  (1)如果数据库是open状态,需要重启,然后置于mount状态

  (2)取消使用:RECOVER MANAGED STANDBY DATABASE CANCEL;

  (3)如果执行到一半,然后取消,导致原物理库损坏(不能同步),从主库中重新生成备库的control file,然后启动物理库同步

  2)Adjust Initialization Parameters for the Logical Standby Database

  SHUTDOWN;

  STARTUP MOUNT;

  alter system set log_archive_dest_3='LOCATION=/u01/archive/standby VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=second';

  alter system set log_archive_dest_1='LOCATION=/u01/archive valid_for=(online_logfiles,all_roles) db_unique_name=second';

  alter system set LOG_ARCHIVE_DEST_STATE_3='ENABLE';

  5、Open the Logical Standby Database

  ALTER DATABASE OPEN RESETLOGS;

  –开启实时应用

  ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

  –开启应用

  ALTER DATABASE START LOGICAL STANDBY APPLY;

  –关闭应用

  ALTER DATABASE STOP LOGICAL STANDBY APPLY;

-----------------温馨提示--------------------
操作有风险,动手需谨慎
Oracle研究中心 www.oracleplus.net
本文由大师惜分飞分享,转载请尽量保留本站网址。


--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之详细讲解Oracle11g dataguard(LOGICAL STANDBY)配置过程案例

本文由大师惜分飞原创分享,网址:http://www.oracleplus.net/arch/24.html

Oracle研究中心

关键词:

Oracle11g dataguard(LOGICAL STANDBY)配置