Oracle GoldenGate Interview Questions
1. How can you see GoldenGate errors?
Answer :Yes We Can See the Goldengate 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 GoldenGate 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 GoldenGate Interview Questions) know more at Oracle golden gate training
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 Goldengate interview questions will be very helpful. You Can Enrol for our Goldengate Training which will help you to learn advanced concepts.
Integrated Extract: In the Integrated Extract mode, GoldenGate 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 Goldengate support?
Answer : The Topology supported by goldengate 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. GoldenGate 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 GoldenGate info user for info 12c, what special precaution does one got to take?
Answer : You should permit the GoldenGate administrator shopper admittance to all or any info base holders on the supply aspect with the goal that GoldenGate will get to the re-try logsYou must additionally grant the role with the container=all choice. ( oracle 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, GoldenGate Replicat method searches for constant row on course supported column supplementally logged before the dealings may well be applied.Supplemental work Levels: GoldenGate Interview Questions there is 2 level of supplemental logging:Supplemental work is needed by every amendment knowledge Capture (CDC) tool.GoldenGate 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. know more at Oracle golden gate online training
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 GoldenGate coaching to become an expert in Oracle GoldenGate.Is it a demand to tack a PUMP extract method in Oracle GoldenGate 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 GoldenGate 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 GoldenGate 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. GoldenGate Interview Questions Provided by 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 GoldenGate 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. (GoldenGate Interview Questions)
12.What is ggsci?
Answer : Golden Gate instruction Interface essential commands — GGSCI
GGSCI — (Oracle) GoldenGate 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
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 GoldenGate 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.(GoldenGate 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 GoldenGate 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 (GoldenGate Interview Questions) know more at Oracle golden gate training course
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 GoldenGate 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.
