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

Last updated on MAY 07, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 to 12.1.2.0.0 [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?

Symptoms

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

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms