Oracle 10gR2 (10.2.0.5) 3-Nodes RAC to Single Dataguard Switchover
Step By Step Configuring Oracle 10gR2 (10.2.0.5) 3-Nodes RAC to Single Dataguard
DG配置参考上面链接。主库环境是3-nodes的 RAC,保证实例racdb1正常运行,关闭racdb2和racdb3实例。
备库至于mount状态。
[oracle@standby arch]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Dec 27 14:18:02 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> set line 200SQL> select dbid,name,switchover_status,db_unique_name,database_role,open_mode,current_scn from v$database; DBID NAME SWITCHOVER_STATUS DB_UNIQUE_NAME DATABASE_ROLE OPEN_MODE CURRENT_SCN---------- --------- -------------------- ------------------------------ ---------------- ---------- ----------- 800157471 RACDB SESSIONS ACTIVE standby PHYSICAL STANDBY MOUNTED 1167683SQL>
[oracle@racnode1 ~]$ srvctl relocate service -d racdb -s zwc -i racdb2 -t racdb1[oracle@racnode1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Thu Dec 27 15:36:34 2012Copyright (c) 1982, 2010, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing optionsSQL> show parameter service_nameNAME TYPE VALUE------------------------------------ ----------- ------------------------------service_names string zwcSQL> set linesize 150SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';Session altered.SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;INSTANCE_NAME HOST_NAME VERSION STARTUP_TIME STATUS ACTIVE_ST INSTANCE_ROLE DATABASE_STATUS---------------- ---------- ----------------- ------------------- ------------ --------- ------------------ -----------------racdb1 racnode1 10.2.0.5.0 2012-12-27 14:52:55 OPEN NORMAL PRIMARY_INSTANCE ACTIVEracdb3 racnode3 10.2.0.5.0 2012-12-27 15:21:09 OPEN NORMAL PRIMARY_INSTANCE ACTIVEracdb2 racnode2 10.2.0.5.0 2012-12-27 15:19:52 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
