My Oracle Support Banner

Goldengate Instantiation For Downstream Integrated Capture. (Doc ID 1533159.1)

Last updated on FEBRUARY 19, 2020

Applies to:

Oracle GoldenGate - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.
1. Register extract process with logminer as of SCN "N".
OGG-02003 Extract EXT1 successfully registered with database at SCN
2. Start extract process ext1 as of scn "N"
ADD EXTRACT ext1, INTEGRATED TRANLOG, BEGIN 2013-02-08 11:32:47.000000(This time is scn_to_timestamp as of scn N.
3. Instanitiate the schemas using expdp/impdp with flashback scn "N".
This ensures that no transactions are missed out.

Since the database size is huge, is it possible to use RMAN clone to re-instantiate the db?


 Is it possible to use RMAN clone method in a downstream capture instantiation?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.