RAC同单实例物理备库的switchover

前面搭建好了rac同单实例数据库data guard的maa环境（见 http://www.linuxidc.com/Linux/2012-01/52056.htm ），为了方便切换操作，这里配置使用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 optionsSQL> 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.datSQL> 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.datSQL> 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" addedDGMGRL> show configuration;Configuration
Name:                maa
Enabled:             NO
Protection Mode:     MaxPerformance
Fast-Start Failover: DISABLED
Databases:
    rac - Primary database
    orcl - Physical standby databaseCurrent status for "maa":
DISABLEDDGMGRL> 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 valueCurrent status for "rac":
DISABLED

使用RAC和Data Guard构建MAA架构RAC环境下的备份与恢复相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）