oracle dg switchover,10gDG switchover 过程

primary环境信息

IP : 192.168.152.10

ORACLE_SID=PROD

数据库版本 10.2.0.1

操作系统 Red Hat Enterprise Linux Server release 5.9 (Tikanga) 32位

standby环境信息

IP : 192.168.152.20

ORACLE_SID=OCM3

数据库版本 10.2.0.1

操作系统 Red Hat Enterprise Linux Server release 5.9 (Tikanga) 32位

第一次切换：

在primary库添加一个表空间

SYS@PROD>create tablespace part5 datafile '/u01/app/oracle/oradata/PROD/disk1/part501.dbf' size 20M;

Tablespace created.

SYS@PROD>alter system archive log current;

System altered.

主库日志：

Tue Mar 18 15:32:25 2014

Thread 1 advanced to log sequence 18

Current log# 3 seq# 18 mem# 0: /u01/app/oracle/oradata/PROD/disk1/redo03.log

Current log# 3 seq# 18 mem# 1: /u01/app/oracle/oradata/PROD/disk1/redo06.log

Tue Mar 18 15:32:29 2014

LNS: Standby redo logfile selected for thread 1 sequence 18 for destination LOG_ARCHIVE_DEST_2

Tue Mar 18 15:32:34 2014

ARCm: Standby redo logfile selected for thread 1 sequence 17 for destination LOG_ARCHIVE_DEST_2

standby database:

Tue Mar 18 15:32:34 2014

RFS[13]: Possible network disconnect with primary database

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[15]: Assigned to RFS process 2498

RFS[15]: Identified database type as 'physical standby'

Primary database is in MAXIMUM PERFORMANCE mode

Primary database is in MAXIMUM PERFORMANCE mode

RFS[15]: Successfully opened standby log 5: '/u01/app/oracle/oradata/OCM3/disk1/standbylog5a.log'

Tue Mar 18 15:32:47 2014

Fetching gap sequence in thread 1, gap sequence 17-17

Tue Mar 18 15:32:48 2014

Redo Shipping Client Connected as PUBLIC

-- Connected User is Valid

RFS[16]: Assigned to RFS process 2502

RFS[16]: Identified database type as 'physical standby'

RFS[16]: Successfully opened standby log 4: '/u01/app/oracle/oradata/OCM3/disk1/standbylog4a.log'

Tue Mar 18 15:33:18 2014

Media Recovery Log /u01/app/oracle/archlog/1_17_836758036.arc

Tue Mar 18 15:33:37 2014

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

查看主库状态

SYS@PROD>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS

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

PRIMARY          TO STANDBY

查看备库状态

SYS@OCM3>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS

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

PHYSICAL STANDBY NOT ALLOWED

将主库切换成备库

SYS@PROD>alter database commit to switchover to physical standby with session shutdown;

SYS@PROD>select status,instance_name from v$instance;

STATUS       INSTANCE_NAME

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

STARTED      PROD

SYS@PROD>shutdown immediate

SYS@PROD>startup mount

SYS@PROD>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS

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

PHYSICAL STANDBY TO PRIMARY

SYS@PROD>alter database recover managed standby database disconnect from session parallel 2;

将备库切换为主库

SYS@OCM3>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS

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

PHYSICAL STANDBY TO PRIMARY

SYS@OCM3>

SYS@OCM3>alter database commit to switchover to primary with session shutdown ;

SYS@OCM3>alter database open;

SYS@OCM3>select database_role,switchover_status from v$database;

DATABASE_ROLE    SWITCHOVER_STATUS

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

PRIMARY          TO STANDBY