The Quick Recovery Agent and the following iDataAgents can work together to provide an integrated data protection and recovery system for your database volumes:
In this scenario, the Quick Recovery Agent creates and maintains a copy, or QR Volume, of the database and log volumes associated with the Oracle or SQL database. The corresponding iDataAgent is then used to back up the associated logs — Transaction Logs for SQL Server and Archive Logs for Oracle.
During a recovery of the QR Volume, the Quick Recovery Agent recovers the database volumes' data as they existed at the point in time of the last QR Volume creation. Any iDataAgent transaction log or archive log backups that were run after the last QR update can then be applied via the corresponding iDataAgent. Additionally for Oracle, if online redo logs are present, they can also be applied to recover the database up to the current time.
This configuration takes advantage of both the speed of recovery offered by the Quick Recovery Agent and the efficiency of log backups (which are typically less resource-intensive than database backups and can be scheduled to occur frequently).
The Oracle iDataAgent provides many options for recovery, and these options need to be selected very carefully. The Oracle database recovery procedures must be followed in the correct sequence; otherwise, data could be lost. |
In order to take advantage of this data protection and recovery system, perform the following:
Recovering your data for this configuration consists of two tasks:
|
The Oracle iDataAgent provides many
options for recovery and these options need to be selected very carefully. The
Oracle database recovery procedures must be followed in the correct sequence or
it could result in the loss of data. Before recovering the Oracle database to a point-in-time, read Caution on the Use of RESETLOGS. |