dg oracle rac switchover回切_oracle rac+dg switchover切换 - CSDN
精华内容
参与话题
  • ORACLE RAC+DG(单实例)

    万次阅读 2019-07-02 14:55:43
    ORACLE RAC+DG(单实例) 前提条件: 1.主库RAC已经成功安装,数据库也已经创建。 2.DG备库已经安装完相同版本的oracle软件,无需创建数据库。 1、RAC开启归档。 任意节点: alter system set log_archive_format='%t_%s...

    ORACLE RAC+DG(单实例)
    前提条件:
    1.主库RAC已经成功安装,数据库也已经创建。
    2.DG备库已经安装完相同版本的oracle软件,无需创建数据库。

    1、RAC开启归档。
    任意节点:

    alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
    alter system set log_archive_dest_1='LOCATION=+DATA/arch' scope=spfile sid='*';
    srvctl stop database -d racdb -o immediate
    startup mount
    alter database archivelog;
    alter database open;
    srvctl start database -d racdb
    

    查看每个节点的归档

    alter system switch logfile;
    archive log list;
    

    每个节点的归档序号是不一样的。

    2、启用force logging功能

    select force_logging from v$database;
    alter database force logging;
    

    3、查询主库日志文件

    select thread#,group#,members,bytes/1024/1024 from v$log;
    alter database add standby logfile thread 1 group 11 size 50m;
    alter database add standby logfile thread 1 group 12 size 50m;
    alter database add standby logfile thread 1 group 13 size 50m;
    alter database add standby logfile thread 2 group 14 size 50m;
    alter database add standby logfile thread 2 group 15 size 50m;
    alter database add standby logfile thread 2 group 16 size 50m;
    

    3、配置主库的初始化参数

    alter system set db_unique_name='racdb' scope=spfile;
    alter system set log_archive_config='DG_CONFIG=(racdb,racdg)' scope=both sid='*';
    alter system set log_archive_dest_1='LOCATION=+data/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdb' scope=both sid='*';
    alter system set log_archive_dest_2='SERVICE=racdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdg' scope=both sid='*';
    alter system set log_archive_format='%t_%s_%r.arc' scope=spfile sid='*';
    alter system set log_archive_max_processes=8 scope=both sid='*';
    alter system set db_file_name_convert='/oradata/racdg/','+DATA/racdb/datafile' scope=spfile sid='*';
    alter system set log_file_name_convert='/oradata/racdg/','+DATA/racdb/onlinelog' scope=spfile sid='*';
    alter system set standby_file_management=AUTO scope=both sid='*';
    alter system set fal_server='rac_dg' scope=both sid='*';
    

    4、查询是否生效:

    set linesize 500 pages 0
    col value for a90
    col name for a50
    select name, value from v$parameter where name in ('db_name','db_unique_name','log_archive_config', 'log_archive_dest_1','log_archive_dest_2','log_archive_dest_state_1','log_archive_dest_state_2','remote_login_passwordfile','log_archive_format','log_archive_max_processes','fal_server','db_file_name_convert', 'log_file_name_convert', 'standby_file_management')
    

    5、配置本地服务名(两个节点保持一致)

    cd $ORACLE_HOME/network/admin
    vim tnsnames.ora
    
    RACDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = racdb)
        )
      )
    
    RACDB1 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.203)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = racdb)
        )
      )
    
    RACDB2 =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.204)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = racdb)
        )
      )
    
    
    RACDG =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.206)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = racdg)
        )
      )
    

    6、复制密码到DG节点
    使用oracle用户

    cd $ORACLE_HOME/dbs
    scp orapwracdb1 192.168.100.206:/$ORACLE_HOME/dbs/orapwracdg
    

    7、创建初始化文件。
    登录dg节点,使用oracle用户

    cd $ORACLE_HOME/dbs
    vim initracdg.ora
    如下:
    *.audit_file_dest='/u01/app/oracle/admin/racdg/adump'
    *.audit_trail='db'
    *.compatible='11.2.0.4.0'
    *.control_files='/oradata/racdg/control01.ctl'
    *.db_block_size=8192
    *.db_create_file_dest='/oradata/racdg'
    *.db_domain=''
    *.db_name='racdb'
    *.db_unique_name='racdg'
    *.diagnostic_dest='/u01/app/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=racdgXDB)'
    *.fal_client='racdg'
    *.fal_server='racdb'
    *.log_archive_config='DG_CONFIG=(racdb,racdg)'
    *.log_archive_dest_1='LOCATION=/oradata/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdg'
    #*.log_archive_dest_2='SERVICE=racdb LGWR ASYNC VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdb OPTIONAL PROPEN=15 MAX_FAILU
    RE=10 NET_TIMEOUT=30'
    *.log_archive_dest_2='SERVICE=racdb LGWR ASYNC VALID_FOR=(ALL_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdb'
    *.log_archive_dest_state_2='enable'
    *.log_file_name_convert='+DATA/racdb/onlinelog','/oradata/racdg'
    *.db_file_name_convert='+DATA/racdb/datafile','/oradata/racdg'
    *.log_archive_format='%t_%s_%r.dbf'
    *.log_archive_max_processes=8
    *.open_cursors=300
    *.pga_aggregate_target=536870912
    *.processes=150
    *.remote_login_passwordfile='exclusive'
    *.standby_file_management='AUTO'
    *.sga_target=2147483648
    *.undo_tablespace='UNDOTBS1'
    

    8、主库做备份。

    rman targer /
    

    执行:

    backup database format '/oradata/backup/racdb_%T_%s';
    cd /oradata/backup/
    scp racdb* 192.168.200.206:/oradata/backup/
    

    9、创建目录

    mkdir -p /u01/app/oracle/admin/racdg/adump
    mkdir -p /oradata/racdg/
    mkdir -p /oradata/arch/
    

    10、创建LISTENER

    LISTENER =
       (DESCRIPTION_LIST =
         (DESCRIPTION =
           (ADDRESS = (PROTOCOL = TCP)(HOST = racdg)(PORT = 1521)))
              (DESCRIPTION =
           (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
         )
        )
       ADR_BASE_LISTENER = /u01/app/oracle 
    

    11、启动mount

    startup mount;
    rman恢复数据库
    rman target /
    catalog start with '/oradata/backup';
    run {
    allocate channel ch00 type disk;
    allocate channel ch01 type disk;
    allocate channel ch02 type disk;
    allocate channel ch03 type disk;
    set newname for datafile 1 to '/oradata/racdg/system.dbf';
    set newname for datafile 2 to '/oradata/racdg/sysaux.dbf';
    set newname for datafile 3 to '/oradata/racdg/undotbs1.dbf';
    set newname for datafile 4 to '/oradata/racdg/users.dbf';
    set newname for datafile 5 to '/oradata/racdg/undotbs2.dbf';
    set newname for datafile 6 to '/oradata/racdg/test.dbf';
    set newname for datafile 7 to '/oradata/racdg/test01.dbf';
    restore database;
    switch datafile all;
    release channel ch00;
    release channel ch01;
    release channel ch02;
    release channel ch03;
     }
    

    12、standby开启实时同步

    alter database recover managed standby database using current logfile disconnect from session;
    停止同步:
    alter database recover managed standby database cancel;
    

    13、 主库查询进程状态(注意LNS进程)

    select process, client_process, sequence#,thread#,status from v$managed_standby;
    ![如下图](https://img-blog.csdnimg.cn/20190702144431875.jpg)
    

    14、备库查询进程状态(注意RFS进程和MRP0进程)

    select process, client_process, sequence#,thread#,status from v$managed_standby;
    ![如下图](https://img-blog.csdnimg.cn/20190702144626345.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MjIzOTE4Nw==,size_16,color_FFFFFF,t_70)
    

    15、查询日志

    select sequence#, first_time, next_time, applied from v$archived_log order by sequence#;
    

    16、主库手动切换日志

    alter system switch logfile;
    

    17、查询日志

    select sequence#, first_time, next_time, applied from v$archived_log order by sequence#;
    

    18、打开datagaurd模式

     alter database recover managed standby database cancel;
     alter database open read only;
     alter database recover managed standby database using current logfile disconnect from session;
    

    19、查看数据库模式

        主库:
        SQL>  select open_mode,database_role,switchover_status from v$database;
        
        OPEN_MODE	     DATABASE_ROLE    SWITCHOVER_STATUS
        -------------------- ---------------- --------------------
        READ WRITE	     PRIMARY	      SESSIONS ACTIVE
        备库:
        SQL> select open_mode,database_role,switchover_status from v$database;
        
        OPEN_MODE	     DATABASE_ROLE    SWITCHOVER_STATUS
        -------------------- ---------------- --------------------
        READ ONLY WITH APPLY PHYSICAL STANDBY NOT ALLOWED
    
    展开全文
  • 配置好DG后,发现其中一个节点switchover_status状态为RESOLVABLE GAP,并且日志不会传到备,同时alert日志没有报错。 select open_mode,database_role,switchover_status from gv$database; OPEN_MODE DATABASE_...

    配置好DG后,发现其中一个节点switchover_status状态为RESOLVABLE GAP,并且日志不会传到备,同时alert日志没有报错。

    select open_mode,database_role,switchover_status from gv$database;
    OPEN_MODE   DATABASE_ROLE    SWITCHOVER_STATUS
    ----------  ---------    --------------------------
    READ WRITE   PRIMARY     RESOLVABLE GAP
    READ WRITE   PRIMARY     SESSION ACTIVE

    可使用ALTER SYSTEM FLUSH REDO TO 'DDCPRD_STANDBY';将日志刷入备库。
    注意:
    1.db_unique_name要加单引号
    2.在mount状态执行
    3.如是RAC,关闭RAC所有实例,将其中一个实例启动到mount状态
    4.执行完毕后,要先关闭此实例,再启动所有实例,否则在打开此实例,再打开其它实例会报如下报错
    ORA-01183: cannot mount database in SHARED mode

    参考:http://blog.mchz.com.cn/?p=9815

    展开全文
  • 前面的文章提到,当用grid contorl中的broker页面配置的dataguard,进行switchover切换时,只需在页面中点击“切换”按钮,主备切换操作就会自动在后台完成,方便...主库:oracle11gR2 RAC rac1,rac2(racdb1,racdb2)
    
    

    前面的文章提到,当用grid contorl中的broker页面配置的dataguard,进行switchover切换时,只需在页面中点击“切换”按钮,主备切换操作就会自动在后台完成,方便快捷。但是当我们无法登录grid control页面,而又需要紧急进行切换时,这就是手工进行切换操作。

    初始环境:

    主库:oracle11gR2 RAC  rac1,rac2(racdb1,racdb2)

    备库:oracle11gR2单实例 single (racstd)

     

    1.下面就是手动switchover切换的步骤及注意的问题:

     

    假设需要在rac2实例上进行switchover操作

    --rac2上直接进行切换操作,

    --报如下错误

    SQL> alter database commit to switchover to standby;

    alter database commit to switchover to standby

    *

    1行出现错误:

    ORA-01105:装载操作与其他实例的装载操作不兼容

     

    --查询RAC环境其它活动实例

    SQL> Select Instance_Name, Host_Name    From Gv$instance

      2   Where Inst_Id <> (Select Instance_Number From V$instance);

     

    INSTANCE_NAME    HOST_NAME

    ---------------- ----------------------------------------------------------------

    racdb2           rac2.localdomain

     

    错误问题原因:

    RAC+dataguard环境手动主备切换时,主库和备库都必需只保留一个活动实例,才能完成切换操作(通过broker管理页面则不需要这步手动关闭实例操作,则在后台自动完成),所以切换前首先要关闭其它不需要切换操作的实例,切换完成后再重新启动即可。

     

    --关闭rac1实例(racdb1)

    SQL> shutdown immediate;

    数据库已经关闭。

    已经卸载数据库。

    ORACLE例程已经关闭。

     

     

    --然后再回到rac2,此时进行切换操作

    SQL> alter database commit to switchover to standby;

    alter database commit to switchover to standby

    *

    1行出现错误:

    ORA-01093: ALTER DATABASE CLOSE仅允许在没有连接会话时使用

     

    --切换为备库操作

    SQL> alter database commit to switchover to standby with session shutdown;

     

    数据库已更改。

     

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE            DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     READ WRITE           PHYSICAL STANDBY MAXIMUM PERFORMANCE

     

    --转换操作完成后,racdb2实例会自己关闭

    SQL> shutdown immediate

    ORA-01092: ORACLE instance terminated. Disconnection forced

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

    ERROR:

    ORA-03114:未连接到 ORACLE

     

    --rac2alert日志:

    Process (ospid 31592) is suspended due to switchover to physical standby operation.

    Wed Sep 05 12:17:45 2012

    Performing implicit shutdown abort due to switchover to physical standby

    Shutting down instance (abort)

     

     

    --rac2重新启动原主库实例(racdb2)

    SQL> startup

    ORACLE例程已经启动。

     

    Total System Global Area 1235959808 bytes

    Fixed Size                  2227904 bytes

    Variable Size             922747200 bytes

    Database Buffers          301989888 bytes

    Redo Buffers                8994816 bytes

    数据库装载完毕。

    数据库已经打开。

     

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE            DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     READ ONLY        PHYSICAL STANDBY MAXIMUM PERFORMANCE

     

    --single racstd实例,切换为主库操作

    SQL> alter database commit to switchover to primary with session shutdown;

    数据库已更改。

     

    --重新启动原备库

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE            DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     MOUNTED              PRIMARY          MAXIMUM PERFORMANCE

     

    SQL> shutdown immediate

    ORA-01109:数据库未打开

     

     

    已经卸载数据库。

    ORACLE例程已经关闭。

    SQL> startup mount

    ORACLE例程已经启动。

     

    Total System Global Area 1235959808 bytes

    Fixed Size                  2227904 bytes

    Variable Size             805306688 bytes

    Database Buffers          419430400 bytes

    Redo Buffers                8994816 bytes

    数据库装载完毕。

     

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE        DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     MOUNTED          PRIMARY          MAXIMUM PERFORMANCE

     

     

    SQL> alter database open;

     

    数据库已更改。

     

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE       DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     READ WRITE     PRIMARY          MAXIMUM PERFORMANCE

     

    --rac2打开实时应用查询功能

    SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

     

    数据库已更改。

     

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE            DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM PERFORMANCE

     

    SQL>

     

    --最后再启动rac1实例:

    SQL> startup

    ORACLE例程已经启动。

     

    Total System Global Area 1235959808 bytes

    Fixed Size                  2227904 bytes

    Variable Size             922747200 bytes

    Database Buffers          301989888 bytes

    Redo Buffers                8994816 bytes

    数据库装载完毕。

    数据库已经打开。

    SQL>

    SQL> select name,open_mode,DATABASE_ROLE,PROTECTION_MODE from v$database;

     

    NAME      OPEN_MODE            DATABASE_ROLE    PROTECTION_MODE

    --------- -------------------- ---------------- --------------------

    RACDB     READ ONLY WITH APPLY PHYSICAL STANDBY MAXIMUM PERFORMANCE

     

    --最后可以检查切换是否成功,可以单实例数据库端建测试表,然后在RAC数据库端查看表是否同步,不再测试

     

    2.手工切换后broker页面不再同步的问题

    当完成上面的手工switchover后,虽然切换成功,但此时grid control页面的broker页面显示状态却不正常,如下:

     

     

     

     

     

    [oracle@rac2 dbs]$ dgmgrl sys/oracle123

    DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

     

    Copyright (c) 2000, 2009, Oracle. All rights reserved.

     

    欢迎使用 DGMGRL,要获取有关信息请键入 "help"

    已连接。

    DGMGRL> show configuration

     

    配置 - racdb

     

     保护模式:        MaxPerformance

     数据库:

        racdb  -主数据库

         错误: ORA-16810: 检测到数据库的多个错误或警告

     

        racstd -物理备用数据库

         错误: ORA-16810: 检测到数据库的多个错误或警告

     

    快速启动故障转移: DISABLED

     

    配置状态:

    ERROR

     

    问题原因:

    因为开始我们的dataguard是用grid controlbroker页面进行配置和管理的,手工进行切换后,broker中信息不能和手工切换信息同步,导致dataguard状态和broker状态不一致。

     

    解决办法:

    使用broker重新配置添加dataguard信息,步骤如下:

     

    --登录dataguard环境任一服务器

    --首先删除dataguardbroker配置

    [oracle@rac1 log]$ dgmgrl sys/oracle123

    DGMGRL> help remove

     

    删除配置,数据库或实例

     

    语法:

     

      REMOVE CONFIGURATION [PRESERVE DESTINATIONS];

     

      REMOVE DATABASE <database name> [PRESERVE DESTINATIONS];

     

      REMOVE INSTANCE <instance name> [ON DATABASE <database name>];

     

    DGMGRL> remove configuration

    已移去配置

    DGMGRL> show configuration

    ORA-16532: Data Guard中介配置不存在

     

    配置详细资料不能由 DGMGRL确定

     

    --然后再登录grid controlbroker管理页面重新配置dataguard

    点击“添加备用数据库”

     

    选择“使用dataguard中介管理现有备库”

     

    选择现有备库

    查看配置

    展开

    复查配置

     

    执行配置

     

    执行完成

     

     

    跳转到broker管理页面

     

    --命令查看状态

    DGMGRL> show configuration

     

    配置 - racstd

     

     保护模式:        MaxPerformance

     数据库:

        racstd -主数据库

        racdb  -物理备用数据库

     

    快速启动故障转移: DISABLED

     

    配置状态:

    SUCCESS

     

     

     

     

     

     

    展开全文
  • oracle DG 启动和关闭顺序

    千次阅读 2018-02-26 17:35:16
    启动顺序:先启动备库,后启动主库关闭顺序:先关闭主库,后关闭备库1、正确打开备库和主库备库:SQL&gt; STARTUP MOUNT;SQL&gt;ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;...

    启动顺序:先启动备库,后启动主库

    关闭顺序:先关闭主库,后关闭备库

    1、正确打开备库和主库

    备库:

    SQL> STARTUP MOUNT;

    SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  DISCONNECT FROM SESSION;

    主库:

    SQL> STARTUP MOUNT;

    SQL> ALTER DATABASE ARCHIVELOG;

    SQL> ALTER DATABASE OPEN;


    2、正确关闭顺序

    主库

    SQL>SHUTDOWN IMMEDIATE;


    备库:

    SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

    SQL>SHUTDOWN IMMEDIATE;

    ############################################################################

    1.  主备切换

     1) 主库切换为备库

     alter database commit to switchover to physical standby;

    主库有会话连接的时候

    alter database commit to switchover to physical standby with session shutdown;

    shutdown immediate

    startup nomount

    alter database mount standby database;

    alter database recover managed standby database disconnect from session;

    2) 从库切换为主库

    alter database commit to switchover to primary;

    shutdown immediate; 

    startup

    alter system switch logfile;

    3) 从库打开只读实时应用模式

    alter database recover managed standby databasecancel; 

    alter database open;

    alter database recover managed standby database using current logfile disconnect;

    4) 检查切换状态

    select open_mode,database_role,db_unique_name from v$database;


    展开全文
  • Oracle 12C DG 搭建(RAC-RAC/RAC-单机)

    千次阅读 2017-02-07 11:28:56
    主库上操作 1.开启RAC的 force logging SQL> alter database force logging;...SQL> alter system set log_archive_config='DG_CONFIG=(eisoo,eisoos)'; SQL> alter system set log_archive_dest_2
  • 今天在做RAC-DG实验时,碰到了不少的问题,这个问题是在操作用pifle创建spifle时出现的 由于在配置RAC-DG主库参数时,大部分人喜欢直接用alter system set xxx='xxx.xxx' scope=spfile; 而我由于不想一条条敲命令,...
  • 配置dgmgrl

    千次阅读 2013-08-07 15:11:43
    一、修改dg_broker 为true SQL> show parameter dg_broker_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean FAL
  • RAC+DG切换遇到的问题

    千次阅读 2015-08-25 22:02:35
    [root@racnode1 ~]# su - oracle [oracle@racnode1 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 25 21:25:27 2015 Copyright (c) 1982, 2011, Oracle. All rights reserved.
  • Oracle RAC + Data Guard 环境搭建

    万次阅读 2017-12-01 13:54:52
      Oracle 高可用性的三个主要体现是: RAC, Data Guard 和 Stream. 所以熟练掌握这些技术就是评价DBA的标准一个。RAC + Data Guard 主要用在灾备或者报表服务器上。比如用RAC+ 逻辑standby 做报表,...
  • 因此套环境是通过oracle grid control平台配置RAC primary+Single standby,所以配置之前,首先配置好每个各自的环境,再进行下面的RAC+dataguard配置。 Oracle11g grid control和单实例Oracle11gR2 dataguard配置...
  • Oracle RAC+DG实验】Oracle RAC+ASM+DataGuard配置实验记录+常见问题 1、环境规划: ---RAC环境介绍(primary database)  rac1 rac2 ______________________________________________________ public ip
  • Migrating to RAC using Data Guard [ID 273015.1]

    千次阅读 2017-12-04 09:27:28
    Migrating to RAC using Data Guard [ID 273015.1]   Modified 16-SEP-2010 Type BULLETIN Status PUBLISHED   In this Document  Purpose  Scope and Application ...
  • DataGuard主备切换及故障切换

    千次阅读 2017-02-16 16:39:26
    DataGuard是从Oracle7.3开始引进的,在8i之前叫standby database,9i后更名为DataGuard,是Oracle提供的灾备手段之一。 1. 11g DataGuard新特性 10g的DataGuard提供了实时应用(real time apply)功能,
  • rac+单实例组建DG示例 一、初始环境: 准备已经安装完毕可以正常运行的RAC数据库,以及一台安装完ORACLE软件未创建数据库的。 RAC和单实例安装可以参考: RAC做为DG的主库。 1.我的配置如下: RAC 节点1:-IP192....
  • 前提条件:已安装Oracle DB和Oracle DG ,已经配置dg_broker 1.登录Oracle主库所在节点 2.在主库所在节点执行 su - oracle ,切换到oracle用户 3.执行dgmgrl sys/oracle@orcl122,进入dgmgrl命令行 4.执行sw...
  • Oracle 11g RAC+DG项目实战(共15集)视频

    千次阅读 2019-09-04 10:25:23
    下载地址: ...在15集视频中详细阐述了Oracle RAC的安装,RAC如何配置Active Data Guard,DG如何切换!绝对重量级的视频。掌握这个技术,资深Oracle DBA的岗位你也轻松秒杀! 实验手册在最后一集视频...
  • Oracle DG之--通过Oracle 逻辑DG 实现数据库滚动升级系统环境:操作系统:RedHat EL5OracleOracle 10gR2 对于Oracle 数据库的升级,一般需要长时间shutdown database ;升级的时间会因为数据库业务和数据库数据量...
  • 一、 如何主从的手动切换1)在主数据库上:SQL> alter database commit to switchover to physical standby;Database altered.(如果遇到ORA-01093错误,就执行alter database commit to switchove
  • RAC+单实例DG的切换

    千次阅读 2018-01-19 17:42:52
    这里讨论切换 。 之前切换不成功,和参数设置有关。...刚搭建好的环境,racdbdg是单实例的,是备库,rac节点是主库。 搭建完毕,切换了一次,刚好主库是单实例的racdbdg,rac节点是备库了。 进行后续的切换
  • DataGuard之DG Broker配置详解

    万次阅读 2017-02-17 09:57:01
    oracle dg datagurad failover swithover broker fsfo
1 2 3 4 5 ... 20
收藏数 1,068
精华内容 427
关键字:

dg oracle rac switchover回切