Last updated on MAY 07, 2017
Applies to:Oracle GoldenGate - Version 184.108.40.206.0 to 220.127.116.11.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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms