EXPERT RESPONSE
Remote replication for Oracle can be achieved by using Oracle Data Guard between the primary and standby (copy) databases. The standby database can be created using a backup copy or existing EMC data replication capabilities if installed.
Once this is done and the software configured, Data Guard automatically updates the standby database by transmitting primary database redo log data from the primary database to the standby system and then applying the redo logs to the standby database.
It should be noted that Data Guard is a feature of Oracle Enterprise Edition, which implies proper licensing. It is technically possible to implement this process manually through scripting and by leveraging Oracle backup tools such as RMAN for budget conscious organization. However, this approach relies on the availability of technical skills and introduces potential maintenance issues typically associated with custom scripts.
|