oracle 10g rac ggs關鍵引數配置

源庫：
----mgr---
GGSCI (rac1) 8> view params mgr

PORT 7809
autostart er *
autorestart er *
PURGEOLDEXTRACTS ./dirdat, USECHECKPOINTS

--EORA--
GGSCI (rac1) 9> view params EORA

extract eora
userid ggs,password ggs
exttrail ./dirdat/aa
TRANLOGOPTIONS ASMUSER SYS@ASM, ASMPASSWORD oracle
table test.*;


-- PORA_1 --
GGSCI (rac1) 12> view params PORA_1
EXTRACT PORA_1
PASSTHRU
RMTHOST 192.168.8.219, MGRPORT 7809
RMTTRAIL ./dirdat/pa
TABLE test.*;


目標庫：
--RORA_1 --
GGSCI (yitai.com) 11> view params RORA_1
REPLICAT RORA_1
USERID ggs, PASSWORD ggs
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA_aa.DSC, PURGE
MAP test.*, TARGET test.*;


RAC1的監聽配置:
LISTENER_RAC1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.101)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER_RAC1 =
 (SID_LIST =
        (SID_DESC =
                (GLOBAL_DBNAME = ASM)
                (ORACLE_HOME = /u01/oracle/ora10g)
                (SID_NAME = +ASM1)
        )
)

RAC2的監聽配置：

LISTENER_RAC2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.102)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )


SID_LIST_LISTENER_RAC2 =
 (SID_LIST =
        (SID_DESC =
                (GLOBAL_DBNAME = ASM)
                (ORACLE_HOME = /u01/oracle/ora10g)
                (SID_NAME = +ASM2)
        )
)



RAC1 tnsname.ora:
RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
    )
  )

ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (SID_NAME = +ASM2)

    )
  )

RAC2  tnsname.ora:
RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)

    )
  )

ASM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM1)

    )
  )