Home » RDBMS Server » Server Administration » Database Sync (HP-UX 11.11 Oracle 10.2.0.3.0)
Database Sync [message #315336] Mon, 21 April 2008 03:25 Go to next message
stevefox777
Messages: 26
Registered: September 2006
Junior Member
Hi,

I need to create a test database which will be in sync with the production database. The sync will be one way, from production to test database, so any changes made on the test database will be cleared when it gets synced. There is no need for the sync to be performed in real time but at least once per day is desired. Also, there is no need for the test database to be used as a backup database when the production database goes down. The test database will be on a separate server to the producion database connected with 100Mbs network. If you have any recommendations on what programs to use to achive this please let me know.

OS: HP-UX 11.11
Oracle version : 10.2.0.3.0


Steve
Re: Database Sync [message #315342 is a reply to message #315336] Mon, 21 April 2008 04:00 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
RMAN duplicate
export/import

Regards
Michel
Previous Topic: Findind size of Oracle Database
Next Topic: Mail from Oracle procedure
Goto Forum:
  


Current Time: Fri Nov 29 21:48:39 CST 2024