| Golden gate - In-database archiving [message #660565] |
Tue, 21 February 2017 04:08  |
srinivas.k2005
Messages: 404
Registered: August 2006
|
Senior Member |
|
|
Hello Experts,
We have a requirement to have separate replicated database for existing DB to improve DB performance.
Currently, we have only one DB for both applications and as well as for Reports. Now, requirement is to have separate DB for each.
The replication database is needed for Business objects tool and other downstream applications as well.
In Oracle 12C database, comprehensive replication of the Production database can be done by using "Oracle Golden gate" concept.
According to my knowledge, "Golden Gate" concept at high level will load data from primary database to replication database at a near real time. I.e., whatever changes happens to primary DB, will reflect in corresponding replica DB.Here changes refers to Inserts, updates, deletions to tables.
First question is, whether can we have something rule in "Golden gate" to exclude archival data from Primary DB to replica DB while loading? Does we have row level filter condition before loading data to replica DB?
Second question is, Does "Golden Gate" supports "In-database archiving - Oracle 12" feature?
[Rules to exclude Archived data]
Primary DB ---------------------------------> Replica DB
Our concern is if there is any data purging/data archival in primary database, changes should not be loaded in replica db. Here, we need to distinguish the type of deletion vs purging activity for content that ages beyond the archival period.
Deletion of invoices as a part of day to day operations should be replicated in replica DB whereas data which are part of archival should be excluded.
Please advise/Suggestions on the same.
Regards,
SRK
[Updated on: Tue, 21 February 2017 04:11] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Golden gate - In-database archiving [message #660570 is a reply to message #660569] |
Tue, 21 February 2017 04:32  |
srinivas.k2005
Messages: 404
Registered: August 2006
|
Senior Member |
|
|
oh!! John, I don't know about "logical standby database". Will look into the same.
Thanks a lot for the info.
Just to confirm again with you, Can we control data at table level and as well as row level before loading data into replication DB?
Thanks again.
Regards,
Vinay
|
|
|
|
|
|
|
|
| Re: Golden gate - In-database archiving [message #660577 is a reply to message #660574] |
Tue, 21 February 2017 06:54 |
 |
scapy
Messages: 12
Registered: November 2015
Location: Portugal
|
Junior Member |
|
|
Hi,
Yes you can filter on GoldenGate. Lately I have not messed with goldengate, but you can filter using :
IGNOREINSERTS | GETINSERTS
IGNOREUPDATES | GETUPDATES
IGNOREDELETES | GETDELETES
You have to check the syntax. In my opion, is better to you create extract to the tables you want. Then in replicat you put the filters you want on tables
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
Indeed, if you already paid for a component you must use it.