RAC同单实例物理备库的switchover

文章由LinuxBoy分享于2019-03-30 02:03:32热评（211）

RAC同单实例物理备库的switchover

前面搭建好了rac同单实例数据库data guard的maa环境（见），为了方便切换操作，这里配置使用data guard broker进行操作！rac环境下，需要将data guard broker的配置文件存放到共享存储上！

一：修改data guard broker的配置文件参数，启动dmon进程

[Oracle@rac1 ~]$ sqlplus sys/123456@rac as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Jan 14 21:11:34 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show parameter dg_broker_config;

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
dg_broker_config_file1               string
+DATA/rac/dgbroker/dg_config_f
ile1.dat
dg_broker_config_file2               string
+FRA/rac/dgbroker/dg_config_fi
le2.dat

SQL> alter system set dg_broker_start=true;
System altered.

SQL> conn sys/123456@orcl as sysdba
Connected.

SQL> show parameter dg_broker_config;

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
dg_broker_config_file1               string
/u01/app/oracle/product/10.2.0
/db1/dbs/dg_config_file1.dat
dg_broker_config_file2               string
/u01/app/oracle/product/10.2.0
/db1/dbs/dg_config_file2.dat

SQL> alter system set dg_broker_start=true;
System altered.

二：使用srvctl命令修改rac数据库的启动选项，如果备库也是rac环境，同样需要相应的修改
[oracle@rac1 ~]$ srvctl modify database -d rac -s open -r primary -o $ORACLE_HOME
[oracle@rac1 ~]$ srvctl stop database -d rac -o immediate
[oracle@rac1 ~]$ srvctl start database -d rac

三：创建dg broker配置文件

[oracle@server49 ~]$ dgmgrl sys/123456@rac
DGMGRL for Linux: Version 10.2.0.5.0 - 64bit Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> create configuration maa as primary database is rac connect identifier is rac;
Configuration "maa" created with primary database "rac"

DGMGRL> add database orcl as connect identifier is orcl maintained as physical;
Database "orcl" added

DGMGRL> show configuration;

Configuration
Name:                maa
Enabled:             NO
Protection Mode:     MaxPerformance
Fast-Start Failover: DISABLED
Databases:
    rac - Primary database
    orcl - Physical standby database

Current status for "maa":
DISABLED

DGMGRL> show database verbose rac;

Database
Name:            rac
Role:            PRIMARY
Enabled:         NO
Intended State: ONLINE
Instance(s):
    rac2
    rac1

Properties:
    InitialConnectIdentifier        = 'rac'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    Dependency                      = ''
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '180'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'auto'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '5'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '+DATA/rac, /u01/app/oracle/oradata/orcl'
    LogFileNameConvert              = '+FLASH/rac, /u01/app/oracle/flash_recover_area/orcl, +DATA/rac,

/u01/app/oracle/oradata/orcl'
    FastStartFailoverTarget         = ''
    StatusReport                    = '(monitor)'
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    HostName(*)
    SidName(*)
    LocalListenerAddress(*)
    StandbyArchiveLocation(*)
    AlternateLocation(*)
    LogArchiveTrace(*)
    LogArchiveFormat(*)
    LatestLog(*)
    TopWaitEvents(*)
    (*) - Please check specific instance for the property value

Current status for "rac":
DISABLED

推荐文章：

RAC同单实例物理备库的switchover