记录一次ogg重建过程

参考 http://www.xuexibar.cn/bcsc/sjk/101273153.shtml

利用 commit SCN/CSN 方式来保证 初始化数据与生产数据的一致性

首先重建配置参数
在源端
检查约束,发现没有主键的表

SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE FROM USER_CONSTAINTS WHERE TABLE_NAME IN ('KCS_BUSINESS_AGENTS','KCS_BUSINESS_INFOR','KCS_FLOW','KCS_ORG_INFO','KCS_PARA','KCS_TELLER_INFO','KCS_TRANS_BUSI','KBK_LEDGER','KBK_LEDGER_DAYBOOK','KBK_LEDGER_FLOW','KCS_ERRFLOW','KSS_CHKFLOW','KBK_LEDGER_CHANNEL','KCS_PARA_POWER');

添加主键后 执行添加表

add trandata ESSEAPP.KCS_PARA
add trandata ESSEAPP.KSS_CHKFLOW
add trandata ESSEAPP.KCS_PARA_POWER

重新检查表

info trandata ESSEAPP.KCS_BUSINESS_AGENTS;
info trandata ESSEAPP.KCS_BUSINESS_INFOR;
info trandata ESSEAPP.KCS_FLOW;
info trandata ESSEAPP.KCS_ORG_INFO;
info trandata ESSEAPP.KCS_PARA;
info trandata ESSEAPP.KCS_TELLER_INFO;
info trandata ESSEAPP.KCS_TRANS_BUSI;
info trandata ESSEAPP.KBK_LEDGER;
info trandata ESSEAPP.KBK_LEDGER_DAYBOOK;
info trandata ESSEAPP.KBK_LEDGER_FLOW;
info trandata ESSEAPP.KCS_ERRFLOW;
info trandata ESSEAPP.kss_chkflow;
info trandata ESSEAPP.kbk_ledger_channel;
info trandata ESSEAPP.KCS_PARA_POWER;

删除抽取进程文件夹后,

delete extract extesse
delete exttrail /home/ogg/dirdat/es
delete extract dpesse
delete rmttrail /home/ogg/dirdat/es
dblogin userid ggtarget, password ggtarget
delete replicat repesse

重新添加文件夹,并启动抽取进程

ggsci> add extract extesse, tranlog, begin now, threads 2  
ggsci> add exttrail /home/ogg/dirdat/es, extract extesse, megabytes 50
ggsci> start extesse

ggsci> add extract dpesse, exttrailsource /home/ogg/dirdat/es
ggsci> add rmttrail /home/ogg/dirdat/es, extract dpesse, megabytes 50
ggsci> start dpesse
ggsci> add replicat repesse exttrail /home/ogg/dirdat/es

运行一段时间后,找出 当前最新的scn号,并从这个scn好开始导出

select dbms_flashback.get_system_change_number from dual;

目标库参数修正

drop table ESSEAPP.KCS_BUSINESS_AGENTS;
drop table ESSEAPP.KCS_BUSINESS_INFOR;
drop table ESSEAPP.KCS_FLOW;
drop table ESSEAPP.KCS_ORG_INFO;
drop table ESSEAPP.KCS_PARA;
drop table ESSEAPP.KCS_TELLER_INFO;
drop table ESSEAPP.KCS_TRANS_BUSI;
drop table ESSEAPP.KBK_LEDGER;
drop table ESSEAPP.KBK_LEDGER_DAYBOOK;
drop table ESSEAPP.KBK_LEDGER_FLOW;
drop table ESSEAPP.KCS_ERRFLOW;
drop table ESSEAPP.kss_chkflow;
drop table ESSEAPP.kcs_exceptionflow;
drop table ESSEAPP.kbk_ledger_snap;
drop table ESSEAPP.kbk_ledger_channel;
drop table ESSEAPP.KCS_PARA_POWER;
drop table ESSEAPP.AB;

检查表空间

select upper(f.tablespace_name) "表空间名",
       d.tot_grootte_mb "表空间大小(G)",
       d.tot_grootte_mb - f.total_bytes "已使用空间(G)",
       to_char(round((d.tot_grootte_mb - f.total_bytes) / d.tot_grootte_mb * 100, 2), '990.99') "使用比",
       f.total_bytes "空闲空间(G)",
       f.max_bytes "最大块(G)"
  from (select tablespace_name,
               round(sum(bytes) / (1024 * 1024 * 1024), 2) total_bytes,
               round(max(bytes) / (1024 * 1024 * 1024), 2) max_bytes 　
               　from sys.dba_free_space group by tablespace_name) f,
       (select dd.tablespace_name, round(sum(dd.bytes) / (1024 * 1024 * 1024), 2) tot_grootte_mb
          from sys.dba_data_files dd
         group by dd.tablespace_name) d
 where d.tablespace_name = f.tablespace_name
 order by 4 desc;

添加复制进程

add replicat repesse exttrail /home/ogg/dirdat/es

远程导出

ifconfig -a
more /etc/hosts
cd /home/backup
mkdir esse140227
cd esse140227/
export NLS_LANG=american_america.ZHS16GBK
vi esseexp140227.par
more esseexp140227.par 
tnsping bmzdb2
nohup /usr/bin/time -p exp ESSEAPP/ESSEAPP@bmzdb2 parfile=esseexp140227.par >/home/backup/esse140227/exp140227.log &

esseexp140227.par 中的内容

file=esse140227.dmp
log=exp_esse140227.log
tables=KCS_BUSINESS_AGENTS,KCS_BUSINESS_INFOR,KCS_FLOW,KCS_ORG_INFO,KCS_PARA,KCS_TELLER_INFO,KCS_TRANS_BUSI,KBK_LEDGER,KBK_LEDGER_DAYBOOK,KBK_LEDGER_FLOW,KCS_ERRFLOW,kss_chkflow,kbk_ledger_channel,KCS_PARA_POWER
direct=true
recordlength=65535
flashback_scn=1805474649

导入

export NLS_LANG=american_america.ZHS16GBK
vi esseimp140227.par
nohup /usr/bin/time -p imp ESSEAPP/esseapp parfile=esseimp140227.par >/home/backup/esse140227/esseimp140227.log &

esseimp140227.par 中内容

file=esse140227.dmp
log=imp_esse140227.log
tables=KCS_BUSINESS_AGENTS,KCS_BUSINESS_INFOR,KCS_FLOW,KCS_ORG_INFO,KCS_PARA,KCS_TELLER_INFO,KCS_TRANS_BUSI,KBK_LEDGER,KBK_LEDGER_DAYBOOK,KBK_LEDGER_FLOW,KCS_ERRFLOW,kss_chkflow,kbk_ledger_channel,KCS_PARA_POWER
feedback=1000000

源端起动复制进程

ggsci> start repesse, aftercsn 1805474649;