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.
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.
Dig Deeper on Remote data protection
Related Q&A from Pierre Dorion
With some limitations, Federal Continuity Directives 1 and 2 can be used to help conduct a business impact assessment. Continue Reading
Find out what business impact assessment errors you can most easily identify in this Expert Response from Pierre Dorion. Continue Reading
Pierre Dorion highlights some of the business impact analysis tools available to help companies in this Expert Response. Continue Reading