Solved

Oracle 11g database-based replication

Posted on 2011-02-21
6
1,108 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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
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

691 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