Remote replication with Oracle software

Remote replication with Oracle software

We have two Dell PowerEdge 2850 servers. Both servers are dual processor/dual core running Windows Enterprise 2003. We are running Oracle 10G RAC using an EMC SAN and would like to replicate to an offsite server.

The issue is that Oracle has its own unique file types that can only be seen using Oracle software. We are looking for a disaster recovery/business continuity solution that will recognize the Oracle files and replicate them to our disaster recovery site.

    Requires Free Membership to View

    Login

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

This was first published in April 2007