Goldengate Instantiation For Downstream Integrated Capture.
(Doc ID 1533159.1)
Last updated on FEBRUARY 19, 2020
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
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
Symptoms |
Cause |
Solution |