You can choose to deploy your solution either in Online of Offline mode in Oracle GoldenGate Studio.
Online Deploy: Online deployments require that the Oracle GoldenGate instances that are associated in the deployment profile have both the manager and Oracle GoldenGate Monitor JAgent is installed and running.
Offline Deploy: Oracle GoldenGate Studio generates the GoldenGate replication parameter and obey files and saves them in a local directory.
The online deployment implicitly runs a validation check by pinging the GoldenGate instances that have been assigned as resources in the deployment profile and ensures that the minimum required parameters have been set for those data server types. Any parameter that is set and not related to the data server type to which you are deploying is ignored when generating the parameter and obey files.
You can also explicitly run a validation by selecting the green check mark icon in the deployment profile toolbar.
Before you write the configuration and command files, the JAgent backs up any files it is about to overwrite to the
dirtmp directory of the Oracle GoldenGate instance. Any conflicting process is stopped. If you did not deselect the start option in the Deployment Configuration options the process is started once the new configuration files are created.
Once a deployment profile has been deployed you can view the deployment history and some monitoring matrixes in the Overview tab under Deployment Profile next to the Deployment View tab. Deployment Configuration options can also be found in the Overview tab under Deployment Profile. Those options include starting all GoldenGate processes and performing full initial loads. Currently, partial initial loads are not supported.
A solution can be deployed in several ways as follows:
Through the Deployment Profile Toolbar.
Through the context menu in the Deployment Profile editor.
Through the Projects Navigator Deployment Profile Node.
For example, to deploy a solution through the Projects Navigator:
For offline deployment, you can select a directory to save the deployment files.
This tab is used to edit information regarding the name and description of the deployment profile, deployment history, and deployment configuration.
Use this tab to edit high level details of the deployment profile. The available fields are:
Deployment Profile Name: You can view and edit the name of the deployment profile.
Description: You can add or edit the description of the deployment profile.
It provides a historical record of past deployments for a project, solution, deployment, or a single deployment profile.You can use the Select Columns icon in the table's toolbar to tailor your view of the deployment history information. Columns can be re-ordered as per requirement.
The available columns are:
Details information about the status of every process under Monitoring. Additionally, you can monitor the status of each process that is currently deployed on an Oracle GoldenGate instance, such as the status, type, and mode of processes.
The tab looks as follows:
Figure 5-1 Monitoring Tab
The available columns are:
Last Operation Lag
last Operation Timestamp
last Checkpoint Timestamp
End of File
Total Executed DDLs
Use this tab to view or edit the deployment options and physical resources.
You use the Deployment Settings check boxes to control the processes that must start automatically. The following settings can be configured:
Start All GoldenGate Processes: Select this check box to start the Capture, Pump, and Apply processes.
Start Pump Processes: Select this check box to start the Pump processes.
Start Apply Processes: Select this check box to start the Apply processes.
Initial Load Settings
Oracle GoldenGate: Select this check box to start the Oracle GoldenGate initial load process.
Oracle Data Pump: Select this check box to start the Oracle Data Pump initial load process.
If you select the Start process in deployment configuration screen, then the Change Data Capture (CDC) process will start automatically at the successful completion of Oracle Data Pump Initial Load. If you do not select the Start process in deployment configuration screen, then the CDC process will not start automatically at the successful completion of Oracle Data Pump Initial Load.
If Oracle GoldenGate Studio is closed before the automatic start of CDC process, then the CDC process will not start automatically. You can start the CDC process manually using System Change Number (SCN), or starting the CDC process manually from the monitoring screen. The SCN increments by one with every commit.
You can add the Remote Link (network link) and Parallelism in this dialog. By default, parallelism is set to one.
Oracle GoldenGate Studio uses the Oracle Data Pump API for the initial load. Oracle Data Pump API can transfer data using different methods. In Oracle GoldenGate Studio, the IMPORT of data using flashback SCN is used. The Remote Link (network link) is used to access the source Database.
During Online Deployment with Oracle Data Pump Initial Load , Oracle GoldenGate Studio starts a PL/SQL procedure in the target database. This PL/SQL block invokes Oracle Data Pump job, providing it with Database Link to copy the data from source, SCN of source database, number of parallel threads to be launched, and log filename to log its activity. You have to provide the Database Link and Parallel values in the configuration screen while SCN of source database and log file name are provided by Oracle GoldenGate Studio. Oracle GoldenGate Studio also assumes
DATA_PUMP_DIR directory to be created in target database, as this directory is used to create the log file. Oracle Data Pump table shows the current state of the Oracle Data Pump job. You can click on View Activity Log to view the content of the ODP Job
OGG_LOG log file.
You can only use the default trail file directory
dirdat. User defined trail file directories are not supported in Oracle GoldenGate Studio and are not parsed.
In parallel , CDC captures and replicat processes are deployed in Oracle GoldenGate. The capture processes are started to capture the online transactions while Oracle Data Pump is progressing. Oracle GoldenGate Studio waits for Oracle Data Pump job to complete. After completion of the Oracle Data Pump job, if Start Replicat option was selected, Oracle GoldenGate Studio starts the replicat processes with the related SCN number shown in the Oracle Data Pump page of the particular process. If not, you have to manually start the process by clicking on Start CDC Replicat in the Oracle Data Pump window.
If you shut down Oracle GoldenGate Studio after completion of Deployment in Oracle GoldenGate but before Oracle Data Pump job is complete, you have to manually starts the Replicat by clicking on Start CDC Replicat in the Oracle Data Pump page or Start with.. using the SCN shown in Oracle Data Pump page.
You can select the Replication Paths from the drop-down list and the status as Not Started, Running, Error, Finished, and Replicat Started. The status is displayed in tabular format. You can also use the toolbar to search, start the CDC Replicat, view the activity log, refresh table, and add or remove additional table columns.
The following table columns are displayed by default:
The Time Remaining column can be empty when Oracle Data Pump is running. This is not related to the normal functioning of the product.
The Oracle Data Pump window looks as follows: