alter database open;
1.3 配置日志模式(打开强制规档与补充日志模式)
alter database add supplemental log data;
alter database force logging;
1.4 查看配置结果:
select log_mode,supplemental_log_data_min,force_logging from v$database;
1.5
千万不要小看这步日志设置,其实在 GoldenGate 的配置中,这步是最容易出错的环节。如果开启 DDL 复制
做冗灾备份,最好直接在数据库级别打开补全日志:
SQL> alter database add supplemental log data (primary key,unique,foreign key)
columns;
检查一下,全是 YES 就 OK 了(整个数据库级别补全)
SQL> select
supplemental_log_data_min,supplemental_log_data_pk,supplemental_log_data_ui from
v$database;
1.6 切换归档日志:
alter system switch logfile;
1.7 源库关闭回收站
show parameter recyclebin
alter system set recyclebin=off scope=spfile;
shutdown immediate;
startup;
show parameter recyclebin
1.8 UNDO 设置
alter system set undo_retention=86400;
1.9 参数设置
SQL> alter system set enable_goldengate_replication=true scope=both;
2、创建 goldengate 用户并且授权
create tablespace ggs datafile '+DATA' size 500M autoextend off;
or
create tablespace ggs datafile '/u01/app/oracle/oradata/ogg01.dbf' size 512M;
创建数据库 goldengate 用户并授权
create user ggs identified by ggs default tablespace ggs;
GRANT CONNECT TO ggs;
GRANT ALTER ANY TABLE TO ggs;
GRANT ALTER SESSION TO ggs;
GRANT CREATE SESSION TO ggs;
GRANT FLASHBACK ANY TABLE TO ggs;
GRANT SELECT ANY DICTIONARY TO ggs;
GRANT SELECT ANY TABLE TO ggs;
GRANT RESOURCE TO ggs;
GRANT INSERT ANY TABLE TO ggs;
GRANT UPDATE ANY TABLE TO ggs;
评论