Goldengate interview questions
Oracle Golden Gate is a robust real-time data integration and
replication solution, offering high availability, data integration, change data
capture, and data replication capabilities across heterogeneous IT
environments. The 19c version emphasizes extreme performance, simplified
configuration, and enhanced integration with Oracle Database, while also
extending support for cloud environments and ensuring advanced security.
Additionally, Oracle provides complementary tools like Oracle Golden Gate Veridata
for high-speed data comparison and verification between databases. With its
versatility and capabilities, Oracle Golden Gate plays a crucial role in
ensuring real-time data consistency and availability in complex enterprise
systems.
1.
What exactly is Oracle GoldenGate?
Ans: Oracle Golden Gate is a data replication and integration solution
that enables the real-time movement and synchronization of data between
different databases, whether they are Oracle databases or non-Oracle databases.
2.
How is Oracle Golden Gate different from regular database copying methods?
Ans: Oracle Golden Gate offers real-time data replication and
synchronization, which means that changes are propagated as soon as they occur
in the source database. This is different from traditional methods like
periodic batch ETL (Extract, Transform, Load) processes, which are typically
not real-time and may result in data lag.
3.
How does Oracle Golden Gate architecture work?
Ans:Oracle Golden Gate uses a capture-and-apply mechanism. It captures
changes made to source data and then applies those changes to target databases
in real time. It employs a combination of extract processes, trail files, and
replicate processes to achieve this.
4.
How do you set up and configure Oracle Golden Gate to copy data between
databases?
Ans:Setting up Oracle Golden Gate involves defining the source and
target databases, configuring extract and replicat processes, specifying data
mapping and transformation rules, and ensuring network connectivity between
source and target systems.
5.
When should you use different Golden Gate copying methods, and what are they?
Ans:Oracle Golden Gate provides various copying methods, such as
unidirectional, bidirectional, and multi-master replication For example,
unidirectional replication is suitable for one-way data flow, while
bidirectional replication is used when changes can occur in both source and
target databases.
6.
What do Extract and Replicat do in Oracle Golden Gate copying?
Ans: Extract processes capture data changes from the source database and
write them to trail files.Replicat processes read the data changes from trail
files and apply them to the target database.
7.
How does Oracle Golden Gate handle problems when the same data changes in
different ways in different databases?
Ans: Oracle Golden Gate employs conflict resolution techniques to handle
conflicts that arise when the same data is changed differently in different
databases. Users can define conflict resolution rules to determine how
conflicts are resolved, such as preferring changes from one database over
another or merging conflicting changes.
8.
How can Oracle Golden Gate help with keeping data safe and available in case of
disasters or problems?
Ans:Oracle Golden Gate can be used to create a disaster recovery (DR)
solution by continuously replicating data changes to a standby database. In the
event of a disaster or database failure, the standby database can be brought
online to ensure data availability and minimize downtime.
9.
What can Oracle Golden Gate do for data transformation?
Ans:Oracle Golden Gate provides data transformation capabilities,
allowing you to modify, filter, or route data as it is replicated. This is
useful for various purposes:
Data cleansing
Data filtering
Data transformation
10.
What can you do to make sure data stays secure while using Oracle for copying?
Ans:Strong authentication and authorization.
Encryption for data in transit and Golden Gate trails.
Strict access control with RBAC.
Network security through firewalls and access restrictions.
Regularly update and patch Golden Gate software.
Encrypt sensitive configuration files and credentials.
11.
What are the additional logging requirements?
Ans:Additional logging requirements in Oracle Golden Gate depend on your
specific configuration and use case. You may need to configure supplemental
logging in the source database to capture specific data changes accurately.
12.
What makes up the Golden Gate Replication’s Principal Elements?
Ans:Extract: Captures and reads the source database changes.
Pump: Transfers the captured changes to the target system.
Replicat: Applies the changes to the target database.
Trails: Files used to store captured changes for replication.
13.
What Kind Of Encryption Supports Goldengate?
Ans: Oracle Golden Gate supports
encryption for data transmission using SSL/TLS. You can configure SSL
encryption to secure data replication between the source and target systems.
14.
How Does The Credential Store Add Credentials?
Ans: You can add credentials to the Oracle Credential Store by using the
ogg_cred utility or the Oracle Wallet Manager. With the help of these tools,
you may safely store and manage the users and passwords that Oracle Golden Gate
processes require.
15.
How Can Information Be Retrievably From The Oracle Credential Store?
Ans:You can retrieve information from the Oracle Credential Store using
the getWalletPassword command or through Golden Gate parameter files by
referencing the stored credentials.
16.
In a coordinated model, how does the replica function?
Ans:The replication processes on the target side (Replicat processes)
are synchronized with the arrival of data changes from the source (Extract and
Pump processes). This coordination ensures that changes are applied in the
correct order, maintaining data consistency.
17.
If a trail file is encrypted, how would you view it using a log dump?
Ans:You can use the logdump utility provided by Oracle Golden Gate to
view encrypted trail files. You need to provide the necessary encryption key or
passphrase to decrypt and view the content.
18.
What are the available Ogg Initial Load methods?
Ans: Oracle Golden Gate provides several methods for initial data
loading, including:
Direct Load: Uses SQL*Loader or external tables.
Initial Data Pump: Uses data pump files generated by Extract.
Import/Export: Uses Oracle Data Pump utilities.
Database Cloning: Cloning the source database.
19. What is the best procedure for Ogg extract files removal?
Ans: Generally, you can use the PURGEOLDEXTRACT command to remove old extract
files. Be cautious when removing files to ensure data integrity and retention
policies are met.
20. What are the common use cases for Golden Gate in real-world
scenarios?
Ans:Data warehousing and reporting.
High availability and disaster recovery solutions.
Database migrations and upgrades.
Cloud database integration.
Data consolidation.
21.
How does Oracle Golden Gate handle data consistency and synchronization between
source and target databases?
Ans:Oracle Golden Gate ensures data consistency and synchronization by
capturing changes from the source database’s transaction logs, transforming
them into a platform-agnostic format, and applying them to the target database.
22.
What role does the Oracle Golden Gate Manager play in monitoring and managing
replication processes?
Ans: The Oracle Golden Gate Manager is responsible for monitoring and
managing replication processes. It provides a centralized control point for
starting, stopping, and monitoring data replication tasks.
23.
What is the significance of checkpoints in Oracle Goldengate?
Ans: Checkpoints in Oracle Golden Gate represent a point in time up to
which data has been successfully applied to the target database. They play a
crucial role in ensuring data consistency and replication integrity.
24.
How do checkpoints impact replication performance?
Ans: Frequent checkpoints can impact replication performance, so finding
the right balance between checkpoint frequency and performance is essential.
25.
What are the advantages of bi-directional replication?
Ans: Real-time synchronization of data between databases.
Improved data consistency and integrity.
Support for active-active configurations.
Reduced downtime during maintenance and upgrades.
26.
What potential challenges to be aware of when implementing Oracle GoldenGate?
Ans:Configuration complexity.
Monitoring and troubleshooting.
Data conflict resolution.
Resource utilization and performance tuning.
Licensing costs.
27.
How does Oracle Golden Gate support heterogeneous replication?
Ans:Oracle Golden Gate supports heterogeneous replication by capturing
source database changes in a platform-independent format and then applying them
to the target database in its native format.
28.
What is the licensing model for Oracle GoldenGate?
Ans:Oracle Golden Gate typically uses a per-processor licensing model,
where you need to purchase licenses for the number of processors (CPU cores) in
the source and target systems where Golden Gate is running.
29.
Are there any methods for keeping track of and improving GoldenGate’s
performance?
Ans:Regularly monitoring replication lag.
Tuning extract and replicating processes for optimal performance.
Properly sizing and configuring the Golden Gate environment.
Implementing a robust monitoring and alerting system.
30.
What’s the primary purpose of Oracle GoldenGate?
Ans:GoldenGate’s primary purpose is to enable real-time data replication
and synchronization between heterogeneous databases, supporting various use
cases like reporting, high availability, migrations, and data integration.
31.
How does Golden Gate handle database schema changes?
Ans:Golden Gate handles schema changes by capturing and replicating DDL
(Data Definition Language) statements, allowing for synchronization of database
schema changes between source and target databases.
32.
Explain data consistency in GoldenGate.
Ans:Data consistency in Golden Gate ensures that replicated data remains
synchronized and accurate between source and target databases, preventing data
inconsistencies or conflicts during the replication process.
33. What is conflict detection and resolution in GoldenGate?
Ans:Conflict detection and resolution in Golden Gate involve identifying
and resolving conflicts that may occur when data changes are made
simultaneously in both the source and target databases during bidirectional
replication.
34. Describe the Extract process in GoldenGate.
Ans:The Extract process in Golden Gate captures and extracts data
changes from the source database’s transaction logs, converting them into a
platform-independent format for replication.
35. How can you ensure data integrity in GoldenGate?
Ans:Ensuring data integrity in Golden Gate involves setting up proper
configuration, checkpointing, and monitoring to guarantee that data changes are
accurately and consistently replicated between the source and target databases.
36. What are common troubleshooting methods for GoldenGate?
Ans:Monitoring replication lag
Reviewing log files
Checking configuration settings
Verifying network connectivity.
37. How does Golden Gate support cloud replication?
Ans:Golden Gate supports cloud replication by facilitating real-time
data synchronization between on-premises databases and cloud-based databases,
allowing businesses to move data to and from the cloud.
38. What’s the role of the Golden Gate Hub architecture?
Ans:The Golden Gate Hub architecture acts as a central hub for data
integration, enabling multiple sources to replicate data to a centralized
target, simplifying data consolidation and distribution.
39. How do you upgrade GoldenGate?
Ans:Backup existing configurations and data.
Install the new Golden Gate version.
Update configuration files, if necessary.
Test the upgrade in a non-production environment.
Apply the upgrade to the production environment while minimizing
downtime.
40. How does Golden Gate handle large objects (LOBs)?
Ans:Golden Gate handles large objects (LOBs) by replicating them in
chunks, breaking them into manageable pieces, and then reconstructing them on
the target database.
41. What security features does Golden Gate offer?
Ans:Golden Gate provides security features including user
identification, data encryption, and access control to guarantee the
confidentiality and integrity of replicated data.
42. What are the topologies Supported By Goldengate?
Ans:Oracle Golden Gate supports various replication topologies,
Fig: Oracle Golden Gate Topologies
43. Explain conflict avoidance in GoldenGate.
Ans:Conflict avoidance in Golden Gate involves configuring rules and
strategies to prevent data conflicts from occurring during bidirectional
replication, reducing the need for conflict resolution.
44. What’s Integrated Apply in GoldenGate?
Ans:Integrated Apply in Golden Gate is a replication method that applies
changes directly to the target database’s internal structures, bypassing SQL
processing, and improving replication performance.
45. How do you set up data filtering in GoldenGate?
Ans:Data filtering in Golden Gate is set up by specifying filter
criteria in the configuration file, allowing you to include or exclude specific
data based on conditions such as table names or column values.
46. What are performance bottlenecks in GoldenGate?
Ans:Performance bottlenecks in Golden Gate can arise from factors like
network latency, resource limitations, configuration inefficiencies, high
transaction rates, or inadequate hardware.
47. Describe the Golden Gate heartbeat mechanism.
Ans: A periodic signal between the source and target databases to
confirm that the replication processes are running and the connection is
active. It helps detect failures and ensures data consistency.
48. Recommend disaster recovery strategies for GoldenGate.
Ans: Disaster recovery strategies for Golden Gate include setting up
active-passive configurations, real-time data replication to a secondary site,
regular backups, and ensuring failover and failback procedures are
well-defined.
49. What databases can Oracle Golden Gate replicate data between?
Ans: Oracle Golden Gate can replicate data between various databases,
including Oracle Database, Microsoft SQL Server, IBM Db2, MySQL, and others,
supporting both homogeneous and heterogeneous replication.
50. What’s the purpose of checkpoints in GoldenGate?
Ans:The purpose of checkpoints in Golden Gate is to mark a specific
point in time up to which data changes have been successfully applied to the
target database. They play a crucial role in ensuring data consistency and
integrity during replication.
51. How does Oracle Golden Gate handle data compression during
replication?
Ans: Oracle Golden Gate supports data compression natively, allowing you
to reduce network bandwidth usage and improve replication performance. It uses
various compression algorithms and techniques to minimize data transfer size.
52. What is Oracle Golden Gate Veridata used for?
Ans: Veridata is a tool used for data comparison and validation. It
helps ensure data consistency between source and target databases during
replication, detecting and resolving discrepancies.
53. What is the Oracle Golden Gate Microservices architecture?
Ans: A modern deployment option that separates Golden Gate components
into microservices, making it more flexible and scalable. It simplifies
administration and enhances overall manageability.
54. How can you monitor GoldenGate’s performance in real time?
Ans: You can monitor Oracle Golden Gate performance in real-time using
tools like Oracle Enterprise Manager (OEM) or built-in Golden Gate Monitor.
These tools provide detailed metrics, logs, and dashboards to track replication
performance.
55. What is Oracle GoldenGate’s role in data warehousing?
Ans: Oracle Golden Gate plays a crucial role in data warehousing by
enabling real-time or near-real-time data replication from operational
databases to data warehouses.
56. How does Golden Gate support the replication of transactional data?
Ans: Golden Gate captures changes in the source database.
It transforms and formats data for compatibility.
Data is transmitted in real-time or batch mode.
Ensures minimal latency for near real-time replication.
57. What’s the difference between active-active and active-passive
replication in GoldenGate?
Ans:Aspect Active-Active
Replication Active-Passive
Replication
Configuration Multiple
databases actively process read and write transactions. A primary database processes read and write transactions, while one
or more standby databases receive replicated data.
Use Case Load-balanced web
applications, high availability, and even distribution of read and write
operations. Disaster recovery,
failover, and reporting purposes where data is replicated for backup or
reporting but not actively processed.
Benefits Load balancing, high
availability, scalability, and even distribution of workloads. Data protection, failover readiness,
reporting, and analytics support.
Challenges Data conflict resolution
is required to maintain consistency. Data
may be read-only in standby databases, and failover processes need to be
carefully managed.
58. How do you troubleshoot lagging replication in Oracle GoldenGate?
Ans:Check Oracle Golden Gate logs for errors and warnings.
Review Extract and Replicat configuration.
Check for resource constraints (CPU, memory, disk).
Optimize source and target database performance.
59. What’s the significance of trail files?
Ans:Trail files serve as a transaction log, ensuring data consistency
and integrity during replication. Trail files are crucial for Golden Gate to
capture, transform, and apply changes between databases.
60 What’s the process for rolling back a failed Golden Gate replication
change?
Ans:Rolling back a failed Golden Gate replication change typically
involves identifying the problematic transaction or change, stopping Golden
Gate replication temporarily, restoring the affected data to its previous
state, and then resuming replication.
61. What are the best practices for securing Oracle Golden Gate configurations?
Ans:Restricting access to Golden Gate components and credentials.
Encrypting network communication between source and target databases.
Implementing strong authentication and authorization mechanisms.
Monitoring and auditing Golden Gate activities for suspicious or
unauthorized access.
62. Explain the term “DDL replication” in Oracle GoldenGate.will the
underlying source and databases behave?
Ans:DDL replication in Oracle Golden Gate refers to the process of
replicating Data Definition Language (DDL) changes, such as table creation,
alteration, or deletion, from the source database to the target database.
63. How does Oracle Golden Gate ensure data consistency in distributed
environments?
Ans:Oracle Golden Gate ensures data consistency in distributed
environments through its log-based change capture and replication mechanism.
64. What is the Golden Gate Monitor and what does it do?
Ans:Golden Gate Monitor is a web-based graphical user interface (GUI)
tool provided by Oracle for monitoring and managing Oracle Golden Gate deployments.
It allows administrators to monitor the status, performance, and health of
their Golden Gate processes, extractors, replicats, and data pump processes in
real time.
65. How does Golden Gate support character set conversion during
replication?
Ans:It supports character set conversion during replication by using the
CONVERTCHARACTER parameter to specify the source and target character sets for
data transformation.
66. After configuring the Oracle Golden Gate integrated capture process
with default settings, I’ve noticed that as the data load increases, the
extract process falls behind by an hour or more, causing a degradation in
database performance. How can you address this performance issue?
Ans:When operating in integrated capture mode, it is crucial to ensure
that you allocate an adequate amount of memory to STREAMS_POOL_SIZE. The recommended practice is to allocate
STREAMS_POOL_SIZE at the instance level and assign the MAX. SGA (System Global
Area) at the Golden Gate process level, as demonstrated below:
SQL> alter system set STREAMS_POOL_SIZE=3G
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 2048, PARALLELISM 4)
By configuring STREAMS_POOL_SIZE at the instance level and setting the
MAX_SGA_SIZE appropriately in the Golden Gate process parameters, you can
optimize memory allocation for the integrated capture process and improve its
performance, ensuring that it can handle increased data loads without lagging
behind.
67. Can you describe Oracle GoldenGate’s support for data masking and
obfuscation?
Ans:Oracle Golden Gate offers data masking and obfuscation through
built-in features like column mapping and transformation to protect sensitive
data during replication.
68. What’s the role of GoldenGate’s Initial Load capability?
Ans:Initial Load capability is used to populate the target database with
existing data before real-time replication begins, ensuring data consistency.
69. How can you monitor and manage Golden Gate remotely using
command-line tools?
Ans:You can monitor and manage Oracle Golden Gate remotely using
command-line tools like GGSCI (Golden Gate Software Command Interface) for
tasks like status checking and configuration updates.
70. Explain the difference between synchronous and asynchronous
replication in Oracle GoldenGate.
Ans: Aspect Synchronous
Replication Asynchronous
Replication
Data Consistency Ensures
strong data consistency between source and target. May result in temporary data inconsistency between source and
target.
Latency Introduces latency in
write operations because they wait for replication to complete. Write operations are faster, with lower
latency, as they don’t wait for replication.
Data Loss Risk Minimal
data loss risk since changes are not acknowledged until replicated. Higher data loss risk because changes are
acknowledged before replication.
Complexity Typically
more complex to set up and manage due to the need for immediate and guaranteed
communication. Often simpler to set up and
manage because it doesn’t require immediate communication.
Oracle Golden Gate Sample Resumes! Download & Edit, Get Noticed by
Top Employers!
71. How does Oracle Golden Gate handle data conflicts in multi-master
replication scenarios?
Ans:Golden Gate handles data conflicts in multi-master replication
scenarios through conflict detection and resolution mechanisms, including
custom scripts, to maintain data consistency.
72. Mention the recommended approach for handling downtime during Golden
Gate upgrades.
Ans:Plan and schedule the upgrade during a maintenance window.
Back up Golden Gate configuration,
trail files, and metadata.
Gracefully stop Golden Gate processes using GGSCI.
Ensure replication activities are complete.
73. Explain GoldenGate’s support for unidirectional and bidirectional
replication.
Ans:Golden Gate supports unidirectional replication by capturing changes
from a source database and applying them to a target. It also supports
bidirectional replication, where changes are captured and applied in both
directions
between source and target databases.
74. How does Oracle Golden Gate deal with changes to table structures in
source databases?
Ans:Using Data Definition Language (DDL) replication, which captures and
replicates these structural changes to the target database, allowing schema
evolution to be synchronized.
75. What are the considerations for optimizing performance in a
high-transaction environment?
Ans:Considerations for optimizing Oracle Golden Gate performance in a
high-transaction environment include tuning parameters, minimizing network
latency, increasing bandwidth, using parallel processing, and optimizing the
database for efficient change capture.
76. What are some alternatives to Golden Gate for database replication
and synchronization?
Ans:Tools like SQL Server Replication, MySQL Replication, PostgreSQL’s
logical replication, and third-party solutions like SharePlex and Attunity are
alternatives to Oracle Golden Gate for database replication and
synchronization.
77. What’s the primary role of the Oracle Golden Gate Capture process?
Ans:It captures data changes, such as inserts, updates, and deletes,
from the source database’s transaction logs or redo logs.
It converts these captured changes into a platform-independent, logical
format called the “trail.”
The trail contains a record of all the changes made to the source
database tables.
The Capture process ensures that the changes are captured in the order
they occurred, and it maintains data consistency and integrity during the
replication process.
78. Explain Oracle GoldenGate’s support for database upgrades and
migrations.
Ans:Enabling continuous data replication from the old source database to
the new target database.
Minimizing downtime during the upgrade process.
Facilitating a seamless switch to the new database once replication is
up-to-date.
Reducing disruption to business operations during the upgrade.
79. What’s the significance of the Extract and Replicat parameter files
in Golden Gate configurations?
Ans:The Extract and Replicat parameter files in Golden Gate configurations
are crucial as they contain configuration settings and instructions for data
extraction and replication processes. These files define how data is captured
from the source and applied to the target, making them fundamental to the
functioning and behavior of Golden Gate replication.
80. How does Golden Gate support data filtering based on specific
criteria?
Ans:In order to capture and replicate only the appropriate data, Golden
Gate provides data filtering through the Extract and Replicat procedures.
81. Describe the concept of “pump” processes in Oracle GoldenGate.
Ans:The pump processes in Oracle Golden Gate are in charge of moving
trail data around the system. They ensure effective data transfer and
replication in spread contexts and include Local Extract Pump, Remote Extract
Pump, and Replicat Pump.
82. What role does the Golden Gate Collector process play in replication
architectures?
Ans:Gathers data from Golden Gate Extract processes.
Consolidates data into a single stream.
Balances data load among Extract processes.
Forwards data to target databases.
Supports high availability configurations.
83. How does Golden Gate handle the replication of database sequences
and triggers?
Ans:Golden Gate replicates database sequences and triggers by capturing
and applying the SQL statements responsible for their changes in the source
database.
84. How does Oracle Golden Gate handle changes to column data types in
source tables?
Ans:Oracle Golden Gate handles changes to column data types by using
column mapping and transformation functions to ensure the data is transformed
appropriately during replication.
85. What’s the purpose of the Oracle Golden Gate Data Pump utility?
Ans:The Data Pump utility is used for initial data loading, bulk data
movement, and data extraction from source databases into target databases.
86. What’s the recommended strategy for testing and validating Golden
Gate configurations?
Ans:The recommended strategy for testing and validating Oracle Golden
Gate configurations involves using a separate test environment that mirrors the
production setup to ensure the accuracy and reliability of replication.
87. How can you ensure high availability for Golden Gate processes and
components?
Ans:High availability for Oracle Golden Gate processes and components
can be achieved through redundancy, failover mechanisms, and monitoring tools
to ensure continuous data replication and minimal downtime.
88. Explain the role of the Oracle Golden Gate Credential Store feature.
Ans:Store feature securely stores credentials, keys, and passwords used
by Oracle Golden Gate processes, enhancing security and simplifying credential
management.
89. How Integrated Capture differ from Classic Capture?
Ans:Oracle Golden Gate Integrated Capture is an integrated and more
efficient capture mechanism compared to Classic Capture, which is older and has
a separate capture process. Integrated Capture is the preferred method for
Oracle Database.
90. What are the various modes of Oracle Golden Gate operation?
Ans:Oracle Golden Gate operates in various modes, including
Classic capture and integrated capture
Batch and online modes
Uni-directional and bi-directional modes
91. What is Change Data Capture (CDC) in the context of GoldenGate?
Ans:CDC refers to the process of capturing and replicating changes made
to data in source tables, ensuring data consistency between source and target
databases.
92. What are the different types of capture methods in Oracle
GoldenGate?
Ans:Oracle Golden Gate supports various capture methods, including
Log-Based Capture (CDC)
Trigger-Based Capture
Direct Bulk Capture
93. How can you optimize the initial load process?
Ans:Preprocess and cleanse data
Use parallel processing
Employ bulk loading techniques
Minimize indexes and constraints temporarily
Implement Change Data Capture (CDC)
Schedule load during low activity
94. What is the role of the Integrated Capture feature?
Ans:Integrated Capture is a feature that captures data changes directly
from database redo logs, eliminating the need for a separate Extract process
and enhancing performance.
95. How does the Pump process fit into the Golden Gate architecture, and
what is its purpose?
Ans:Pump processes move captured data between components in GoldenGate,
ensuring efficient data transfer between Extract and Replicat processes in
distributed environments.
96. What are the responsibilities of the Receiver process?
Ans:The Receiver process receives trail data on the target side, manages
conflict resolution, and ensures the data is applied correctly to the target
database.
97. What are the key features of Oracle Golden Gate Monitor?
Ans:Real-time monitoring
Alerting and notifications
Performance metrics tracking
Security auditing and reporting
Historical data analysis
Golden Gate interview questions and answers
What are the main components of the Golden Gate replication?
The replication configuration consists of the following processes.
Manager
Extract
Pump
Replicate
What are the supplemental logging pre-requisites?
The following supplemental logging is required.
Database supplemental logging
Object level logging
Is there a separate background process for writing flashback logs?
Yes. RVWR (Recovery Writer, Flashback Writer) was introduced in Oracle
10g to write flashback data from the Flashback Buffer in the SGA to the
flashback database logs on disk.
Oracle Golden Gate
What command can be used to switch writing the trail data to a new trail
file?
You can use the following command to write the trail data to a new trail
file.
SEND EXTRACT ext_name, ROLLOVER
What happens if RVWR cannot write to disk?
It depends on the context where the write error occurs:
If there’s a Guaranteed Restore Point, the database crashes to ensure
the restore point guarantee is not voided.
If there isn’t a Guaranteed Restore Point and it’s a primary database,
the Flashback Mode will be automatically turned off for the database, which
will continued to operate normally.
If there isn’t a Guaranteed Restore Point and it’s a standby database,
the database will hang until the cause of the write failure is fixed.
How is the RESTARTCOLLISION parameter different from HANDLECOLLISIONS?
The RESTARTCOLLISION parameter is used to skip ONE transaction only in a
situation when the Golden Gate process crashed and performed an operation
(INSERT, UPDATE & DELETE) in the database but could not checkpoint the
process information to the checkpoint file/table. On recovery it will skip the
transaction and AUTOMATICALLY continue to the next operation in the trail file.
When using HANDLECOLLISION Golden Gate will continue to overwritten and
process transactions until the parameter is removed from the parameter files
and the processes restarted.
Do I need to shutdown and mount the database to turn flashback on?
ALTER DATABASE FLASHBACK ON is an online operation in 11g Release 2. In
10g Release 2 the database must be mounted, but not open.
Once flashback is turned on Oracle starts to save the before-images of
the database blocks before they are changed. This guarantees that the database
can be flashbacked to the exact point-in-time when the flashback mode was
turned on.
What are the basic resources required to configure Oracle Golden Gate high
availability solution with Oracle Clusterware?
There are 3 basic resources required:
Virtual IP
Shared storage
Action script
What transaction types does Golden Gate support for Replication?
Golden Gate supports both DML and DDL Replication from the source to
target.
Is there a way to check the syntax of the commands in the parameter file
without actually running the Golden Gate process
Yes, you can place the SHOWSYNTAX parameter in the parameter file and
try starting. If there is any error you will see it.
How can you increase the maximum size of the read operation into the
buffer that holds the results of the reads from the transaction log?
If you are using the Classical Extract you may use the TRANSLOGOPTION
ASMBUFSIZE parameter to control the read size for ASM Databases.
What information can you expect when there us data in the discard file?
When data is discarded, the discard file can contain:
Discard row details
Database Errors
Trail file number
How to list restore points in RMAN?
In RMAN you can use the LIST RESTORE POINT [ALL|restore_point_name]
command. If you use a recovery catalog you can use the view RC_RESTORE_POINT in
the recovery catalog repository, or the command the V$RESTORE_POINT in the
target database.
What database does Golden Gate support for replication?
How can you determine if the parameters for a process was recently
changed
Whenever a process is started, the parameters in the .prm file for the
process is written to the process REPORT. You can look at the older process
reports to view the parameters which were used to start up the process. By
comparing the older and the current reports you can identify the changes in the
parameters.
What is the Future of the Oracle GoldeanGate
How should I set the database to improve Flashback performance?
Oracle’s recommendations are:
Use a fast file system for your flash recovery area, preferably without
operating system file caching. It is recommended to use a file system that
avoids operating system file caching, such as ASM.
Configure enough disk spindles for the file system that will hold the
flash recovery area. For large production databases, multiple disk spindles may
be needed to support the required disk throughput for the database to write the
flashback logs effectively.
If the storage system used to hold the flash recovery area does not have
non-volatile RAM, try to configure the file system on top of striped storage
volumes, with a relatively small stripe size such as 128K. This will allow each
write to the flashback logs to be spread across multiple spindles, improving
performance
For large, production databases, set the init.ora parameter LOG_BUFFER
to be at least 8MB. This makes sure the database allocates maximum memory
(typically 16MB) for writing flashback database logs.
List few useful Logdump commands to view and search data stored in OGG
trail files.
Below are few logdump commands used on a daily basis for displaying or
analyzing data stored in a trail file.
$ ./logdump – to connect to the logdump prompt
logdump> open /u01/app/oracle/dirdat/et000001 – to open a trail file
in logdump
logdump> fileheader on – to view the trail file header
logdump> ghdr on – to view the record header with data
logdump> detail on – to view column information
logdump> detail data – to display HEX and ASCII data values to the
column list
logdump> reclen 200 – to control how much record data is displayed
logdump> pos 0 – To go to the first record
logdump> next (or simply n) – to move from one record to another in
sequence
logdump> count – counting records in a trail
How would you comment out a line in the parameter file?
You can use the “–” character to comment out a line
1. How Can You See Golden Gate Errors?
Answer :Yes We Can See The Golden Gate Error By Following These Simple
Steps :
Ggsci> VIEW GGSEVT
Ggserr.Log File
2.How Do You Take Backup Of GoldenGate?
Answer : The Backup Process For Oracle Golden Gate Is Basically
Performed By Utilizing The Working Framework Cp Order. The Reinforcement Ought
To Incorporate The Root Index And Sub-Catalogs. The Sub-Indexes Incorporate The
Boundary Documents And Other Related Records. Utilizing The €”R Choice
Recursively Reinforcement The Sub-Indexes. (Oracle Golden Gate Interview
Questions)
3. Distinguish Between Classical Extract And Integrated Extract?
Answer : Classical Extract: The Classic Extract Mode Is The Conventional
Extract Measure That Gets To The Information Base Re-Try Logs (Alternatively
Document Logs) To Catch The DML Changes Happening On The Articles Indicated In
The Boundary Records. There Are Some Information Types That Are Not Upheld In
Classic Capture Mode. Classical Extract Can’t Peruse Information From The
Packed Tables/Tablespaces. These Golden Gate Interview Questions Will Be Very
Helpful. You Can Enrol For Our Golden Gate Training Which Will Help You To
Learn Advanced Concepts.
Integrated Extract: In The Integrated Extract Mode, Golden Gate Works
Straightforwardly With The Information Base Log Mining Worker To Get The
Information Changes As Intelligent Change Records (LCRs). IC Mode Doesn’t Need
Any Uncommon Arrangement For The Information Bases Utilizing ASM,
Straightforward Information Encryption, Or Oracle RAC.
4. What Type Of Topology Does Golden Gate Support?
Answer : The Topology Supported By Golden Gate Are Unidirectional,
Bidirectional, Peer-To-Peer , Broadcast , Consolidation , Cascading.
5. What Is The Data Pump Process In Goldengate?
Answer : The Data Pump Is A Discretionary Optional Extract Bunch That Is
Made On The Source Framework. At The Point When Data Pump Isn’t Utilized, The
Extract Cycle Keeps In Touch With A Far Off Path That Is Situated On The
Objective Framework Utilizing TCP/IP. Golden Gate Interview Questions The
Benefits Of This Be It Ensures Against An Organization Disappointment As
Without A Capacity Gadget On The Neighborhood Framework, The Extract Cycle
Composes Information Into Memory Before The Equivalent Is Sent Over The
Organization. Any Disappointments In The Organization Could Then Reason The
Extract Cycle To Prematurely End (Abend). Likewise, In The Event That We Are
Doing Any Mind Boggling Information Change Or Sifting, The Equivalent Can Be
Performed By The Data Pump.
6.When Making A Golden Gate Info User For Info 12c, What Special
Precaution Does One Got To Take?
Answer : You Should Permit The Golden Gate Administrator Shopper
Admittance To All Or Any Info Base Holders On The Supply Aspect With The Goal
That Golden Gate Will Get To The Re-Try LogsYou Must Additionally Grant The DBA
Role With The Container=All Choice. ( Oracle Golden Gate Tutorial Will Level Up
Your Skills For Better Understanding The Subject )
7.What Is Suplimental Work And Why It’s Needed For Gg Replication?
Answer : About Suplimental Logging: Supplemental Work As Name Suggests
Is Further Work, Needed To Unambiguously Distinguishing A Row On Course Info
Once A Row Is Updated/Deleted From Supply Info.Once A Row Is Updated / Deleted
From The Supply, Golden Gate Replicat Method Searches For Constant Row On
Course Supported Column Supplementally Logged Before The Dealings May Well Be
Applied.Supplemental Work Levels: Golden Gate Interview Questions There Is 2
Level Of Supplemental Logging:Supplemental Work Is Needed By Every Amendment
Knowledge Capture (CDC) Tool.Golden Gate Being Government Agency Tool Therefore
It Additionally Needs Supplemental Work To Be Enabled So As That Rows Updated
On Supply Area Unit Usually Unambiguously Known At Target And Updated.
8.Where The Filtering Of Information For A Column Cans Will Be
Configured?
Answer : Filtering Of The Columns Of A Table Is Commonly Set At The
Extract, Pump Or Replicat Level.Explore The Journal Post On Oracle Golden Gate Coaching
To Become An Expert In Oracle GoldenGate.Is It A Demand To Tack A PUMP Extract
Method In Oracle Golden Gate Replication?PUMP Extract Is Associate Degree
Choice, However It’s Extremely Counseled To Use This To Safeguard Against
Network Failures.Unremarkably It’s Organized Once You’re Fixing Oracle Golden
Gate Replication Across The Network.
9.How Will We Tend To Confirm The Parameters For A Method Was Recently
Changed?
Answer : Whenever A Method Is Started, The Parameters Inside The Prm
File For The Tactic Is Written To The Tactic REPORT.You’ll Look Into The Older
Method Reports To Seem At The Parameters That Golden Gate Interview Questions
Were Accustomed Begin The Tactic.By Comparison The Older And So The Present
Reports You May Establish The Changes Inside The Parameters.
10.How To List Out The Restore Points In RMAN?
Answer : In RMAN You May Use The LIST RESTORE Purpose
[ALL|Restore_point_name] Command.If You Use A Recovery Catalog You May Use The
Read RC_RESTORE_POINT Inside The Recovery Catalog Repository, Or Command The
V$RESTORE_POINT Inside The Target Info. Golden Gate Interview Questions
Provided By SVR Technologies Will Help You To Crack The Interview
11.How Can I Set The Info To Boost Flashback Performance?
Answer : Here Area Unit A Number Of The Issues You Want To Inspect It To
Boost Performance:Use A Fast Classification System For Your Flash Recovery
Space, Ideally While Not OS File Caching.It’s Counseled To Use A Classification
System That Avoids OS File Caching, Like ASM.Configure Enough Disk Spindles For
The Classification System Which Is Able To Hold The Flash Recovery Space.For
Large Golden Gate Interview Questions Production Databases, Multiple Disk
Spindles May Even Be Required To Support The Desired Disk Turnout For The Info
To Write Down Down The Flashback Logs Effectively.If The Storage System
Accustomed Hold The Flash Recovery Space Does Not Have Non-Volatile RAM, Plan
To Tack The Classification System On High Of Patterned Storage Volumes, With A
Relativelythis Might Permit Every Pen The Flashback Logs To Be Unfold Across
Multiple Spindles, Rising Performancefor Large, Production Databases, Set The
Init.Ora Parameter LOG_BUFFER To Be A Minimum Of 8MB.This Makes Positive The
Info Allocates Most Memory (Typically 16MB) For Writing Flashback Info Logs. (Golden
Gate Interview Questions)
12.What Is Ggsci?
Answer : Golden Gate Instruction Interface Essential Commands – GGSCI
GGSCI — (Oracle) Golden Gate Software Command Interpreter
13.What Are Macros?
Answer : Macro Is A Neater Thanks To Build Your Parameter File. Once A
Macro Is Written It Are Often Called From Different Parameter Files. Common
Parameters Like Username/Password And Other Parameters Are Often Included In
These Macros.
14.How Is A Macro Defined?
Answer : A Macro Statement Consists Of The Following.
• Name Of The Macro
• Parameter List
• Macro Body
Frequently Asked Golden Gate Interview Questions
15.What Are The Different Encryption Levels In AES?
Answer : You Can Encrypt The Password/Data Using The AES In Three
Different Keys As Follows
• 128 Bit
• 192 Bit And
• 256 Bit
16.What Is The Task Of The DBWR Method And The Way Several DBWR
Processes Square Measure There?
Answer : DBWR Means, Info Author Is Very Answerable For Writing Changed Blocks(Ie.Dirty
Blocks) To The Physical Knowledge Files(Disks).An Excessive Quantity Of Dirty
Buffers In Buffer CacheTable House Being Born (Or)Taken Offline(Or) Placed In
Browse Solely Mode, (Or) In Hot Backup Mode.When The Supply And So The Target
Schema Objects Are Not Constant (Different DDL) The Replicat Golden Gate Interview
Questions Method Should Grasp The Supply Definition Of The Objects.The Output
From The DEFGEN Utility Is Utilized In Conjunction With The Path Knowledge To
Figure Out That Column Worth Inside The Path Belongs To That Column.(Golden
Gate Interview Questions)
17.How Is That The RESTARTCOLLISION Parameter Completely Different From
HANDLECOLLISIONS?
Answer : The RESTARTCOLLISION Parameter Is Utilized To Skip ONE Dealing
Solely Throughout A State Of Affairs Once The Golden Gate Method Crashed
Associate Degreed Performed An Operation (INSERT, UPDATE & DELETE)Inside
The Info However Could Not Stop The Tactic Data To The Stop File/Table.On
Recovery It’s Going To Skip The Dealing And Mechanically Still Later Operation
Inside The Golden Gate Interview Questions Path File.Once Victimization
HANDLECOLLISIONS Golden Gate Can Still Write And Method Transactions Till The
Parameter Is Much Far From The Parameter Files And So The Processes Restarted.
18.How Will We Have A Tendency To Report On Long Running Transactions?
Answer : The WARNLONGTRANS Parameter Square Measure Typically Mere With
A Threshold Time That A Dealing Square Measure Typically Open Before Extract
Writes A Warning Message To The Ggs Error Log (Golden Gate Interview Questions)
19.Why Would You Segregate The Tables In An Exceedingly Replication
Configuration?
Answer : In OGG You May Tack Replicat At The Data At The Schema Level Or
At The Table Level Victimization TABLE Parameter Of Extract And MAP Parameter
Of Replicat.For Replicating The Complete Info You May List All The Schemas
Inside The Info Inside The Extract/Replicat Parameter File Or Else You May
Conjointly A Collection Of Tables Inside TheAlternatively You May Need To Take
Away Tables That Have Long Running Transactions Throughout A Separate Extract
Method To Eliminate Lag On The Alternative Tables.Let’s Say Merely|That You
Just} Simply Have A Schema Named SCOTT And Its A Hundred Hundred Tables.Out Of
These Hundred Tables, Fifty Tables Square Measure Heavily Used By
Application.Oracle Can Decide To Keep The Utmost Quantity Flashback Logs PRN To
Satisfy The DB_FLASHBACK_RETENTION_TARGET Parameter.However, If There’s House
Pressure Inside The Flash Recovery Space (FRA), Flashback Logs Might Even Be
Deleted To Create Space For Alternative Things, Like Backups And Archived
Logs.(Latest Golden Gate Interview Questions)
20.What Is The Distinction Between Classic And Coordinated Replicat?
Answer : The Distinction Between Classic Mode And Coordinated Mode Is
That Replicat Is Multi-Threaded In Coordinated Mode.Inside One Replicated
Instance, Multiple Threads Browse The Path Severally And Apply Transactions In
Parallel.Every Thread Handles All Of The Filtering, Mapping, Conversion, SQL
Construction, And Error Handling For Its Allotted Employment.
21.How To List Restore Points In RMAN?
Answer : In RMAN You May Use The LIST RESTORE Purpose
[ALL|Restore_point_name] Command. If You Utilize A Recovery Catalog You May Use
The Read RC_RESTORE_POINT Among The Recovery Golden Gate Interview Questions
Catalog Repository, Or The Command The V$RESTORE_POINT Among The Target Info.
22.How Will Instance Recovery Add Associate Oracle Database?
Answer : When Associate Instance Terminated As Abnormally Or Crashed The
Info Goes Down In Associate Inconsistent State Which Means All Current
Transactions Committed Or Uncommitted Weren’t Completed. Therefore Before It’s
Usually Opened, The Info Should Be Throughout An Even Mode. Thus SMON Performs
A Important Role In Convalescent The Info. Oracle Uses The Last SCN Among The
Management File And May Apply Committed Or Uncommitted Transactions From Redo
Logs, That Is Known As Roll Forward. Throughout This State Info Is In MOUNT
State. Info Then Checks Golden Gate Interview Questions The Accessibility Of
UNDO Segments And Opens The Info. Currently Uncommitted Transactions Square
Measure Rolled Back With The Help Of UNDO, That Is Called ROLL BACK.
23.What Is BATCHSQL Mode ?
Answer : In BATCHSQL Mode, Replicat Organizes Similar SQL Statements
Into Batches Among A Memory Queue, Then It Applies Everyte. Golden Gate Process
Works Supported Parameters Defined In Parameter Files. Every Process In Golden
Gate Has Its Own Parameter File. [Golden Gate Interview Questions ]
24.What Is CDR In Golden Gate?
Answer : Oracle Golden Gate Conflict Detection Associate Degreed
Determination (CDR) Provides Basic Conflict Resolution Routines That: Resolve A
Singularity Conflict For An INSERT . Resolve A “No Information Found” Conflict
For Associate Degree UPDATE Once The Row Exists, However The Before Image Of
One Or Additional Columns Is Totally Different From The Current Price At
Intervals The Info.Golden Gate Has Addressed This Issue Through The Use Of The
BATCHSQL Configuration Parameter For The Replicat Method. BATCHSQL Segregates
Similar SQL Statements Into Batches And Golden Gate Interview Questions Applies
All Of Them Directly. Similar SQL Statements Ar Those That Perform A Specific
Operation Sort (Insert, Update, Or Delete) Against The Same Target Table With
The Same Column List.
25.Why Does One Ought To Increase Price Of UNDO_RETENTION Parameter
Whereas Putting In Place GoldenGate?
Answer : It Is Needed To Increase The UNDO_RETENTION Price So As That Golden
Gate Will Maintain A Read-Consistent Row Image For A Specific Time Or SCN To
Match The Redo Record. Please Note That Oracle Golden Gate Interview Questions
12c Uses Flashback Question To Urge All The Values From The Undo Records. For
Special Info Objects Like User-Defined Sorts, Nested Tables Etc. Increasing
UNDO_RETENTION Can Ensure That Golden Gate Is In A Very Position To Satisfy The
Goal Of Scan Consistency.(Golden Gate Interview Questions And Answers)
26.Explain High Level Steps Of Golden Gate ?
Answer : Below Area Unit The Key Steps To Install/Configure The Golden
Gate System.
Download The Package From The Oracle Web Site And Transfer To Server
Unpack/Unzip The Installation Nada File
Prepare Supply And Target System
Install The Package On The Supply And Target System (For 12c Use OUI)
Prepare The Supply Information (Some Decibel Parameters Ought To Be
Adjusted) Tack Together The Manager Method On The Supply And Target System
Configure The Extract Method On The Supply System
Configure The Information Pump Method On The Supply System
Configure The Replicat Method On The Target System
Start The Extract Method
Start The Information Pump Method
Start The Replicat Method
27.How Ought To I Set The Information To Enhance Flashback Performance?
Answer : Here Square Measure A Number Of The Issues You Need To
Investigate It To Enhance Performance:
Golden Gate Interview Questions Use A Fast Classification System For
Your Flash Recovery Space, Ideally While Not OS File Caching. It’s Counseled To
Use A Classification System That Avoids OS File Caching, Like ASM.
Configure Enough Disk Spindles For The Classification System Which Is
Able To Hold The Flash Recovery Space. For Large Production Databases, Multiple
Disk Spindles Might Even Be Required To Support The Desired Disk Output For The
Information To Write Down Down The Flashback Logs Effectively.If The Storage
System Accustomed Hold The Flash Recovery Space Does Not Have Non-Volatile RAM,
Arrange To Put Together The Classification System On High Of Patterned Storage
Volumes, With A Relatively.(Golden Gate Interview Questions 2020)
28.What Is Suplimental Logging Work And Why It’s Needed For Gg
Replication?
Answer : About Suplimental Logging: Supplemental Work As Name Suggests
Is Further Work, Needed To Unambiguously Characteristic A Row Heading In The
Right Direction Info Once A Row Is Updated/Deleted From Supply Info. Once A Row
Is Updated / Deleted From The Supply, Golden Gate Replicat Method Searches For
A Similar Row Heading In The Right Direction Supported Column Supplementally
Logged Before The Dealing May Be Applied.
Supplemental Work Levels: There Is 2 Level Of Supplemental Logging:
Info Level
Table Level
Supplemental Work Is Needed By Every Modification Knowledge Capture
(CDC) Tool. Golden Gate Being Federal Agency Tool Therefore It Additionally
Needs Supplemental Work To Be Enabled So As That Rows Updated On Supply Square
Measure Usually Unambiguously Known At Target And Updated. One Of The Reasons
To Modify Supplemental Work Is To Urge Modification Logs For The Update And
Delete Statements. Supplemental Work Makes Positive That Enough Data Is
Captured Throughout This Updates And Deletes Which Can Use By Any Methodology
Supported Logminer Technology. Since Golden Gate Could Also Be A SQL Apply
Therefore Once A Row Is Updated Or Deleted From The Supply, Golden Gate Replicat
Method Searches For A Similar Row Heading In The Right Direction On That
Update/Delete Should Be Performed. Golden Gate Interview Questions
29.List Out Some Of The Important Considerations For Bi-Directional
Replication?
Answer : Here Are Some Of The Important Considerations For
Bi-Directional Replication Mentioned Below: The Customer Should Consider The
Subsequent Points In An Active-Active Replication Environment.
• Primary Key: Helps To Spot Conflicts And Resolve Them.
• Sequences: Aren’t Supported. The Work Around Is To Use Odd/Even, Range
Or Concatenate Sequences.
• Data Looping: This Will Easy Avoided Using OGG Itself
• LAG: This Could Be Minimized. If A Customer Says That There’ll Not Be
Any LAG Thanks To Network Or Huge Load, Then We Don’t Got To Deploy CRDs. But
This Is Often Not The Case Always As There Would Be Some LAG And These Can
Cause Conflicts.
• CDR (Conflict Detection & Resolution): OGG Has Inbuilt CDRs For
All Types Of DMLs Which Will Be Wont To Detect And Resolve Them.
• Packaged Application: These Aren’t Supported Because It May Contain
Data Types Which Aren’t Supported By OGG Or It’d Not Allow The Appliance
Modification To Figure With OGG
30.What Is The Purpose Of The DEFGEN Utility?
Answer : When The Source And Therefore The Target Schema Objects Aren’t
An Equivalent (Different DDL) The Replicat Process Must Know The Source
Definition Of The Objects. The Output From The DEFGEN Utility Is Employed In
Conjunction With The Trail Data To Work Out Which Column Value Within The Trail
Belongs To Which Column.The Above Mention Golden Gate Interview Questions Will
Help You To Ace From Beginner Level To An Advanced Level.
Basic troubleshooting
===============================
ERROR
OGG-00303 Oracle GoldenGate Manager for Oracle, mgr.prm:
Unable to connect to database using user c##gg_user. Ensure that the necessary
privileges are granted to the user.
CAUSE: the user c##gg_user doesn't exist in the database or doesn't
have the proper privileges.
SOLUTION: create the user and grant privileges as described in the
"Database setup" chapter.
***
UDE-31623:
operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
CAUSE: When using Data Pump Export utility, you may get this error.
It's caused by a low memory in the streams_pool_size of the oracle memory SGA.
SOLUTION: Connect as sysdba to the container database and run the
following command. Then repeat the expdp again.
1.
SQL> alter system set streams_pool_size=128M;
2.
System altered.
***
ORA-12154:
TNS:could not resolve the connect identifier specified
or
ORA-12543: TNS:destination host unreachable
CAUSE: There is a network issue or the database couldn't be found.
Check first the virtual machine has the network adapters ready and ifconfig
returns the IP address.
SOLUTION: if ifconfig doesn't show the IP address we set up in
tnsnames.ora, disconnect the network and connect it again -- see video--
***
ORA-65096: invalid
common user or role name
CAUSE: You must create the user in the pluggable database.
SOLUTION: check if you're creating in in the container database
instead.
***
OGG-02091
Operation not supported because enable_goldengate_replication is not set to
true.
connect to sqlplus
as sysdba and enable the GoldenGate parameter with the following syntax:
CAUSE: The parameter enable_goldengate_replication is set to false
SOLUTION: Set the parameter to true
1.
SQL> alter system set
enable_goldengate_replication=true;
2.
System altered.
***
ERROR
OGG-02058 The Oracle source database is not configured properly to
support integrated capture. The following configuration error must be
fixed: ARCHIVELOG mode must be enabled on this Oracle database.
CAUSE: The database is in NOARCHIVELOG mode
SOLUTION: Enable archivelog in the database before set up the
extract process.
***
ERROR
OGG-00446 Oracle GoldenGate Delivery for Oracle, rep1.prm:
Checkpoint table orcl.c##gg_user.checkpoint does not exist. Create this table
with the ADD CHECKPOINTTABLE command.
CAUSE: the checkpoint table does not exist as the defined name shown.
SOLUTION: Ensure the process definition and the checkpoint table
have the exact same name.
***
ERROR
OGG-02022 Oracle GoldenGate Capture for Oracle, ext1.prm:
Logmining server does not exist on this Oracle database.
CAUSE: When a extract process can't access the Logmining database it's
mainly for a strange limitation to only one extract for each pluggable database
or because the extract process was not properly registered in the database.
SOLUTION: check if extract is registered and you have only one for
pluggable database (pump extract doesn't count, as the source is the dirdat
directory instead of the integrated log).
***
ERROR
OGG-15312 Oracle GoldenGate Command Interpreter for Oracle:
Cannot obtain database version information because verification of database
login failed with next error: Not logged into database, use DBLOGIN.
CAUSE: login failed, not logged in
SOLUTION: check dblogin syntax and perform a proper login with the correct
user and password.
***
ERROR
OGG-00396 Oracle GoldenGate Capture for Oracle, pump.prm:
Command 'TABLE' not terminated by semi-colon.
CAUSE: In the parameter file, the TABLE clause doesn't end with a
semi-colon.
SOLUTION: add a semi-colon to the TABLE clause
***
ERROR
OGG-01224 Oracle GoldenGate Capture for Oracle, pump.prm:
TCP/IP error 111 (Connection refused), endpoint: moore:7809.
CAUSE: Something is wrong with the network. Check the servers have the
virtual network card enabled, with IP assigned and check also the laptop has
connection to internet (is a common failure that the virtual network can get
frozen if there is no internet way out in the host computer).
SOLUTION: check and fix the network adapters in the virtual servers,
check ifconfig and check the computer network connection to internet to fix it.
***
ERROR
OGG-02650 Oracle GoldenGate Capture for Oracle, pump1.prm:
Source wildcard specification hr.* does not include a catalog name, but the
source table name ORCL.HR.EMPLOYEES includes a catalog name.
CAUSE: when specifying a SOURCECATALOG you don't have to prefix the
pluggable database in the table definition.
SOLUTION: remove the ORCL. prefix
'**
ERROR
OGG-01044 Oracle GoldenGate Capture for Oracle, pump.prm: The
trail '/u01/app/oracle/product/OGG/dirdat/pu' is not assigned to extract
'PUMP'.
Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL
/u01/app/oracle/product/OGG/dirdat/pu, EXTRACT PUMP".
CAUSE: the trail directory in the parameter file and the ADD
EXTRAIL directory don't match
SOLUTION: fix the parameter file or delete and create the extract
process again.
***
ERROR
OGG-01780 Oracle GoldenGate Command Interpreter for Oracle:
Missing/Invalid argument(s) on UNREGISTER command.
CAUSE: if you unregister a process, you have to provide the clause
DATABASE
SOLUTION: use the following syntax: (process and name as
proceed)
1.
unregister extract
ext1, database
2.
***
ERROR
OGG-02058 Oracle GoldenGate Command Interpreter for Oracle:
The Oracle source database is not configured properly to support integrated
capture.
The following configuration error must be fixed: ARCHIVELOG mode must be
enabled on this Oracle database.
CAUSE: The database is in NOARCHIVELOG mode.
SOLUTION: follow the steps in the chapter "Set up the database
logging" and set database in ARCHIVELOG mode.
***
ERROR
OGG-08241 Oracle GoldenGate Command Interpreter for Oracle:
ERROR: This EXTRACT EXT1 is already registered with the database.
CAUSE: The process is already registered in the database.
SOLUTION: unregister it first if you need to create it from scratch, or
ignore if it's properly ok registered.
***
ERROR
OGG-00199 Oracle GoldenGate Delivery for Oracle, rep2.prm:
Table orcl.hr.EMPLOYEES_CLONE does not exist in target database.
CAUSE: One table doesn't exist in the database
SOLUTION: Create it as the SCN affected and put it in place. Retry to
start the process again.
Comments
Post a Comment