Hi All,
We have OGG 11.2.0.4 and planning to migrate 12.2
I have read the document about Integrated capture using the link https://www.oracle.com/technetwork/database/availability/8398-goldengate-integrated-capture-1888658.pdf
I have few doubts about golden-gate concepts
1,The page 20 shows about integrated capture mode which use LCR. ( It captures changes from redo log file and write in trail file as LCR record ).
What format Classic capture is using to write in the local trail file.
or
What is the difference between LCR method in integrated capture and Classic capture method.
2, In the page Number 21 shows "GGSCI> REGISTER EXTRACT ext1 DATABASE".
Do we need to register all the extract process or replicat process ?What is the purpose this command?
3, In on-source of Integrated mode,Is the lcr process started automatically?
4, In the page number 17 shows about rman in classic capture.What kind of setup requires for rman in classic capture.
5, Extract process capture changes only from redo log and archive log.
Does OGG process capture from redo buffer?
6. In the page 37 shows memory parameters for integrated capture.Why we have to configure max_sga_size/stream pools.Because oracle golden gate is not part of oracle installation and database creation.
Each OGG process has separate memeory area. OGG process capture changes only from redo log & archive log only.
Hence,why we need this parameter at db level?
7, How to define memory size for each process in OGG. Is there any parameters?
8, I have a trail file. How to identify it whether relates to particular process , Whether particular database.
Any Suggestions
Thanks & Regards,