Oracle11gR2 RAC

一、 准备工作 因此套环境是通过 oracle grid control 平台配置 RAC primarySingle standby ，所以配置之前，首先配置好每个各自的环境，再进行下面的 RACdataguard 配置。 Oracle11g grid control 和单实例 Oracle11gR2 dataguard 配置见文章： Oracle Grid

一、准备工作

因此套环境是通过oracle grid control平台配置RAC primary+Single standby，所以配置之前，首先配置好每个各自的环境，再进行下面的RAC+dataguard配置。

Oracle11g grid control和单实例Oracle11gR2 dataguard配置见文章：

Oracle Grid control 11g及Active DataGuard 11g安装部署（一）

Oracle Grid control 11g及Active DataGuard 11g安装部署（二）

Oracle11gR2 RAC配置见文章：

使用 VMware Server2 在 Oracle Enterprise Linux 上安装 Oracle11gR2 RAC

 

二、环境说明

RAC primary和Single standby配置

2节点RAC和1个single instance组成的data guard环境。

 

Primary database是一个两节的RAC，存储都采用ASM的方式，具体如下

RAC Primary	Inode1	Inode2
Public IP	192.168.2.101	192.168.2.102
Private IP	192.168.0.101	192.168.0.102
Virtual IP	192.168.2.111	192.168.2.112
Instance	Racdb1	racdb2
Rac-scan IP	192.168.2.201
DB_NAME	racdb
Data,Controle file,Redo file	ASM
OS版本	Oracle Enterprise Linux 5.6 64bit
oracle版本	Enterprise Edition Release 11.2.0.3.0 - 64bit

 

Standby database的数据文件也采用ASM的方式存储

Single instance standby	说明
OS版本	Oracle Enterprise Linux 5.6 64bit
oracle版本	Enterprise Edition Release 11.2.0.3.0 - 64bit
IP	192.168.2.200
Oracle	安装的非RAC版本
Instance	racstd
Data,Controle file,Redo file	+data,+fra

 

Grid control环境

Grid control host	说明
OS版本	Oracle Enterprise Linux 5.6 64bit
oracle版本	Enterprise Edition Release 11.2.0.3.0 - 64bit
Grid control版本	Enterprise Manager Grid Control 11.1.0.1.0
IP	192.168.2.100
Instance name	gcdb
Database name	gcdb
存储方式	文件系统

 

 

示例：race1 host文件内容如下：

[oracle@rac1 log]$ cat /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1       localhost.localdomain localhost

::1             localhost6.localdomain6 localhosti6

# Public

192.168.2.101   rac1.localdomain        rac1

192.168.2.102   rac2.localdomain        rac2

# Private

192.168.0.101   rac1-priv.localdomain   rac1-priv

192.168.0.102   rac2-priv.localdomain   rac2-priv

# Virtual

192.168.2.111   rac1-vip.localdomain    rac1-vip

192.168.2.112   rac2-vip.localdomain    rac2-vip

# SCAN

192.168.2.201   rac-scan.localdomain rac-scan

192.168.2.200   single.localdomain single

192.168.2.100   gc.localdomain  gc

 

 

三、安装步骤

 

Oracle grid control概览页面

 

 

安装步骤：

注：下面步骤和单实例上配置dataguard步骤基本相同

1.查看安装环境

 

 

 

 

2.点集群目标实例名称：racdb_racdb1

 

3.退回上一级目标页面：

“集群数据库：racdb”

 

4.点击Data Guard部分的“添加备用数据库”

进入下面页面

 

5.如下设置，继续到下一步

 

6.如下设置，继续到下一步

 

 

7.如下设置，继续到下一步

 

8.输入备库ASM口令，继续到下一步

 

9.如下设置，继续到下一步

 

 

10.如下设置，继续到下一步

 

 

11.复查，最后检查主备设置

 

 

 

11.点击完成后，进入处理页面，如下：

 

12.处理完成后进入下面创建页面，也可直接进入broker页面查看

 

13.点击“正在创建”，查看创建过程

 

 

 

14.创建成功后，进入dataguard broker管理页面查看dataguard状态：

 

四、Switchover切换

主库：

查看RAC当前连接实例：

SQL> SELECT INSTANCE_NUMBERFROM V$INSTANCE;

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

racdb2

 

查看RAC其它活动实例：

SQL> Select Instance_Name, Host_Name    From Gv$instance

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

 

INSTANCE_NAME    HOST_NAME

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

racdb1           rac1.localdomain

 

