只在rac1 ,rac3 下安装ogg作者: 王硕 时间: 2015-12-9 16:56
第一部分:
1.在源端创建专用的表空间、schema、并授权。
create tablespace goldengate datafile '+DATA/goldengate01.dbf' size 100m autoextend on;
create user goldengate identified by goldengate default tablespace goldengate temporary tablespace temp;
grant connect to goldengate;
grant alter any table to goldengate;
grant alter session to goldengate;
grant create session to goldengate;
grant flashback any table to goldengate;
grant select any dictionary to goldengate;
grant select any table to goldengate;
grant resource to goldengate;
grant select any transaction to goldengate;作者: 王硕 时间: 2015-12-9 16:59
2.关闭RAC库(两个节点),开启归档
检查源端数据库是否在归档模式,强烈建议在归档模式。
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /arch
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3作者: 王硕 时间: 2015-12-9 17:10
3、
源端:
添加附加日志来唯一标识一行记录,要在数据库级别打开最小开关。为了减少整个数据库添加附加日志,以及减少归档量,
goldengate建议复制哪些对象,就添加哪些表的附加日志(我们到时候是拿hr用户下的表来实验)。
检查:
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
NO
打开:
SQL> alter database add supplemental log data;
Database altered.
再次查看:
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
YES
切换日志组,使附加日志开关生效。
SQL> alter system switch logfile;
System altered.
解释:
在正常情况下,oracle是用rowid来唯一标示一行记录的,但goldengate这里不够,需要打开附加日志。
15、
测试goldengate能否抓取数据:
SQL> update employees set salary=salary+1000;
107 rows updated.
SQL> commit;
Commit complete.
查看是否生成文件:
[oracle@rac1 ogg]$ ll dirdat
total 16
-rw-rw-rw- 1 oracle oinstall 13721 Dec 12 03:47 r1000000
查看目标端是否也生成:
[oracle@rac2 ogg]$ ls -l dirdat
total 16
-rw-rw-rw- 1 oracle oinstall 13743 Dec 12 03:47 t1000000
注意:
是可以的,大小是非0。
16、
目标端:
创建golengate软件使用的schema,并授权一些必要的特殊权限,注意与源端有所区别,保证我们能DML。
create tablespace goldengate datafile '/u01/app/oracle/oradata/ogg/goldengate01.dbf' size 100m autoextend on;
create user goldengate identified by goldengate default tablespace goldengate temporary tablespace temp;
grant connect to goldengate;
grant alter any table to goldengate;
grant alter session to goldengate;
grant create session to goldengate;
grant flashback any table to goldengate;
grant select any dictionary to goldengate;
grant select any table to goldengate;
grant resource to goldengate;
grant insert any table to goldengate;
grant update any table to goldengate;
grant delete any table to goldengate;
grant create any index to goldengate;
grant select any transaction to goldengate;