Do not use this option with the INTEGRATED option. This argument is required if you do not want to use a checkpoint table with the Replicat group that is being created. This argument overrides any default CHECKPOINTTABLE specification in the GLOBALS file. Specifies that this Replicat group will not write checkpoints to a checkpoint table. The table must first be added with the ADD CHECKPOINTTABLE command. Include the owner and table name, as in hr.hr_checkpoint. Specifies that this Replicat group will write checkpoints to the specified table in the database. Contact Oracle Support before using this option. Specifies the relative byte address within the trail file that is specified by EXTSEQNO. To use EXTSEQNO, you must also use EXTRBA. For example, if the trail file is c:\ggs\dirdat\aa000026, you would specify EXTSEQNO 26.īy default, processing begins at the beginning of a trail unless this option is used. Specify the sequence number, but not any zeroes used for padding. Specifies the sequence number of the file in a trail in which to begin processing data. yyyy-mm-dd]]īegins extracting changes from a specific time. NOWīegins replicating changes from the time when the group is created. See Administering Oracle GoldenGate for Windows and UNIX for more information about checkpoints. [, BEGIN ĭefines an initial checkpoint in the trail. For more information about Replicat modes, see "Deciding Which Apply Method to Use" in Installing and Configuring Oracle GoldenGate for Oracle Database and "BATCHSQL". (Oracle) Unless the INTEGRATED option is used, this command creates a Replicat group in non-integrated mode. Oracle GoldenGate recommends keeping the number of Extract and Replicat groups (combined) at the default level of 300 or below in order to manage your environment effectively. At the supported level, all groups can be controlled and viewed in full with GGSCI commands such as the INFO and STATUS commands. Oracle GoldenGate supports up to 5,000 concurrent Extract and Replicat groups per instance of Oracle GoldenGate Manager. This command cannot exceed 500 bytes in size for all keywords and input, including any text that you enter for the DESC option. Unless SPECIALRUN is specified, ADD REPLICAT creates an online process group that creates checkpoints so that processing continuity is maintained from run to run. Use ADD REPLICAT to create a Replicat group.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |