Oracle replication

hi,

what is the complete picture of Oracle replication ? what component we need to have? they all chargeable ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SujithData ArchitectCommented:
Data Guard and Golden Gate are two solutions from Oracle.
http://www.oracle.com/technetwork/database/availability/dataguardgoldengate-096557.html


If you are looking for a physical standby - you should consider using Data Guard.
https://docs.oracle.com/database/121/SBYDB/toc.htm
0
slightwv (䄆 Netminder) Commented:
Nothing has really changes since you last asked this question:
https://www.experts-exchange.com/questions/29046745/Oracle-mulit-site-configuration.html

Also mentioned in another one of you questions:  Data guard also has a Logical Standby as an option.

It has been deprecated in 12c and 18c is the terminal release but it is still supported:  Streams Replication.  It is included in Enterprise Edition so all you need is the database license on the replicated servers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

I keep hearing physical standby and logical standby, what is the diff ?

this links seems not very clear on this : http://www.dba-oracle.com/t_difference_logical_physical_standby_database.htm

slightwv,

"  It is included in Enterprise Edition so all you need is the database license on the replicated servers."

so both Oracle servers in the steam replication connection must be enterprise ? stream replication replaced by goldengate, right ?

"Also mentioned in another one of you questions:  Data guard also has a Logical Standby as an option."

you are saying, data guard on logical standby can also read only, right ?



Sujith,

if I have 2 x servers farm for data guard and for read only operation we need active dataguard. so we need 2 x data guard license and 1 x active dataguard license on DR DB, so 3 x license, right?

goldengate only need one copy for that ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

slightwv (䄆 Netminder) Commented:
>>I keep hearing physical standby and logical standby, what is the diff ?

At a high level:  Physical is an exact copy.  Logical doesn't have to be.  I think the link you posted does a pretty good job at describing the differences.  What parts were confusing?

>>so both Oracle servers in the steam replication connection must be enterprise ?

For it to be "free", yes.

>>stream replication replaced by goldengate, right ?

Correct.  Streams was deprecated in 12c and will be terminal in 18c meaning after 18, it will no longer be there.

>>you are saying, data guard on logical standby can also read only, right ?

That is what I have been told by Oracle.

>>read only operation we need active dataguard.

You do?

You need to contact Oracle to confirm this but I believe you may need to license Active Dataguard on both sides as well since either database can be "Primary" at any given time.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"What parts were confusing?"

after reading it , I still don't understand what is the diff.... :):)

logical standby is about data clone ?

so physical standby is the same as logical standby ? this is the problem.

"Correct.  Streams was deprecated in 12c and will be terminal in 18c meaning after 18, it will no longer be there."

go as long as enterprise edition, goldengate is free for all nodes in the replication group ?

"You do?"

this mean it is a no ! but being told by Oracle before we need to buy active dataguard for it.

'either database can be "Primary" at any given time."

no active dataguard is read only ! it just make it read about, that's why I am wondering why if logical standby can be read only as if it really is, NO ONE buy active dataguard any more.
0
slightwv (䄆 Netminder) Commented:
>>so physical standby is the same as logical standby ? this is the problem.

A physical standby is an exact copy.  Logical is just moving the data.  The database can be structurally different in a Logical Standby.

>>go as long as enterprise edition, goldengate is free for all nodes in the replication group ?

NO.  Goldengate is never free.  Streams Replication is for Enterprise Edition.

>>this mean it is a no ! but being told by Oracle before we need to buy active dataguard for it.

Logical and Physical standby can be open read only:
https://docs.oracle.com/database/121/SBYDB/concepts.htm#SBYDB4702

As of Oracle Database 11g Release 1 (11.1), a physical standby database can receive and apply redo while it is open for read-only access. A physical standby database can therefore be used concurrently for data protection and reporting.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"A physical standby is an exact copy.  Logical is just moving the data.  "

I love this answer, logical should means the subset, which is the data itself.

"NO.  Goldengate is never free.  S"

yeah, another cost.

"Logical and Physical standby can be open read only:"

so no need active data guard license anymore ? when I am doing oracle cost , teacher said we need it, so this means no need for such license.

but there are diff between goldengate and data guard, goldengate is much on logical level  ?
0
slightwv (䄆 Netminder) Commented:
>>so no need active data guard license anymore ?

Oracle is really good at sales but they couldn't sell it if it didn't offer some benefits over the included versions of Data Guard.  Off the top of my head, I don't know what those benefits are.

>>goldengate is much on logical level  ?

Goldengate can also with with non-Oracle databases.

>>teacher said we need it, so this means no need for such license.

Present them with the documentation link I posted above and ask them if it is still necessary?  Personally I've never asked my Account Team about "free" read only with Data Guard.  I can only go by what the docs say.  The docs have been wrong before!
0
marrowyungSenior Technical architecture (Data)Author Commented:
"Goldengate can also with with non-Oracle databases."


yes, tks. I got it.

"The docs have been wrong before!"

then why still read it?
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks all.
0
slightwv (䄆 Netminder) Commented:
>>then why still read it?

Because they are still the best source of information.  Things change so fast there are a few times where the documentation misses things.  It doesn't happen often but it does happen.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"Because they are still the best source of information.  Things change so fast there are a few times where the documentation misses things.  I"

agree!

then when I confirm it I have to ask Oracle .
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.