Process Parameter Name Parameter Description
MGR PORT The TCP/IP port number that the Manager process uses for communication with other processes.
MGR PURGEOLDEXTRACTS Enables purging of Extract and Replicat trail files from associated trail locations.
MGR AUTOSTART Directs the Manager process to automatically start Extract and Replicat processes.
MGR AUTORESTART Directs the Manager process to automatically restart Extract and Replicat processes after failure.
EXTRACT EXTRACT Defines the name of the Extract process.
EXTRACT SOURCEISTABLE Defines the source as database table. Used in Initial Load only.
EXTRACT RMTTASK Configures Extract to communicate directly with Replicat over TCP/IP for direct load Initial Load methods.
EXTRACT RMTFILE Defines the location and filename on the remote system where the Extract process writes its data.
Used in Initial Load and batch processing operations.
EXTRACT RMTTRAIL Configures Extract to write data to a remote trail. Used in the Data Pump Extract parameter file.
EXTRACT RMTHOST Defines the remote system's hostname. If a hostname is used, it must resolve to an IP address.
EXTRACT EXTFILE Defines the name and location for a file used to temporarily store the data changes written to by the Extract process.
Used in conjunction with SPECIALRUN for Initial Load and batch processing operations.
EXTRACT MGRPORT Defines the Manager Port number.
EXTRACT/REPLICAT USERID Oracle database GGS Admin user ID.
EXTRACT/REPLICAT PASSWORD Oracle database GGS Admin user password.
EXTRACT/REPLICAT TABLE Defines the source (Extract) or target (Replicat) table name.
EXTRACT/REPLICAT DISCARDFILE Defines the name and location of the process discarded data file.
EXTRACT/REPLICAT SETENV Specifies the Oracle environment for GoldenGate connection to the Oracle database. For example, sets the ORACLE_
SID environment variable.
REPLICAT REPLICAT Defines the name of the Replicat process.
REPLICAT SPECIALRUN Indicates the Replicat is a "one-off" process, typically an Initial Load. Use with END RUNTIME parameter.
REPLICAT RUNTIME All unprocessed records with timestamps up to the current point in time are processed; otherwise the Replicat process is terminated.
REPLICAT ASSUMETARGETDEFS Declares the source tables are identical in structure as the target tables.
REPLICAT HANDLECOLLISIONS Directs automatic resolution of duplicate and missing-record errors when applying data on the target database. This parameter
is generally only used for the Initial Load.
REPLICAT MAP Defines the mapping between source and target tables. Can be used for column mapping and transformations.
REPLICAT BULKLOAD Directs the Replicat to use the bulk load method of Initial Load, writing data directly to the SQL*Loader interface
___________________________________________________________________________________________________________________________
Process Parameter Name Parameter Description
MGR PORT 管理进程与其他进程进行联系所使用的TCP/IP 端口号
MGR PURGEOLDEXTRACTS 从相关trail的位置启用清除Extract和Replicat跟踪文件
MGR AUTOSTART 引导管理进程自动启动Extract和Replicat进程。
MGR AUTORESTART 在启动失败后引导管理进程自动重新启动Extract和Replicat进程。
EXTRACT EXTRACT 定义Extract进程的名字。
EXTRACT SOURCEISTABL 定义源数据库表。仅用于初始化加载。
EXTRACT RMTTASK 配置Extract与Replicat通过TCP/ IP沟通以直接加载初始加载方式。
EXTRACT RMTFILE 定义E进程写入数据的远程系统的路径和文件名。
用在初始加载和批处理操作。.
EXTRACT RMTTRAIL 配置Extract写入数据到一个远程的trail文件,用在数据泵Extract参数文件。
EXTRACT RMTHOST 定义远程系统的主机名,如果主机名已被使用,必须解析成IP地址。
EXTRACT EXTFILE 定义被用来临时存储E进程写入造成数据改变的文件的名字和位置。
与 SPECIALRUN 参数一起 用在初始加载和批处理操作
EXTRACT MGRPORT 定义管理端口号。
EXTRACT/REPLICAT USERID ORACLE数据库GGSg管理用户ID。
EXTRACT/REPLICAT PASSWORD ORACLE数据库GGSg管理用户密码。
EXTRACT/REPLICAT TABLE 定义源端(Extract)或者目标端(Replicat)的表名。
EXTRACT/REPLICAT DISCARDFILE 定义了处理丢弃的数据文件的名称和位置。
EXTRACT/REPLICAT SETENV 指定Oracle环境提供GoldenGate连接到Oracle数据库。例如,设置ORACLE_SID环境变量。
REPLICAT REPLICAT 定义R进程的名字。
REPLICAT SPECIALRUN 说明Replicat是“一次性”的过程,通常是初始加载。使用带有END RUNTIME 参数。
REPLICAT RUNTIME 所有未处理记录的时间戳到当前时间点被进行处理;否则Replicat处理终止。
REPLICAT ASSUMETARGETDEFS 声明源表的结构为目标表完全相同。
REPLICAT HANDLECOLLISIONS 在目标数据库应用的数据时,指示重复的自动解析和丢失记录错误。这个参数一般只用于初始加载。
REPLICAT MAP 定义源和目标表之间的映射。可用于列映射和转换。
REPLICAT BULKLOAD 说明Replicat使用初始加载的批量加载方法,直接将数据写入到SQL* Loader的接口。
MGR PORT The TCP/IP port number that the Manager process uses for communication with other processes.
MGR PURGEOLDEXTRACTS Enables purging of Extract and Replicat trail files from associated trail locations.
MGR AUTOSTART Directs the Manager process to automatically start Extract and Replicat processes.
MGR AUTORESTART Directs the Manager process to automatically restart Extract and Replicat processes after failure.
EXTRACT EXTRACT Defines the name of the Extract process.
EXTRACT SOURCEISTABLE Defines the source as database table. Used in Initial Load only.
EXTRACT RMTTASK Configures Extract to communicate directly with Replicat over TCP/IP for direct load Initial Load methods.
EXTRACT RMTFILE Defines the location and filename on the remote system where the Extract process writes its data.
Used in Initial Load and batch processing operations.
EXTRACT RMTTRAIL Configures Extract to write data to a remote trail. Used in the Data Pump Extract parameter file.
EXTRACT RMTHOST Defines the remote system's hostname. If a hostname is used, it must resolve to an IP address.
EXTRACT EXTFILE Defines the name and location for a file used to temporarily store the data changes written to by the Extract process.
Used in conjunction with SPECIALRUN for Initial Load and batch processing operations.
EXTRACT MGRPORT Defines the Manager Port number.
EXTRACT/REPLICAT USERID Oracle database GGS Admin user ID.
EXTRACT/REPLICAT PASSWORD Oracle database GGS Admin user password.
EXTRACT/REPLICAT TABLE Defines the source (Extract) or target (Replicat) table name.
EXTRACT/REPLICAT DISCARDFILE Defines the name and location of the process discarded data file.
EXTRACT/REPLICAT SETENV Specifies the Oracle environment for GoldenGate connection to the Oracle database. For example, sets the ORACLE_
SID environment variable.
REPLICAT REPLICAT Defines the name of the Replicat process.
REPLICAT SPECIALRUN Indicates the Replicat is a "one-off" process, typically an Initial Load. Use with END RUNTIME parameter.
REPLICAT RUNTIME All unprocessed records with timestamps up to the current point in time are processed; otherwise the Replicat process is terminated.
REPLICAT ASSUMETARGETDEFS Declares the source tables are identical in structure as the target tables.
REPLICAT HANDLECOLLISIONS Directs automatic resolution of duplicate and missing-record errors when applying data on the target database. This parameter
is generally only used for the Initial Load.
REPLICAT MAP Defines the mapping between source and target tables. Can be used for column mapping and transformations.
REPLICAT BULKLOAD Directs the Replicat to use the bulk load method of Initial Load, writing data directly to the SQL*Loader interface
___________________________________________________________________________________________________________________________
Process Parameter Name Parameter Description
MGR PORT 管理进程与其他进程进行联系所使用的TCP/IP 端口号
MGR PURGEOLDEXTRACTS 从相关trail的位置启用清除Extract和Replicat跟踪文件
MGR AUTOSTART 引导管理进程自动启动Extract和Replicat进程。
MGR AUTORESTART 在启动失败后引导管理进程自动重新启动Extract和Replicat进程。
EXTRACT EXTRACT 定义Extract进程的名字。
EXTRACT SOURCEISTABL 定义源数据库表。仅用于初始化加载。
EXTRACT RMTTASK 配置Extract与Replicat通过TCP/ IP沟通以直接加载初始加载方式。
EXTRACT RMTFILE 定义E进程写入数据的远程系统的路径和文件名。
用在初始加载和批处理操作。.
EXTRACT RMTTRAIL 配置Extract写入数据到一个远程的trail文件,用在数据泵Extract参数文件。
EXTRACT RMTHOST 定义远程系统的主机名,如果主机名已被使用,必须解析成IP地址。
EXTRACT EXTFILE 定义被用来临时存储E进程写入造成数据改变的文件的名字和位置。
与 SPECIALRUN 参数一起 用在初始加载和批处理操作
EXTRACT MGRPORT 定义管理端口号。
EXTRACT/REPLICAT USERID ORACLE数据库GGSg管理用户ID。
EXTRACT/REPLICAT PASSWORD ORACLE数据库GGSg管理用户密码。
EXTRACT/REPLICAT TABLE 定义源端(Extract)或者目标端(Replicat)的表名。
EXTRACT/REPLICAT DISCARDFILE 定义了处理丢弃的数据文件的名称和位置。
EXTRACT/REPLICAT SETENV 指定Oracle环境提供GoldenGate连接到Oracle数据库。例如,设置ORACLE_SID环境变量。
REPLICAT REPLICAT 定义R进程的名字。
REPLICAT SPECIALRUN 说明Replicat是“一次性”的过程,通常是初始加载。使用带有END RUNTIME 参数。
REPLICAT RUNTIME 所有未处理记录的时间戳到当前时间点被进行处理;否则Replicat处理终止。
REPLICAT ASSUMETARGETDEFS 声明源表的结构为目标表完全相同。
REPLICAT HANDLECOLLISIONS 在目标数据库应用的数据时,指示重复的自动解析和丢失记录错误。这个参数一般只用于初始加载。
REPLICAT MAP 定义源和目标表之间的映射。可用于列映射和转换。
REPLICAT BULKLOAD 说明Replicat使用初始加载的批量加载方法,直接将数据写入到SQL* Loader的接口。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29863023/viewspace-1429727/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29863023/viewspace-1429727/