Solved

Oracle 11g database-based replication

Posted on 2011-02-21
6
1,092 Views
Last Modified: 2013-12-12
Hello,

we are quite new to Oracle's clustering features regarding database-based replication.
Is there any how-to guide for setting up an Oracle server running on Linux in order to replicate
databases crosswise like the follwing:

[Server #1]
 - DB A (master)
 - DB B (slave)

[Server #2]
 - DB B (master)
 - DB A (slave)

We do not plan to access the slave database - they are merely for backup
 (and in the worst case: failover) reasons

Since using Materialized Views ain't be an option (>700 tables, complex data model) and having
shared disks running for 2 Oracle nodes is not really what we want, we feeling a bit lost here.

We are looking for something "simple" like MySQLs Master/Slave Replication.

Thanks,
Stephan
0
Comment
Question by:StephanSchneider
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 34946077

Create slaves as "standby databases".
0
 
LVL 48

Expert Comment

by:schwertner
ID: 34952245
Physical Data Guard (as mentioned by MikeOM_DBA) is the best solution.
But when you want to minimaze the load of the "masters" you can direct the reports to the "slaves".
In this case you can use logical Data Guard.

Alternative technology provided by Oracle is Oracle Streams.
It is developed by the same team that has developed Data Guard but gives more flexibility and allows fully usage of the functions on both nodes and quick replication of the data. Nevertheles Streams is more complex and need more maintenace as data Guard solution.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 34954378

In 11g you can open the physical standby "read only" to produce reports.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 48

Expert Comment

by:schwertner
ID: 34954599
Yes, thats true.
0
 

Author Comment

by:StephanSchneider
ID: 35005853
Hello,

thanks a lot for clearing things up.
We managed to get our test database writing an archive log on local disk, syncing it to another host via scp and importing it back to the standby database.

Since we are using Standard Edition One, is there any chance to get redo streams working natively?

Thanks,
Stephan
0
 
LVL 48

Expert Comment

by:schwertner
ID: 35010557
According
http://www.freelists.org/post/oracle-l/a-really-nontechnical-question-help,6
 you can use Data Guard with Standart Edition, but both DB need tobe licensed.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Repeat query 13 74
Fill Null values 5 37
Creating a are-you-sure condition prior to shutdown: what do you think of... 14 43
Oracle Errors 11 52
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question