ogg配置例子
add114.t_name_sequence
=============
MAP add114.bst_workpaper, TARGET add114.bst_workpaper;
======================
expdp userid=system/oracle
expdp userid=system/oracle add114_ogg.par
directory=expdp_dir
tables=(add114.t_name_sequence )
filesize=10G
dumpfile=add114_ogg_%U.dmp
logfile=add114_ogg.log
content=all
flashback_scn=12739732806371
version=10.2.0.3.0
col current_scn for 999999999999999999
select current_scn from v$database;
expdp userid=system/oracle add114_ogg_bak.par
directory=dmpdir
tables=(add114.t_name_sequence )
filesize=10G
dumpfile=add114_ogg_bak_%U.dmp
logfile=add114_ogg_bak.log
content=all
同步表統(tǒng)計(jì)：
--查外鍵表NC56.CSCI有無(wú)對(duì)應(yīng)的主鍵表
SELECT a.owner,
A.TABLE_NAME primary_table_name,
A.CONSTRAINT_NAME primary_table_key_name,
b.owner,
B.TABLE_NAME foreign_table_name,
B.CONSTRAINT_NAME foreign_table_foreign_key_name,
B.STATUS foreign_table_foreign_key_stat
FROM DBA_CONSTRAINTS A, DBA_CONSTRAINTS B
WHERE A.CONSTRAINT_NAME = B.R_CONSTRAINT_NAME
and B.CONSTRAINT_TYPE = 'R'
AND b.TABLE_NAME = 'EMP'
and a.owner = 'SCOTT'
and b.owner = 'SCOTT'
ORDER BY 1, 2, 3, 4;
--查主鍵表NC56.CBH有無(wú)對(duì)應(yīng)的外鍵表
SELECT a.owner,
A.TABLE_NAME primary_table_name,
A.CONSTRAINT_NAME primary_table_key_name,
b.owner,
B.TABLE_NAME foreign_table,
B.CONSTRAINT_NAME foreign_table_foreign_key_name,
B.STATUS foreign_table_foreign_key_stat
FROM DBA_CONSTRAINTS A, DBA_CONSTRAINTS B
WHERE A.CONSTRAINT_NAME = B.R_CONSTRAINT_NAME
and B.CONSTRAINT_TYPE = 'R'
AND a.TABLE_NAME = 'EMP'
and a.owner = 'SCOTT'
and b.owner = 'SCOTT'
ORDER BY 1, 2, 3, 4;
==========================
====
select 'alter table '|| t.table_name||' disable constraint '||t.constraint_name||';'
from user_constraints t where t.constraint_type = 'R'
order by t.table_name
啟用外鍵
[sql] view plain copy
select 'alter table '|| t.table_name ||' enable constraint '||t.constraint_name||';'
from user_constraints t where t.constraint_type = 'R'
order by t.table_name
==
grant connect,resource to add114;
grant create view to add114;
grant CREATE DATABASE LINK to ADD114;
grant CREATE SYNONYM to ADD114;
grant DEBUG CONNECT SESSION to ADD114;
dblogin userid oggadmin,password oggadmin#123
add trandata add114.t_name_sequence
table add114.t_name_sequence;
map add114.t_name_sequence, target add114.t_name_sequence;
nohup impdp userid=system/oracle114 directory=dmpdir dumpfile=add114_ogg_01.dmp logfile=add114_ogg_impdp.log content=data_only &
alter trigger add114.TR_AIUD_T_CUSTOMER disable;
start replicat repbk,aftercsn 12739888465710
============================
create user oggadmin identified by oggadmin#123 default tablespace users ;
oggadmin.bst_range_pub_tel_test
source端配置extract進(jìn)程和DATA PUMP進(jìn)程
add extract extbk,tranlog,begin now
add exttrail /oradata1/ogg/dirdat/jfbak/tr, extract extbk, megabytes 100
edit params extbk
extract extbk
USERID oggadmin, PASSWORD oggadmin#123,
EXTTRAIL /oradata1/ogg/dirdat/jfbak/tr
TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE 4194304, BUFSIZE 4194304
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES
DYNAMICRESOLUTION
table oggadmin.t_customer_tel_log_test;
=================
add extract ppbk,exttrailsource /oradata1/ogg/dirdat/jfbak/tr
add rmttrail /oradata1/ogg/dirdat/jfbak/td,extract ppbk,megabytes 100
edit param ppbk
extract ppbk
USERID oggadmin, PASSWORD oggadmin#123,
rmthost 10.6.241.76,mgrport 7809, compress
rmttrail /oradata1/ogg/dirdat/jfbak/td
Dynamicresolution
numfiles 8000
table oggadmin.t_customer_tel_log_test;
==================
目標(biāo)端
edit param ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.checkpointtable
==
add checkpointtable oggadmin.checkpointtable
==
add replicat repbk,exttrail /oradata1/ogg/dirdat/jfbak/td,checkpointtable oggadmin.checkpointtable
edit param repbk
replicat repbk
USERID oggadmin, PASSWORD oggadmin#123,
ASSUMETARGETDEFS
REPERROR DEFAULT,DISCARD
DISCARDFILE /oradata1/ogg/dirrpt/repbk.dsc,append,megabytes 100
ASSUMETARGETDEFS
DYNAMICRESOLUTION
MAP oggadmin.t_customer_tel_log_test, TARGET oggadmin.t_customer_tel_log_test;
==============
dblogin userid oggadmin,password oggadmin#123
===
===刪除物化日志==drop materialized view log on create materialized view log on T1 with rowid
drop materialized view log on BST_SYS_ROLE;
create materialized view log on BST_SYS_ROLE with rowid;
alter table T_BALANCE_WARNING disable constraint FK_T_BALANCE_WARNING_ORDER_ID;
=============
MAP add114.bst_workpaper, TARGET add114.bst_workpaper;
======================
expdp userid=system/oracle
expdp userid=system/oracle add114_ogg.par
directory=expdp_dir
tables=(add114.t_name_sequence )
filesize=10G
dumpfile=add114_ogg_%U.dmp
logfile=add114_ogg.log
content=all
flashback_scn=12739732806371
version=10.2.0.3.0
col current_scn for 999999999999999999
select current_scn from v$database;
expdp userid=system/oracle add114_ogg_bak.par
directory=dmpdir
tables=(add114.t_name_sequence )
filesize=10G
dumpfile=add114_ogg_bak_%U.dmp
logfile=add114_ogg_bak.log
content=all
同步表統(tǒng)計(jì)：
--查外鍵表NC56.CSCI有無(wú)對(duì)應(yīng)的主鍵表
SELECT a.owner,
A.TABLE_NAME primary_table_name,
A.CONSTRAINT_NAME primary_table_key_name,
b.owner,
B.TABLE_NAME foreign_table_name,
B.CONSTRAINT_NAME foreign_table_foreign_key_name,
B.STATUS foreign_table_foreign_key_stat
FROM DBA_CONSTRAINTS A, DBA_CONSTRAINTS B
WHERE A.CONSTRAINT_NAME = B.R_CONSTRAINT_NAME
and B.CONSTRAINT_TYPE = 'R'
AND b.TABLE_NAME = 'EMP'
and a.owner = 'SCOTT'
and b.owner = 'SCOTT'
ORDER BY 1, 2, 3, 4;
--查主鍵表NC56.CBH有無(wú)對(duì)應(yīng)的外鍵表
SELECT a.owner,
A.TABLE_NAME primary_table_name,
A.CONSTRAINT_NAME primary_table_key_name,
b.owner,
B.TABLE_NAME foreign_table,
B.CONSTRAINT_NAME foreign_table_foreign_key_name,
B.STATUS foreign_table_foreign_key_stat
FROM DBA_CONSTRAINTS A, DBA_CONSTRAINTS B
WHERE A.CONSTRAINT_NAME = B.R_CONSTRAINT_NAME
and B.CONSTRAINT_TYPE = 'R'
AND a.TABLE_NAME = 'EMP'
and a.owner = 'SCOTT'
and b.owner = 'SCOTT'
ORDER BY 1, 2, 3, 4;
==========================
====
select 'alter table '|| t.table_name||' disable constraint '||t.constraint_name||';'
from user_constraints t where t.constraint_type = 'R'
order by t.table_name
啟用外鍵
[sql] view plain copy
select 'alter table '|| t.table_name ||' enable constraint '||t.constraint_name||';'
from user_constraints t where t.constraint_type = 'R'
order by t.table_name
==
grant connect,resource to add114;
grant create view to add114;
grant CREATE DATABASE LINK to ADD114;
grant CREATE SYNONYM to ADD114;
grant DEBUG CONNECT SESSION to ADD114;
dblogin userid oggadmin,password oggadmin#123
add trandata add114.t_name_sequence
table add114.t_name_sequence;
map add114.t_name_sequence, target add114.t_name_sequence;
nohup impdp userid=system/oracle114 directory=dmpdir dumpfile=add114_ogg_01.dmp logfile=add114_ogg_impdp.log content=data_only &
alter trigger add114.TR_AIUD_T_CUSTOMER disable;
start replicat repbk,aftercsn 12739888465710
============================
create user oggadmin identified by oggadmin#123 default tablespace users ;
oggadmin.bst_range_pub_tel_test
source端配置extract進(jìn)程和DATA PUMP進(jìn)程
add extract extbk,tranlog,begin now
add exttrail /oradata1/ogg/dirdat/jfbak/tr, extract extbk, megabytes 100
edit params extbk
extract extbk
USERID oggadmin, PASSWORD oggadmin#123,
EXTTRAIL /oradata1/ogg/dirdat/jfbak/tr
TRANLOGOPTIONS DBLOGREADER, DBLOGREADER BUFSIZE 4194304, BUFSIZE 4194304
FETCHOPTIONS FETCHPKUPDATECOLS
NOCOMPRESSDELETES
DYNAMICRESOLUTION
table oggadmin.t_customer_tel_log_test;
=================
add extract ppbk,exttrailsource /oradata1/ogg/dirdat/jfbak/tr
add rmttrail /oradata1/ogg/dirdat/jfbak/td,extract ppbk,megabytes 100
edit param ppbk
extract ppbk
USERID oggadmin, PASSWORD oggadmin#123,
rmthost 10.6.241.76,mgrport 7809, compress
rmttrail /oradata1/ogg/dirdat/jfbak/td
Dynamicresolution
numfiles 8000
table oggadmin.t_customer_tel_log_test;
==================
目標(biāo)端
edit param ./GLOBALS
GGSCHEMA oggadmin
CHECKPOINTTABLE oggadmin.checkpointtable
==
add checkpointtable oggadmin.checkpointtable
==
add replicat repbk,exttrail /oradata1/ogg/dirdat/jfbak/td,checkpointtable oggadmin.checkpointtable
edit param repbk
replicat repbk
USERID oggadmin, PASSWORD oggadmin#123,
ASSUMETARGETDEFS
REPERROR DEFAULT,DISCARD
DISCARDFILE /oradata1/ogg/dirrpt/repbk.dsc,append,megabytes 100
ASSUMETARGETDEFS
DYNAMICRESOLUTION
MAP oggadmin.t_customer_tel_log_test, TARGET oggadmin.t_customer_tel_log_test;
==============
dblogin userid oggadmin,password oggadmin#123
===
===刪除物化日志==drop materialized view log on create materialized view log on T1 with rowid
drop materialized view log on BST_SYS_ROLE;
create materialized view log on BST_SYS_ROLE with rowid;
alter table T_BALANCE_WARNING disable constraint FK_T_BALANCE_WARNING_ORDER_ID;
網(wǎng)站題目：ogg配置例子
網(wǎng)站鏈接：http://bm7419.com/article16/jcsidg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供標(biāo)簽優(yōu)化、小程序開(kāi)發(fā)、網(wǎng)站設(shè)計(jì)公司、營(yíng)銷(xiāo)型網(wǎng)站建設(shè)、網(wǎng)站制作、企業(yè)建站
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 新站不收錄的解決辦法 2014-07-15
- SEO優(yōu)化思維陷阱:網(wǎng)站收錄與索引難以分辨 2022-05-20
- 如何添加網(wǎng)站內(nèi)鏈提升網(wǎng)站收錄量? 2014-04-07
- 網(wǎng)站制作完成上線后一直沒(méi)有收錄怎么辦 2016-09-22
- 網(wǎng)站文章有收錄，為什么搜索標(biāo)題卻找不到？ 2017-02-12
- 為你揭秘網(wǎng)站外鏈?zhǔn)珍浻直粍h除的原因 2016-11-02
- 為什么我的網(wǎng)站一直沒(méi)有收錄？ 2016-08-20
- 網(wǎng)站推廣收錄最實(shí)用的八大方法 2016-11-05
- 網(wǎng)站收錄下降的原因是什么 2014-04-03
- 為什么文章不收錄？答案在這里 2016-11-09
- 網(wǎng)站收錄不等于網(wǎng)站流量 2013-12-29
- 成都SEO優(yōu)化如何快速增加網(wǎng)站收錄？ 2022-09-25