备库：
SQL> select name,open_mode from v$database;

 

Name           OPEN_MODE

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

Racstd            READ ONLY WITH APPLY

 

1.       在dataguard broker管理页面进行switchover主备切换

 

点击dataguard部分

安装和管理

 

点击切换，进入确认页面

 

点击是，进入执行页面

 

 

此时可以查看各实例的日志，查看切换过程：

1.       首先可以看到racdb1实例关闭，只保留一个活动的实例进行switchover切换。

racdb1实例alter日志：

Mon Sep 03 08:25:27 2012

Shutting down instance (abort)

License high water mark = 14

USER (ospid: 17603): terminating the instance

Termination issued to instance processes. Waiting for the processes to exit

Instance terminated by USER, pid = 17603

Mon Sep 03 08:25:39 2012

Instance shutdown complete

 

2.       然后可以看到racdb2实例进行备库切换，再重新启动，修改各种参数，最后打开为只读应用状态。

 

racdb2实例alter日志：

Mon Sep 03 08:32:28 2012

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY [Process Id: 30224] (racdb2)

Mon Sep 03 08:32:28 2012

Thread 2 cannot allocate new log, sequence 519

Checkpoint not complete

  Current log# 3 seq# 518 mem# 0: +DATA/racdb/onlinelog/group_3.265.765380283

  Current log# 3 seq# 518 mem# 1: +FRA/racdb/onlinelog/group_3.259.765380285

Mon Sep 03 08:32:28 2012

Stopping background process CJQ0

Mon Sep 03 08:32:37 2012

Archived Log entry 1133 added for thread 1 sequence 476 ID 0x2f1be9d9 dest 1:

ARC4: Standby redo logfile selected for thread 1 sequence 476 for destination LOG_ARCHIVE_DEST_2

Mon Sep 03 08:32:59 2012

Stopping background process MMNL

Stopping background process MMON

Mon Sep 03 08:33:09 2012

Starting background process MMON

Starting background process MMNL

Mon Sep 03 08:33:09 2012

MMON started with pid=24, OS id=28385

Mon Sep 03 08:33:10 2012

MMNL started with pid=25, OS id=28389

Stopping background process QMNC

All dispatchers and shared servers shutdown

CLOSE: killing server sessions.

Active process 16387 user 'oracle' program 'oracle@rac2.localdomain'

……

Active process 16452 user 'oracle' program 'oracle@rac2.localdomain'

minact-scn: Inst 2 is now the master inc#:8 mmon proc-id:28385 status:0x6

minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.0165378f gcalc-scn:0x0000.016537a2

minact-scn: master continuing after IR

CLOSE: all sessions shutdown successfully.

Waiting for all non-current ORLs to be archived...

Waiting for the ORL for thread 1 sequence 477 to be archived...

Mon Sep 03 08:33:40 2012

idle dispatcher 'D000' terminated, pid = (33, 5)

Mon Sep 03 08:33:40 2012

ARC1: Archiving disabled thread 1 sequence 477

Archived Log entry 1135 added for thread 1 sequence 477 ID 0x2f1be9d9 dest 1:

Mon Sep 03 08:33:42 2012

ORL for thread 1 sequence 477 has been archived...

All non-current ORLs have been archived.

Waiting for all FAL entries to be archived...

All FAL entries have been archived.

Waiting for dest_id 2 to become synchronized...

Active, synchronized Physical Standby switchover target has been identified

Switchover End-Of-Redo Log thread 2 sequence 518 has been fixed

Switchover: Primary highest seen SCN set to 0x0.0x165d682

ARCH: Noswitch archival of thread 2, sequence 518

ARCH: End-Of-Redo Branch archival of thread 2 sequence 518

ARCH: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2

ARCH: Standby redo logfile selected for thread 2 sequence 518 for destination LOG_ARCHIVE_DEST_2

Archived Log entry 1137 added for thread 2 sequence 518 ID 0x2f1be9d9 dest 1:

ARCH: Archiving is disabled due to current logfile archival

Primary will check for some target standby to have received alls redo

Final check for a synchronized target standby. Check will be made once.

LOG_ARCHIVE_DEST_2 is a potential Physical Standby switchover target

Active, synchronized target has been identified

Target has also received all redo

Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/racdb/racdb2/trace/racdb2_rsm0_30224.trc

Clearing standby activation ID 790358489 (0x2f1be9d9)

The primary database controlfile was created using the

'MAXLOGFILES 192' clause.

There is space for up to 188 standby redo logfiles

Use the following SQL commands on the standby database to create

standby redo logfiles that match the primary database:

ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 52428800;

ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 52428800;

Archivelog for thread 2 sequence 518 required for standby recovery

Switchover: Primary controlfile converted to standby controlfile succesfully.

Switchover: Complete - Database shutdown required

Completed: ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN

Mon Sep 03 08:34:04 2012

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

Mon Sep 03 08:34:04 2012

Shutting down instance (abort)

License high water mark = 21

USER (ospid: 28646): terminating the instance

Instance terminated by USER, pid = 28646

Mon Sep 03 08:34:16 2012

Instance shutdown complete

Mon Sep 03 08:34:30 2012

Starting ORACLE instance (normal)

Mon Sep 03 08:35:19 2012

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Private Interface 'eth1:1' configured from GPnP for use as a private interconnect.

  [name='eth1:1', type=1, ip=169.254.93.205, mac=00-0c-29-19-8d-45, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interconnect/62]

Public Interface 'eth0' configured from GPnP for use as a public interface.

  [name='eth0', type=1, ip=192.168.2.102, mac=00-0c-29-19-8d-3b, net=192.168.2.0/24, mask=255.255.255.0, use=public/1]

Public Interface 'eth0:1' configured from GPnP for use as a public interface.

  [name='eth0:1', type=1, ip=192.168.2.112, mac=00-0c-29-19-8d-3b, net=192.168.2.0/24, mask=255.255.255.0, use=public/1]

Public Interface 'eth0:2' configured from GPnP for use as a public interface.

  [name='eth0:2', type=1, ip=192.168.2.201, mac=00-0c-29-19-8d-3b, net=192.168.2.0/24, mask=255.255.255.0, use=public/1]

Picked latch-free SCN scheme 3

Mon Sep 03 08:35:29 2012

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

ARCH: Warning; less destinations available than specified

by LOG_ARCHIVE_MIN_SUCCEED_DEST init.ora parameter

Autotune of undo retention is turned on.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, OLAP, Data Mining

and Real Application Testing options.

ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1

System name:    Linux

Node name:      rac2.localdomain

Release:        2.6.32-100.26.2.el5

Version:        #1 SMP Tue Jan 18 20:11:49 EST 2011

Machine:        x86_64

VM name:        VMWare Version: 6

Using parameter settings in server-side pfile /u01/app/oracle/product/11.2.0/db_1/dbs/initracdb2.ora

System parameters with non-default values:

  processes                = 150

  spfile                   = "+DATA/racdb/spfileracdb.ora"

  memory_target            = 1184M

  control_files            = "+DATA/racdb/controlfile/current.260.765379719"

  control_files            = "+FRA/racdb/controlfile/current.256.765379719"

  db_block_size            = 8192

  compatible               = "11.2.0.0.0"

  log_archive_dest_1       = ""

  log_archive_dest_2       = "service="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=single.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=racstd)(SERVER=DEDICATED)))""

  log_archive_dest_2       = "LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="racstd" net_timeout=30"

  log_archive_dest_2       = "valid_for=(all_logfiles,primary_role)"

  log_archive_dest_3       = ""

  log_archive_dest_state_2 = "ENABLE"

  log_archive_dest_state_3 = "ENABLE"

  log_archive_min_succeed_dest= 1

  fal_server               = "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=single.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=racstd)(SERVER=DEDICATED)))"

  log_archive_trace        = 0

  log_archive_config       = "dg_config=(racdb,racstd)"

  log_archive_format       = "%t_%s_%r.dbf"

  log_archive_max_processes= 5

  archive_lag_target       = 0

  cluster_database         = TRUE

  db_create_file_dest      = "+DATA"

  db_recovery_file_dest    = "+FRA"

  db_recovery_file_dest_size= 15G

  standby_file_management  = "AUTO"

  thread                   = 2

  undo_tablespace          = "UNDOTBS2"

  instance_number          = 2

  remote_login_passwordfile= "EXCLUSIVE"

  db_domain                = ""

  dispatchers              = "(PROTOCOL=TCP) (SERVICE=racdbXDB)"

  remote_listener          = "rac-scan:1521"

  audit_file_dest          = "/u01/app/oracle/admin/racdb/adump"

  audit_trail              = "DB"

  db_name                  = "racdb"

  open_cursors             = 300

  dg_broker_start          = TRUE

  dg_broker_config_file1   = "+DATA/dr1racdb.dat"

  dg_broker_config_file2   = "+DATA/dr2racdb.dat"

  diagnostic_dest          = "/u01/app/oracle"

