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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11590946/viewspace-1124217/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11590946/viewspace-1124217/