Oracle version:10.2.0.5

RAC Primary database

192.168.1.51            racnode1
192.168.1.151           racnode1-vip
172.168.1.51            racnode1-priv

192.168.1.52            racnode2
192.168.1.152           racnode2-vip
172.168.1.52            racnode2-priv

192.168.1.53            racnode3
192.168.1.153           racnode3-vip
172.168.1.53            racnode3-priv

Single Standby database

192.168.1.59            standby

主库是一台3nodes的10g RAC,备库准备使用单实例数据库存储使用ASM

需要在standby机器上安装oracle database software并升级至10.2.0.5,安装过程略

RAC 信息

SQL> 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
---------------- ----------- ----------------- ------------------- ------------ --------- ------------------ -----------------
racdb2		 racnode2    10.2.0.5.0        2012-12-25 16:08:08 OPEN 	NORMAL	  PRIMARY_INSTANCE   ACTIVE
racdb1		 racnode1    10.2.0.5.0        2012-12-25 16:08:07 OPEN 	NORMAL	  PRIMARY_INSTANCE   ACTIVE
racdb3		 racnode3    10.2.0.5.0        2012-12-25 16:08:08 OPEN 	NORMAL	  PRIMARY_INSTANCE   ACTIVE

SQL> select dbid,name,created,log_mode,db_unique_name from gv$database;

      DBID NAME      CREATED		 LOG_MODE     DB_UNIQUE_NAME
---------- --------- ------------------- ------------ ------------------------------
 800157471 RACDB     2012-12-20 15:58:23 ARCHIVELOG   racdb
 800157471 RACDB     2012-12-20 15:58:23 ARCHIVELOG   racdb
 800157471 RACDB     2012-12-20 15:58:23 ARCHIVELOG   racdb

SQL> select name from v$datafile;

NAME
----------------------------------------------------------------------------------------
+DATADG/racdb/datafile/system.269.802972261
+DATADG/racdb/datafile/undotbs1.256.802972267
+DATADG/racdb/datafile/sysaux.265.802972263
+DATADG/racdb/datafile/users.257.802972267
+DATADG/racdb/datafile/example.258.802972265
+DATADG/racdb/datafile/undotbs2.259.802972265
+DATADG/racdb/datafile/undotbs3.264.802972269

7 rows selected.

SQL> select name from v$controlfile;

NAME
----------------------------------------------------------------------------------------
+DATADG/racdb/controlfile/current.260.802540703
+FLASHDG/racdb/controlfile/current.256.802540705

SQL> select member from v$logfile;

MEMBER
----------------------------------------------------------------------------------------
+DATADG