Cluster communication is configured to use the following interface(s) for this instance

  169.254.93.205

cluster interconnect IPC version:Oracle UDP/IP (generic)

IPC Vendor 1 proto 2

Mon Sep 03 08:35:36 2012

PMON started with pid=2, OS id=29579

--各种进程启动

.......

MMON started with pid=24, OS id=29677

Mon Sep 03 08:35:47 2012

MMNL started with pid=25, OS id=29683

Mon Sep 03 08:35:47 2012

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

NOTE: initiating MARK startup

starting up 1 shared server(s) ...

Starting background process MARK

Mon Sep 03 08:35:47 2012

MARK started with pid=27, OS id=29693

NOTE: MARK has subscribed

lmon registered with NM - instance number 2 (internal mem no 1)

Reconfiguration started (old inc 0, new inc 2)

List of instances:

 2 (myinst: 2)

 Global Resource Directory frozen

* allocate domain 0, invalid = TRUE

 Communication channels reestablished

 Master broadcasted resource hash value bitmaps

 Non-local Process blocks cleaned out

 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived

 Set master node info

 Submitted all remote-enqueue requests

 Dwn-cvts replayed, VALBLKs dubious

 All grantable enqueues granted

 Post SMON to start 1st pass IR

 Submitted all GCS remote-cache requests

 Post SMON to start 1st pass IR

 Fix write in gcs resources

Reconfiguration complete

Mon Sep 03 08:35:51 2012

LCK0 started with pid=31, OS id=29713

Starting background process RSMN

Mon Sep 03 08:35:53 2012

RSMN started with pid=32, OS id=29721

ORACLE_BASE from environment = /u01/app/oracle

Mon Sep 03 08:35:55 2012

DMON started with pid=30, OS id=29727

Mon Sep 03 08:35:56 2012

ALTER DATABASE   MOUNT

This instance was first to mount

Mon Sep 03 08:36:00 2012

NOTE: Loaded library: System

Mon Sep 03 08:36:00 2012

SUCCESS: diskgroup DATA was mounted

Mon Sep 03 08:36:00 2012

ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.112)(PORT=1521))))' SCOPE=MEMORY SID='racdb2';

SUCCESS: diskgroup FRA was mounted

Mon Sep 03 08:36:03 2012

NOTE: dependency between database racdb and diskgroup resource ora.DATA.dg is established

NOTE: dependency between database racdb and diskgroup resource ora.FRA.dg is established

Mon Sep 03 08:36:09 2012

ARCH: STARTING ARCH PROCESSES

Mon Sep 03 08:36:09 2012

ARC0 started with pid=35, OS id=29791

ARC0: Archival started

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no SRL' ARCH

ARC0: Thread not mounted

ARCH: STARTING ARCH PROCESSES COMPLETE

Mon Sep 03 08:36:11 2012

Successful mount of redo thread 2, with mount id 790629740

Physical Standby Database mounted.

Lost write protection disabled

Completed: ALTER DATABASE  MOUNT

Mon Sep 03 08:36:15 2012

ALTER DATABASE OPEN

Data Guard Broker initializing...

Data Guard Broker initialization complete

Mon Sep 03 08:36:18 2012

Starting Data Guard Broker (DMON)

AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access

This instance was first to open

Mon Sep 03 08:36:19 2012

INSV started with pid=39, OS id=29836

Beginning standby crash recovery.

Serial Media Recovery started

Mon Sep 03 08:36:22 2012

Managed Standby Recovery starting Real Time Apply

Mon Sep 03 08:36:25 2012

NSV1 started with pid=36, OS id=29852

Mon Sep 03 08:36:26 2012

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_1_seq_476.286.793009945

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_2_seq_516.304.792986419

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_2_seq_517.303.793009875

Mon Sep 03 08:37:10 2012

RSM0 started with pid=42, OS id=30038

Mon Sep 03 08:37:11 2012

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_2_seq_518.279.793010027

Identified End-Of-Redo (switchover) for thread 2 sequence 518 at SCN 0x0.165d682

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_1_seq_477.322.793010021

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Sep 03 08:37:15 2012

ARC0: STARTING ARCH PROCESSES

ALTER SYSTEM SET log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST','valid_for=(ALL_LOGFILES, ALL_ROLES)' SCOPE=BOTH;

ALTER SYSTEM SET log_archive_trace=0 SCOPE=BOTH SID='racdb2';

