Goldengate Instantiation For Downstream Integrated Capture.
(Doc ID 1533159.1)
Last updated on FEBRUARY 19, 2020
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 to 18.104.22.168.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?
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