Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

1

主题
1#
发表于 2014-6-15 19:08:07 | 查看: 4482| 回复: 0
extract ex7
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db)
SETENV (ORACLE_SID=orcl)
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
dynamicresolution
userid ggs,password ggs
IGNORETRUNCATES
exttrail /u02/gg/dirdat/e7
TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT THREADID 1 %t_%s_%r.dbf
TRANLOGOPTIONS ALTARCHIVELOGDEST INSTANCE orcl /archive
DISCARDFILE /u02/gg/dirrpt/e7.dsc, APPEND, MEGABYTES 1000
TRANLOGOPTIONS EXCLUDEUSER ggs
ddl include all &
exclude optype "truncate"
table user07.*;

datapump
extract dp7
userid ggs,password ggs
dynamicresolution
rmthost 192.168.220.22,mgrport 7809
rmttrail /u02/gg/dirdat/r7
table user07.*;


replicat rep7
SETENV (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db)
SETENV (ORACLE_SID=test)
SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ggs,password ggs
ASSUMETARGETDEFS
discardfile /u02/gg/dirrpt/rep7.dsc,append,megabytes 50
IGNORETRUNCATES
dynamicresolution
ddl include mapped
MAP user07.*, TARGET user07.*;

我的ogg配置是这样的,我想配置ddl,然后在配置中忽略truncate ,可是怎么都忽略不了。不知道大家看看问题在哪里?
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 06:59 , Processed in 0.043717 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569