Oracle Golden gate basic

There are different types of golden gate files commonly know as: Log files Parameter files  report files Parameter files:     There are two types of parameter files they are  GLOBALS  Run time parameter files GLOBALS:   The GLOBALS file stores parameters that relate to the Oracle Golden Gate instance as a whole. This is in contrast to runtime parameters, Note:  if a parameter is declared in Global file and as well as run time parameter individual file then golden gate considers the parameter values declared in run time parameters file.   Run Time Parameter Files:   Run time parameter files give control over various accepts of sync and also specific to some process like Extract, pump, Replicat and manager processes   The default location of Run time parameter files is:  : <golden_gate_home_directory>/dirprm The File extensions of run time parameter files are: : ".prm" Some of the run time parameter files example: Extr...

  Components of the golden gate: Source database. Manager process @ source database/target database- manages all GG operations Capture process or Extract process (Local Extract) Source Trail / Trail files @ Source db side Pump process @ source database. Network (high speed network to avoid replication lagging) Remote Trail / Trail files @ Target db side Delivery process or Replicat process Target database. Manager process @ target database. Source Data base: The oracle database or any other database from which the data will be replicated. Target Database: The oracle or any other database where the data need to be replicated. Manager process: This is the common process which is present at both source golden gate and target golden gate tool, which needs to be started before any other process needs to be started. Manager process is used for coordination of tool, if manager process is not running rest of the process will not work/start. The Manager process is the first Golden Gate p...

  What is golden gate? Oracle Golden Gate is a tool used to replicate, filter and transform data from one database to another database, It may be to any database which is in any operating system. This Golden gate tool is used to replicate data between oracle databases to any other type of databases. The replication of data may be full replication of data or it may be the filtered form of data. This Golden Gate is used for zero/minimal downtime when up-gradation or migration is done. o    The replication database can be used as Disaster recovery database or for report generating database. Export and Import can also be used for replication but it is a onetime replication. Async mode and no online sync or roll forward is allowed o    Export and Import process is, the data is extracted from source oracle database as a .dmp file to the operating system, o    And then Its transferred to the target server and then injected the data to the target oracl...