源端
OS:Red Hat Enterprise Linux Server release 5.5 (Tikanga)
ORACLE:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
shareplex目录:/oradata/shareplex
目的端:
OS:Red Hat Enterprise Linux Server release 5.8 (Tikanga)
ORACLE:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
shareplex目录:/data/shareplex
shareplex软件:SharePlex-7.6.1-b27-oracle100-rh-40-amd64-m64.tar
解压后:SharePlex-7.6.1-b27-oracle100-rh-40-amd64-m64.tpm
1)创建SPLEX用户及设置归档模式
A 、源端与目标端--创建用户及授权(注意系统时间):
create user splex identified by splex default tablespace users;----最好为SPLEX用户单独创建一个表空间
grant dba,connect,resource to splex;---SPLEX必须有DBA权限
源端必须处于归档模式
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Next log sequence to archive 9
Current log sequence 9
alter database add supplemental log data (primary key,unique index) columns;
目标端创建需同步进去的数据(注意在目标端创建好源端默认表空间及数据表空间)
create user test identified by test default tablespace TBS_DATA01;
grant connect,resource,unlimited tablespace to test;
2) 安装shareplex
源端
$ ./SharePlex-7.6.1-b27-oracle100-rh-40-amd64-m64.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
.......................................................