Home » Server Options » Replication » synchronise data (Oracle DB 11.2.0.3.0, Red hat linux enterprise edition 6.4)
synchronise data [message #606635] Mon, 27 January 2014 11:44 Go to next message
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.
Re: synchronise data [message #606636 is a reply to message #606635] Mon, 27 January 2014 11:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: synchronise data [message #606643 is a reply to message #606635] Mon, 27 January 2014 16:35 Go to previous messageGo to next message
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'.
Re: synchronise data [message #606647 is a reply to message #606636] Mon, 27 January 2014 22:30 Go to previous messageGo to next message
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



Re: synchronise data [message #606651 is a reply to message #606647] Tue, 28 January 2014 00:15 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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...

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


Current Time: Fri Mar 29 10:13:59 CDT 2024