Goldgage管理-常用管理命令

GGSCI>info all 查看所有进程状态。

GGSCI>start er * 打开所有进程。

GGSCI>stop er *  关闭所有进程

GGSCI>info extmon_a,showch 查看进程A检查点信息，以及重启恢复需要的最早日志。

GGSCI>lag extmon_a 查看查看进程a延迟信息。

GGSCI> stats <进程名称>,<时间频度>,table <owner name>.<table name>  查看进程处理的事务明细

Ggsci> send extract <进程名> , showtrans [thread n] [count n] 查看长交易信息

Ggsci> send extract ext_a , showtrans thread 1  count  10

Ggsci>SEND EXTRACT <进程名>, SKIPTRANS <5.17.27634> THREAD <2> //跳过交易

Ggsci>SEND EXTRACT <进程名>, FORCETRANS <5.17.27634> THREAD <1> //强制认为该交易已经提交

Ggsci>SEND EXTRACT EHXZG001, FORCESTOP命令强制停止进程

GGSCI>info all 查看所有进程状态。

GGSCI>info all 查看所有进程状态。

GGSCI>info all 查看所有进程状态。

1 添加extract进程

add extract pmon_a，tranlog，begin now/extseqno,extrba,yyyy-mm-dd

add exttrail dirdat/sp,extract  repmon_a,megabytes 500(单位M)

edit params pmon_a –编写参数文件

1 添加抽取进程

add extract ext_a,tranlog ,begin 2020-08-13 13:20
add extract ext_b,tranlog ,begin 2020-08-13 13:20
add extract ext_c,tranlog ,begin 2020-08-13 13:20
add extract ext_d,tranlog ,begin 2020-08-13 13:20
add extract ext_e,tranlog ,begin 2020-08-13 13:20

alter extract ext_a ,begin 2020-08-13 13:20
alter extract ext_b ,begin 2020-08-13 13:20
alter extract ext_c ,begin 2020-08-13 13:20
alter extract ext_d ,begin 2020-08-13 13:20
alter extract ext_e ,begin 2020-08-13 13:20

add exttrail ./dirdat/ao,extract ext_a,megabytes 1000
add exttrail ./dirdat/bo,extract ext_b,megabytes 1000
add exttrail ./dirdat/co,extract ext_c,megabytes 1000
add exttrail ./dirdat/do,extract ext_d,megabytes 1000

add exttrail ./dirdat/eo,extract ext_e,megabytes 1000

添加对应的pum进程

add extract dpe_a,exttrailsource ./dirdat/ao
add rmttrail ./dirdat/ao, ext dpe_a,megabytes 1000
add extract dpe_b,exttrailsource ./dirdat/bo
add rmttrail ./dirdat/bo, ext dpe_b,megabytes 1000
add extract dpe_c,exttrailsource ./dirdat/co
add rmttrail ./dirdat/co, ext dpe_c,megabytes 1000
add extract dpe_d,exttrailsource ./dirdat/do
add rmttrail ./dirdat/do, ext dpe_d,megabytes 1000
add extract dpe_e,exttrailsource ./dirdat/eo
add rmttrail ./dirdat/eo, ext dpe_e,megabytes 1000

dblogin userid ogg ,password 123
delete ext_a
delete ext_b
delete ext_c
delete ext_d
delete ext_e
delete dpe_a
delete dpe_b
delete dpe_c
delete dpe_d
delete dpe_e

12952404469944

delete rep_a
delete rep_b
delete rep_c
delete rep_d
delete rep_e

delete rep_f
delete rep_g
delete rep_h

添加对应的复制进程

Add replicat rep_a ,exttrail ./dirdat/ao ,checkpointtable ogg.ggs_checkpoint
Add replicat rep_b ,exttrail ./dirdat/bo ,checkpointtable ogg.ggs_checkpoint
Add replicat rep_c ,exttrail ./dirdat/co ,checkpointtable ogg.ggs_checkpoint
Add replicat rep_d ,exttrail ./dirdat/do ,checkpointtable ogg.ggs_checkpoint
Add replicat rep_e ,exttrail ./dirdat/eo ,checkpointtable ogg.ggs_checkpoint

Alter replicat extseqno xxx extrba xxx;

start rep_a aftercsn 12952404469944
start rep_b aftercsn 12952404469944
start rep_c aftercsn 12952404469944
start rep_d aftercsn 12952404469944
start rep_e aftercsn 12952404469944

指定检查点

ALTER EXTRACT EXT ETROLLOVER

ALTER EXTRACT PUMP EXTSEQNO 1 EXTRBA 0

2 重新初始化

1 导出时按照scn导出，保证此时没有发生在表上的dml语句。

map source.mytab, target target.mytab, filter ( @GETENV ("TRANSACTION", "CSN") >  1176681 ) ;

3 修改检查点命令

alter extract extpmon_a,begin now

alter extract extpmon_a,begin 2013-02-14 11:56:00

alter repmon_c extseqno 1231212 extrba 0 从1231212号tail文件开始复制从哪开始。

alter repmon_c aftercsn 12122112   过滤数据从scn 12122112的事务处理