Home » RDBMS Server » Server Administration » Golden gate - In-database archiving (Oracle 12c)
Golden gate - In-database archiving [message #660565] Tue, 21 February 2017 04:08 Go to next message
srinivas.k2005
Messages: 364
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 #660566 is a reply to message #660565] Tue, 21 February 2017 04:11 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
Have you considered using a logical standby database? It is straightforward to set up, licence free (unlike GG), and would certainly give you the control you require.
Re: Golden gate - In-database archiving [message #660568 is a reply to message #660566] Tue, 21 February 2017 04:16 Go to previous messageGo to next message
srinivas.k2005
Messages: 364
Registered: August 2006
Senior Member
Hi John,

We already have license for "Golden gate" and as well as "Oracle Advanced Compression - In database Archiving".

Regards,
SRK






Re: Golden gate - In-database archiving [message #660569 is a reply to message #660568] Tue, 21 February 2017 04:27 Go to previous messageGo to next message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
OK then, choose the more complicated solution Smile

Re: Golden gate - In-database archiving [message #660570 is a reply to message #660569] Tue, 21 February 2017 04:32 Go to previous messageGo to next message
srinivas.k2005
Messages: 364
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 #660572 is a reply to message #660569] Tue, 21 February 2017 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
John Watson wrote on Tue, 21 February 2017 11:27
OK then, choose the more complicated solution Smile
Laughing Indeed, if you already paid for a component you must use it.


Re: Golden gate - In-database archiving [message #660574 is a reply to message #660572] Tue, 21 February 2017 04:47 Go to previous messageGo to next message
srinivas.k2005
Messages: 364
Registered: August 2006
Senior Member
Smile Thank you.
Re: Golden gate - In-database archiving [message #660577 is a reply to message #660574] Tue, 21 February 2017 06:54 Go to previous message
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
Previous Topic: Client setup
Next Topic: Fetch across commit, ora-1555
Goto Forum:
  


Current Time: Sat Jan 20 06:04:05 CST 2018

Total time taken to generate the page: 0.03212 seconds