ALTER SYSTEM SET log_archive_format='%t_%s_%r.dbf' SCOPE=SPFILE SID='racdb2';

ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH SID='*';

ALTER SYSTEM SET archive_lag_target=0 SCOPE=BOTH SID='*';

ALTER SYSTEM SET log_archive_max_processes=5 SCOPE=BOTH SID='*';

Mon Sep 03 08:37:16 2012

ARC1 started with pid=43, OS id=30069

ALTER SYSTEM SET log_archive_min_succeed_dest=1 SCOPE=BOTH SID='*';

ALTER SYSTEM SET fal_server='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=single.localdomain)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=racstd)(SERVER=DEDICATED)))' SCOPE=BOTH;

Data Guard: Redo Apply Services will be started after instance open completes

Resetting standby activation ID 0 (0x0)

Incomplete Recovery applied until change 23451266 time 09/03/2012 08:33:45

Completed standby crash recovery.

Mon Sep 03 08:37:18 2012

ARC2 started with pid=44, OS id=30077

Picked Lamport scheme to generate SCNs

Mon Sep 03 08:37:18 2012

SMON: enabling cache recovery

ARC1: Becoming the heartbeat ARCH

ARC1: Becoming the active heartbeat ARCH

ARC1: Becoming the active heartbeat ARCH

Mon Sep 03 08:37:20 2012

ARC3 started with pid=45, OS id=30085

ARC2: Becoming the heartbeat ARCH

ARC1: Archival started

Mon Sep 03 08:37:23 2012

ARC4 started with pid=46, OS id=30105

ARC2: Archival started

ARC3: Archival started

Mon Sep 03 08:37:24 2012

Primary database is in MAXIMUM PERFORMANCE mode

ARC4: Archival started

ARC0: STARTING ARCH PROCESSES COMPLETE

RFS[1]: Assigned to RFS process 30092

RFS[1]: Selected log 5 for thread 1 sequence 482 dbid 762996486 branch 765379723

Mon Sep 03 08:37:28 2012

Dictionary check beginning

Mon Sep 03 08:37:29 2012

RFS[2]: Assigned to RFS process 30123

RFS[2]: Selected log 6 for thread 1 sequence 481 dbid 762996486 branch 765379723

Dictionary check complete

Database Characterset is ZHS16GBK

No Resource Manager plan active

Mon Sep 03 08:37:32 2012

RFS[3]: Assigned to RFS process 30126

RFS[3]: Opened log for thread 2 sequence 519 dbid 762996486 branch 765379723

RFS[2]: Opened log for thread 1 sequence 478 dbid 762996486 branch 765379723

Archived Log entry 1139 added for thread 1 sequence 478 rlc 765379723 ID 0x2f1bc82c dest 2:

RFS[2]: Opened log for thread 2 sequence 520 dbid 762996486 branch 765379723

Mon Sep 03 08:37:33 2012

Archived Log entry 1140 added for thread 1 sequence 481 ID 0x2f1bc82c dest 1:

Archived Log entry 1141 added for thread 2 sequence 519 rlc 765379723 ID 0x0 dest 2:

Archived Log entry 1142 added for thread 2 sequence 520 rlc 765379723 ID 0x0 dest 2:

RFS[3]: Opened log for thread 2 sequence 521 dbid 762996486 branch 765379723

Archived Log entry 1143 added for thread 2 sequence 521 rlc 765379723 ID 0x0 dest 2:

RFS[2]: Opened log for thread 1 sequence 479 dbid 762996486 branch 765379723

Archived Log entry 1144 added for thread 1 sequence 479 rlc 765379723 ID 0x2f1bc82c dest 2:

RFS[3]: Opened log for thread 1 sequence 480 dbid 762996486 branch 765379723

Archived Log entry 1145 added for thread 1 sequence 480 rlc 765379723 ID 0x2f1bc82c dest 2:

Starting background process GTX0

Mon Sep 03 08:37:37 2012

GTX0 started with pid=50, OS id=30160

replication_dependency_tracking turned off (no async multimaster replication found)

Mon Sep 03 08:37:41 2012

Physical standby database opened for read only access.

Completed: ALTER DATABASE OPEN

Mon Sep 03 08:38:06 2012

Data Guard: Database open completed; restarting redo-apply ...

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE

Attempt to start background Managed Standby Recovery process (racdb2)

Mon Sep 03 08:38:07 2012

MRP0 started with pid=54, OS id=30220

MRP0: Background Managed Standby Recovery process started (racdb2)

 started logmerger process

Mon Sep 03 08:38:15 2012

Managed Standby Recovery starting Real Time Apply

Parallel Media Recovery started with 2 slaves

Waiting for all non-current ORLs to be archived...

All non-current ORLs have been archived.

Clearing online redo logfile 1 +DATA/racdb/onlinelog/group_1.261.765379725

Mon Sep 03 08:38:18 2012

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  USING CURRENT LOGFILE

Mon Sep 03 08:38:18 2012

Clearing online log 1 of thread 1 sequence number 482

Mon Sep 03 08:38:20 2012

Clearing online redo logfile 1 complete

Clearing online redo logfile 2 +DATA/racdb/onlinelog/group_2.262.765379727

Clearing online log 2 of thread 1 sequence number 481

Clearing online redo logfile 2 complete

Clearing online redo logfile 3 +DATA/racdb/onlinelog/group_3.265.765380283

Clearing online log 3 of thread 2 sequence number 518

Mon Sep 03 08:38:29 2012

Clearing online redo logfile 3 complete

Clearing online redo logfile 4 +DATA/racdb/onlinelog/group_4.266.765380287

Clearing online log 4 of thread 2 sequence number 517

Clearing online redo logfile 4 complete

Mon Sep 03 08:38:31 2012

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_2_seq_519.301.793010251

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_2_seq_520.296.793010253

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_1_seq_478.318.793010253

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_2_seq_521.324.793010255

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_1_seq_479.297.793010255

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_1_seq_480.310.793010255

Media Recovery Log +FRA/racdb/archivelog/2012_09_03/thread_1_seq_481.302.793010253

Mon Sep 03 08:38:41 2012

Media Recovery Waiting for thread 1 sequence 482 (in transit)

Recovery of Online Redo Log: Thread 1 Group 5 Seq 482 Reading mem 0

  Mem# 0: +DATA/racdb/onlinelog/group_5.269.791953157

  Mem# 1: +FRA/racdb/onlinelog/group_5.287.791953159

 

3.       racstd备库switchover切换成主库。

Racstd库alter日志

Mon Sep 03 09:09:27 2012

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

MRP0: Background Media Recovery cancelled with status 16037

Errors in file /u01/app/oracle/diag/rdbms/racstd/racstd/trace/racstd_pr00_1049.trc:

ORA-16037: user requested cancel of managed recovery operation

Managed Standby Recovery not using Real Time Apply

Recovery interrupted!

Mon Sep 03 09:09:27 2012

MRP0: Background Media Recovery process shutdown (racstd)

Managed Standby Recovery Canceled (racstd)

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

Forcing database into limbo

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY WAIT WITH SESSION SHUTDOWN

ALTER DATABASE SWITCHOVER TO PRIMARY (racstd)

Maximum wait for role transition is 15 minutes.

krsv_proc_kill: Killing 3 processes (all RFS)

CLOSE: killing server sessions.

Active process 22285 user 'oracle' program 'oracle@single.localdomain'

Active process 22285 user 'oracle' program 'oracle@single.localdomain

 

4.       然后实例racdb1启动到mount状态，修改各种参数，也成为备用实例。

 

SQL> select instance_name,status from v$instance;

 

INSTANCE_NAME    STATUS

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

racdb1           MOUNTED

 

--打开实例

SQL> select instance_name,status from v$instance;

 

INSTANCE_NAME    STATUS

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

racdb1           OPEN

 

SQL> select open_mode from v$database;

 

OPEN_MODE

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

READ ONLY WITH APPLY

 

 

5.       最后再检查各数据库状态

 

--rac数据库状态

[oracle@rac1 dbs]$ sqlplus "/as sysdba"

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

 

 

--single数据库状态

[oracle@single~]$ sqlplus "/as sysdba"

 

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

 

 

6       switchover操作后的页面

 

 

这样，切换后的角色为：

主库：racstd（host:single）

备库：racdb（实例名racdb1,racdb2;hosts:rac1,rac2）

 

7.       再尝试switchover切回原来主备角色

--此时不需要停止集群备库的任何实例，然后就可以直接进行switchover切换

--同样点“切换”按钮，登录后服务器后进入执行切换页面

 

即同样的方法，点击“切换”后一键完成主库切换。

 

总结：

使用grid control页面的datagurd broker管理进行主备切换，只需要点击“切换”按钮即可完成rac+datagurd的所有主备切换操作，无需再去手关闭rac实例到只有一个活动实例才能完成切换操作，所以操作都会后台自动完成，方便快捷。