Preparing the target database for GoldenGate setup
1° 需要一个数据库用户用于目标库的部署操作(源库也是需要的)
考虑到灾备切换,ggs用户应该均授予源库和目标库所需要的所有权限:
sqlplus / as sysdba
create tablespace GGS datafile '...' size 50m
autoextend on next 64m maxsize 30G
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER ggs identified by ggs DEFAULT TABLESPACE GGS;
ALTER USER ggs QUOTA UNLIMITED ON GGS;
GRANT CREATE SESSION, ALTER SESSION to ggs;
GRANT CONNECT, RESOURCE to ggs;
GRANT SELECT ANY DICTIONARY to ggs;
GRANT SELECT ANY TABLE TO ggs;
GRANT INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE TO ggs;
GRANT CREATE TABLE TO ggs;
2° 为了遵循权限最小化原则,SELECT ANY TABLE、UPDATE ANY TABLE
DELETE ANY TABLE 和 INSERT ANY TABLE 可以使用以下SQL拼出的授权语句代替:
select 'GRANT SELECT, INSERT, UPDATE, DELETE ON '||
owner||'.'||table_name||' to GGATE_ADMIN;' COMMAND
from dba_tables where owner='SCOTT';
3° Checkpoint表的必要性:
需要创建Checkpoint表,该表记录应用进程的状态,用于故障恢复
同时可以使应用进程使用NOWAIT进行异步提交,提升了性能
不使用Checkpoint表,应用进程使用文件记录状态,使用WAIT进行同步提交
[TOC]