Home » RDBMS Server » Server Administration » Database Synchronization
Database Synchronization [message #207941] Thu, 07 December 2006 08:12 Go to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member

Best way to sync 2 databases[ 4 votes ]
1. Data Guard 4 / 100%
2. Streams 0 / 0%
3. Homemade scripts 0 / 0%
4. Other ... 0 / 0%

Ok I have a production database, and I want to create a stand by database witch is in sync with my production database.

What is the best way to create something like this???


Kr
Karel.
Re: Database Synchronization [message #207944 is a reply to message #207941] Thu, 07 December 2006 08:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There is a subtle conflict in terminology used here.
Dataguard is standby.
Streams is more CDC( change data capture). You capture the changes and propogate them to another site. For a real busy system, streams could be painful.
And as usual, i am biased. How about RMAN standby?

Re: Database Synchronization [message #207951 is a reply to message #207944] Thu, 07 December 2006 08:38 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Mahesh Rajendran wrote on Thu, 07 December 2006 15:22
There is a subtle conflict in terminology used here.
Dataguard is standby.
Streams is more CDC( change data capture). You capture the changes and propogate them to another site. For a real busy system, streams could be painful.
And as usual, i am biased. How about RMAN standby?





I'm just learning 10g so I'm not realy familiar with data guard, streams, rman standby , and so on.

But are you saying that streams only capture the changes...
Do they get applied to an other database? And if so what is the difference with Data Guard.

And why would you chose RMAN stand by over Data Guard?

Kr
Karel.
Re: Database Synchronization [message #207960 is a reply to message #207951] Thu, 07 December 2006 08:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>And if so what is the difference with Data Guard.
The functionality is the same. Both propogate data across to a remote database.
The method those mechanisms work with is different. More info in documentation.
Dataguard (standby) is more for DR (disaster recovery) site and high availablity.
Streams is more flexible and used for ETL related thingies (more for integrating data logically)
This presentation breifly outlines the difference
www.nocoug.org/download/2005-11/logstby4rpt_NoCOUG_200511.ppt

>>why would you chose RMAN stand by over Data Guard?
Because I am RMAN guy.
We are 100% RMAN shop. We backup/duplicate/restore production/dev/test environments with RMAN.
Standby with RMAN is just one more step for a full RMAN shop.
Very flexible and free. Smile
No grudge against other tools. This was just a matter of preference and flexibility.


Re: Database Synchronization [message #207962 is a reply to message #207960] Thu, 07 December 2006 09:06 Go to previous message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
Mahesh Rajendran wrote on Thu, 07 December 2006 15:54
>>And if so what is the difference with Data Guard.
The functionality is the same. Both propogate data across to a remote database.
The method those mechanisms work with is different. More info in documentation.
Dataguard (standby) is more for DR (disaster recovery) site and high availablity.
Streams is more flexible and used for ETL related thingies (more for integrating data logically)
This presentation breifly outlines the difference
www.nocoug.org/download/2005-11/logstby4rpt_NoCOUG_200511.ppt

>>why would you chose RMAN stand by over Data Guard?
Because I am RMAN guy.
We are 100% RMAN shop. We backup/duplicate/restore production/dev/test environments with RMAN.
Standby with RMAN is just one more step for a full RMAN shop.
Very flexible and free. Smile
No grudge against other tools. This was just a matter of preference and flexibility.





Thumbs Up thx for the info
Previous Topic: FGA question
Next Topic: Migrate from Oracle 7.3.4 to 9i or 10g
Goto Forum:
  


Current Time: Mon Dec 05 09:10:33 CST 2016

Total time taken to generate the page: 0.05680 seconds