ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Creating a reporting configuration with a data pump on an intermediary system

Creating a reporting configuration with a data pump on an intermediary system

原创 Linux操作系统 作者:nmgzw 时间:2019-05-06 11:12:07 0 删除 编辑


实验目的:
将源数据库表emp1经过intermediate机器,最终传送到目标机器emp1表里

1、源机器设置
ADD EXTRACT  interext, TRANLOG, begin now, THREADS 1
ADD EXTTRAIL /home/oracle/dirdat/ka, EXTRACT interext

EXTRACT  interext
-- Specify database login information as needed for the database:
OBEY /home/oracle/dirprm/common.prm
-- Specify the local trail that this Extract writes to:
EXTTRAIL  /home/oracle/dirdat/ka
-- Specify tables to be captured:
TABLE  scott.emp1;

ADD EXTRACT pump_1, EXTTRAILSOURCE /home/oracle/dirdat/ka, begin now
ADD RMTTRAIL C:\oracle\GOLD\dirdat\ka, EXTRACT pump_1

-- Identify the data pump group:
EXTRACT pump_1
-- Specify database login information as needed for the database:
OBEY /home/oracle/dirprm/common.prm
-- Specify the name or IP address of the intermediary system:
RMTHOST  training, MGRPORT 7809
-- Specify the remote trail on the intermediary system:
RMTTRAIL C:\oracle\GOLD\dirdat\ka
-- Allow mapping, filtering, conversion or pass data through as-is:
PASSTHRU
-- Specify tables to be captured:
TABLE  scott.emp1;

2、INTERMEDIATE机器设置
ADD EXTRACT pump_2, EXTTRAILSOURCE   C:\oracle\GOLD\dirdat\ka, begin now
ADD RMTTRAIL /home/oracle/gold/ka, EXTRACT pump_2

-- Identify the data pump group:
EXTRACT pump_2
-- State whether or not source and target definitions are identical:
--SOURCEDEFS | ASSUMETARGETDEFS
-- Specify the target definitions file if SOURCEDEFS was used:
--TARGETDEFS
-- Specify the name or IP address of the target system:
RMTHOST rac1, MGRPORT 7809
-- Specify the remote trail on the target system:
RMTTRAIL  /home/oracle/gold/ka
-- Allow mapping, filtering, conversion or pass data through as-is:
PASSTHRU
-- Specify tables to be captured:
TABLE  scott.emp1;

3、目标机器设置
ADD REPLICAT interrep, EXTTRAIL /home/oracle/gold/ka, begin now

-- Identify the Replicat group:
REPLICAT interrep
-- State whether or not source and target definitions are identical:
--SOURCEDEFS | ASSUMETARGETDEFS
-- Specify database login information as needed for the database:
USERID ggs_admin, PASSWORD ggs_admin
-- Specify error handling rules:
REPERROR error, response
-- Specify tables for delivery:
MAP scott.emp1, TARGET scott.emp1;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25702/viewspace-694629/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-10-18

  • 博文量
    71
  • 访问量
    64453