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.

Report message to a moderator

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: 10707
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?

Report message to a moderator

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.

Report message to a moderator

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: 10707
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.

Report message to a moderator

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

Report message to a moderator

Previous Topic: FGA question
Next Topic: Migrate from Oracle 7.3.4 to 9i or 10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 04:38:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.