oracle 10g 流复制实验-源端捕获.docx

《oracle 10g 流复制实验-源端捕获.docx》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ORACLE 10g STREAM 高级流复制技术一、实验环境操作系统：MicrosoftWindowsXP[版本5.1.2600]数据库：OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0二、实验步骤2.1主库配置：DB_NAME=SOURCE　ORACLE_SID=SOURCE2.2从库配置：DB_NAME=DEST　ORACLE_SID=DEST2.3主库监听配置：#LISTENER.ORANETWORKCONFIGURATIONFILE:D:ORACLEPRODUCT10.2.0DB_1NETWORKADMI

2、NLISTENER.ORA#GENERATEDBYORACLECONFIGURATIONTOOLS.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=OK3)(ORACLE_HOME=D:ORACLEPRODUCT10.2.0DB_1)(SID_NAME=SOURCE)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))(ADDRESS=(PROTOCOL=TCP)(HOST=PC-201006151039)

3、(PORT=1521))))2.4从库监听配置：#LISTENER.ORANETWORKCONFIGURATIONFILE:D:ORACLEPRODUCT10.2.0DB_1NETWORKADMINLISTENER.ORA#GENERATEDBYORACLECONFIGURATIONTOOLS.SID_LIST_LISTENER=(SID_LIST=　(SID_DESC=(GLOBAL_DBNAME=OK4)(ORACLE_HOME=D:ORACLEPRODUCT10.2.0DB_1)(SID_NAME=DEST)))LISTENER=(DESCRIPTIO

4、N_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))(ADDRESS=(PROTOCOL=TCP)(HOST=PC-201006151039)(PORT=1521))))2.5主库网络连接串#TNSNAMES.ORANETWORKCONFIGURATIONFILE:D:ORACLEPRODUCT10.2.0DB_1NETWORKADMINTNSNAMES.ORA#GENERATEDBYORACLECONFIGURATIONTOOLS.SOURCE=(DESCRIPTION=(ADDRESS=(PROTO

5、COL=TCP)(HOST=PC-201006151039)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OK3)))2.6从库网络连接串#TNSNAMES.ORANETWORKCONFIGURATIONFILE:D:ORACLEPRODUCT10.2.0DB_1NETWORKADMINTNSNAMES.ORA#GENERATEDBYORACLECONFIGURATIONTOOLS.DEST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PC-20100615

6、1039)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=OK4)))2.7启用追加日志 可以基于DATABASE级别或TABLE级别，启用追加日志（SUPPLEMENTALLOG）。在建立根据SCHEMA粒度进行复制的ORACLESTREAM环境中，如果确认SCHEMA下所有TABLE都有合理的主键(PRIMARYKEY)，则不再需要启用追加日志。 #启用DATABASE追加日志 ALTERDATABASEADDSUPPLEMENTALLOGDATA; #启用TABLE追加日志 ALTERTABLEADDSUP

7、PLEMENTLOGGROUPLOG_GROUP_NAME(TABLE_COLUMN_NAME)ALWAYS;2.8创建DBLINK 根据ORACLE10GR2STREAM官方文档，针对主数据库建立的数据库链的名字必须和从数据库的GLOBAL_NAME相同。 如果需要修改GLOBAL_NAME，执行ALTERDATABASERENAMEGLOBAL_NAMETOXXX ;2.9创建主库数据库链路C:>SETORACLE_SID=SOURCE;C:>SQLPLUS/ASSYSD