Home » Other » Marketplace » Oracle DBA with replication
Oracle DBA with replication [message #368705] Fri, 13 August 1999 23:35 Go to next message
Rajeeva
Messages: 20
Registered: October 1998
Junior Member
I am an Oracle DBA with over 8 years of Oracle experience.This includes RDBMS, Tools, Utilities and Replication

Contact me on rajeeva@angelfire.com
Re: Oracle DBA with replication [message #369040 is a reply to message #368705] Fri, 15 September 2000 13:06 Go to previous messageGo to next message
Malar
Messages: 1
Registered: September 2000
Junior Member
We have the production site and have to set up the remote replication site. We are planning to construct the remote site the very first data transfer thro' export or thro' media (CD or tape) as the database is huge. Once the database is up and running is it possible to build the relation between the 2 schemas to replicate the data.
Re: Oracle DBA with replication [message #369041 is a reply to message #368705] Fri, 15 September 2000 14:06 Go to previous message
Rajeeva
Messages: 20
Registered: October 1998
Junior Member
All you need to do is to create the database links and implement replication. REmember after the export/backup of the primary database is taken, until the second database is populated you should not change any data in the primary DB. If this is unavoidable, populate the second database by implement replication with the COPY ROWS option.

This is a very long process and you have to take care of the Ref. Int. constraints. Also there are other ways of populating the second database. You can Ship logs to the second database as a stand by database. Then also you can copy tables and populate the second database etc.
Previous Topic: Oracle Developer needed in Seattle, WA
Next Topic: Oracle DBA needed in West Palm Beach, FL
Goto Forum:
  


Current Time: Sun Oct 24 13:30:14 CDT 2021