Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle 11g database-based replication

Posted on 2011-02-21
6
Medium Priority
?
1,166 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 2000 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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

Industry Leaders: 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!

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

636 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