Ogg个人笔记20220711

ogg端口默认:7809
常用:
edit param mgr
start mgr;
view params EXT_XX;
edit params EXT_XX;
start EXTRACT XX
stop EXTRACT XX
失败的话:
kill xx
archive log list
检查是否开归档
———————————————————————————————————————————
mdd:
dirdat文件是:
进程抽取过来的文件
定期会清理
—————————————————————————————————
yuanduan:
dirprm文件是:
抽取和复制进程的复制文件
可以直接编辑也可以在ogg里面编辑
dirrpt：
ogg所有日志
—————————————————————————————————
只能在ogg家目录下执行:
ossogg/ogg_home:
—————————————————————————————————
view params XX;
—————————————————————————————————
mysql
show proesslist;
—————————————————————————————————
mysql目的端这边做之前做进程要truncate
然后把xx.rpt清掉
—————————————————————————————————
nohup ./extarct paramfile ./dirprm/ex_tmp1_zjy.prm reportfile ./dirrpt/ex_tmp1_zjy.rpt &
———————————————————————————————————————————
archive log list
查看是否开启归档
—————————————————————————————————
vi /home/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
修改:
INSTALL_OPTION=ORA11g
SOFTWARE_LOCATION=/home/ogg
执行:
./runInstaller -silent -responseFile /home/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
—————————————————————————————————
配置mgr
create subdirs
edit param mgr
#添加以下内容 
PORT 7809
--DYNAMICPORTLIST 7140-7144
--AUTORESTART EXTRACT *,RETRIES 20,WAITMINUTES 5,resetminutes 50
--PURGEOLDEXTRACTS ./dirdat/to*,usecheckpoints, minkeepdays 2
start mgr
—————————————————————————————————
源端:创建抽取进程
edit params EXT_XX
EXTRACT EXT_XX
GETTRUNCATES
GETUPDATEBEFORES
NOCOMPRESSDELETES
DBOPTIONS  ALLOWUNUSEDCOLUMN
FETCHOPTIONS NOUSESNAPSHOT
USERID ogg ,PASSWORD Ogg_1234
EXTTRAIL /ogg/install/dirdat/eg
TRANLOGOPTIONS  DBLOGREADER
CACHEMGR CACHESIZE 2G
TABLE USERXX1.TABLEXX1;
TABLE USERXX2.TABLEXX2;
--后两行是要抽取的表
执行:
add extract EXT_XX, tranlog, threads 2, begin now
add exttrail /ogg/install/dirdat/eg,extract EXT_XX
—————————————————————————————————
源端连库:开启最小化日志
（文档:表级日志）
ALTER TABLE USERXX.TABLEXX ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
—————————————————————————————————
源端开启抽取进程
dblogin userid oggg password Ogg_1234(连到数据库里再添加进程)
ADD EXTTRAIL /ogg/install/dirdat/eg,EXTRACT EXT_XX
以数据库实例做OGG抽取进程的重置抽取进程的读取检查点,非库
alter EXTTRAIL EXT_XX,begin now
start EXT_XX
view report EXT_XX(查看报错啥的)
(如果做错了需要删除掉的话,顺序:
stop EXT_XX
kill EXT_XX
delete EXTTRAIL EXT_XX)
—————————————————————————————————
OGG日志:
/ogg/install/
tail -f ggserr.log
ogg日志记录在这个log
—————————————————————————————————
配置投递进程:(投递进程直接编辑启动就ok)
edit params PUMP_XX
extract PUMP_XX
setenv (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
setenv (ORCLE_SID = "resdb")
RMTHOST 10.162.64.57,MGRPORT 7809                                            --mdd信息
RMTTRAIL /home/ogg/dirdat/to
passthru 
dynamicresolution 
USERID ogg ,PASSWORD Ogg_1234
TABLE USERXX1.TABLEXX1;
TABLE USERXX2.TABLEXX2;
add extract PUMP_XX,exttrailsource /ogg/install/dirdat/eg                    --源端路径
add rmttrail /home/ogg/dirdat/to,extract PUMP_XX                            --mdd路径
start PUMP_XX
—————————————————————————————————
目标端：
数据库create user ogg
grant dba xxx
default tablespace
ogg/Ogg_1234
——————————————————————————————————
目标端配置复制进程：
连库
ggsci
dblogin userid ogg password Ogg_1234
在全局环境中创建检查点表
add CHECKPOINTTABLE ogg.checkpointtable
edit params ./GLOBALS
加内容:
GGSCHEMA ogg
CHECKPOINTTABLE ogg.checkpointtable
:wq
add replicat rep_XX,exttrail /home/ogg/dirdat/to ,CHECKPOINTTABLE ogg.checkpointtable
edit params rep_XX
REPLICAT rep_XX
setenv (NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK")
USERID ogg ,PASSWORD Ogg_1234
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE /home/ogg/install/dirrpt/RORAaa.DSC, PURGE
MAP USERXX1.TABLEXX1, TARGET USERXX1.TABLEXX1;
MAP USERXX2.TABLEXX2, TARGET USERXX2.TABLEXX2;
—————————————
另开个窗口去sqlplus开:
select force_logging,supplemental_log_data_min from v$database;
alter system set enable_goldengate_replication=true scope=both;
alter system set enable_goldengate_replication=true;
select name,log_mode,open_mode,platform_name.force_logging,supplemental_log_data_min from v$database;
(查看是不是no)
alter system set enable_goldengate_replication=true scope=both;
alter system set enable_goldengate_replication=true;
(
archive log list
alter database add supplemental log data;(打开补充日志,最好在业务少的时候执行,如果是rac需要双节点执行(待确认))
select supplemental_log_data_min from v$database;
alter database force logging;
show parameter enble_goldengate_replication
alter system set enable_goldengate_replication=true
alter system set enable_goldengate_replication=true scope=both;
执行一次归档操作:
alter system archive log current;
select name,log_mode,open_mode,platform_name.force_logging,supplemental_log_data_min from v$database;
)
start rep_XX
view report rep_XX
—————————————
然后初始化
set num 50
select current_scn from v$database ;
CURRENT_SCN
25579222639225
nohup expdp resflow_two/resflow_two119 directory=res_productdump dumpfile=two_ogg01_%U.dmp parallel=6 logfile=two_ogg01.log cluster=n tables='GOM_BDW_INTERF_LOG_INFO' flashback_scn=25579222639225 compression=ALL &
nohup expdp resflow_two/resflow_two119 directory=res_productdump dumpfile=two_ogg02_%U.dmp parallel=6 logfile=two_ogg02.log cluster=n tables='COPY_GOM_BDW_SRV_ORD_ATTR_INFO' flashback_scn=25579222639225 compression=ALL &
再导入
修改scn号
然后重启进程
———————————————————————————————————————————
ogg装在oracle下
———————————————————————————————————————————
vi /home/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
修改:
INSTALL_OPTION=ORA11g
SOFTWARE_LOCATION=/home/ogg
执行:
./runInstaller -silent -responseFile /home/ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
create subdirs

———————————————————————————————————————————
其他:

mdd:
dirdat文件是:
进程抽取过来的文件
定期会清理

yuanduan:
dirprm文件是:
抽取和复制进程的复制文件
可以直接编辑也可以在ogg里面编辑
dirrpt：
ogg所有日志

只能在ogg家目录下执行:
ossogg/ogg_home:

view params XX;

mysql
show proesslist;