OraFAQ Forum: Replication » synchronise data

Home » Server Options » Replication » synchronise data (Oracle DB 11.2.0.3.0, Red hat linux enterprise edition 6.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

synchronise data [message #606635]

Mon, 27 January 2014 11:44

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi folks,

we have production database 11.2.0.3.0 which is RAC mode & user by name PRDODTA in the Database which has several tables & develpoment database 11.2.0.3.0 which is also RAC mode & user by name CRPDTA which has several tables. so my question is here how to refresh data periodically from production to developement.
i know dblink is the way but any one could assits me the whole scripts or dbms job

i have created db link from dev DB (user crpdta) to prod (user proddta)

At Dev side
>create database link refresh
connect to proddta identified by password
using to-prod;

thanks & regards.

Report message to a moderator

Re: synchronise data [message #606636 is a reply to message #606635]

Mon, 27 January 2014 11:51

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are many ways depending on many parameters.
Investigate export/import, Streams, standby database...

Report message to a moderator

Re: synchronise data [message #606643 is a reply to message #606635]

Mon, 27 January 2014 16:35

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

oradba123 wrote on Mon, 27 January 2014 11:44

i know dblink is the way but any one could assits me the whole scripts or dbms job

db link is not 'the' way. It is one way of several. The best way for your specific requirements may very well be something else entirely. In addition to Michael's suggestions I'd add a periodic refresh from rman backup, using rman 'duplicate database'.

Report message to a moderator

Re: synchronise data [message #606647 is a reply to message #606636]

Mon, 27 January 2014 22:30

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi Michael,

As you said

i need to periodically refresh(either it means of DML,DDL operations) from production database schema's tables to develpoment database schema's. could you tell me is it possible through export/import, Streams, standby database... . if so please give me the whole process .i would appreciate a lot.

Thanks

Report message to a moderator

Re: synchronise data [message #606651 is a reply to message #606647]

Tue, 28 January 2014 00:15

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I can't as it would mean writing a 300 page book.
You have to specify in details what you need.
For instance, size and number of objects of the schema, is there another schema in the database(s), refresh frequency, synchronous/asynchronous...

Report message to a moderator

Previous Topic:	MV fast refresh fails with 01031: insufficient privileges
Next Topic:	DDL synchronisation failed with error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:29:17 CST 2025