Redo Apply Best Practices- Oracle Data Guard and Active Data Guard (White Paper)

Oracle White Paper

Redo Apply Best Practices

Oracle Data Guard and Active Data Guard

Introduction

Oracle media recovery is a fundamental element of Oracle Maximum Availability Architecture (Oracle MAA) environments. Media recovery occurs when one or more datafiles or the controlfiles are restored from a previous backup or when using Data Guard Redo Apply (physical standby database). The goal of media recovery is to recover a database to a consistent point in time or to apply all primary database transactions to a physical standby database.

In most cases, the default Oracle settings result in satisfactory performance for media recovery. As applications and databases increase in size and throughput, however, media recovery operations can benefit from additional tuning to further optimize recovery time or Redo Apply throughput on a standby database. The goal of this paper is to provide best practices for monitoring media recovery performance and, if necessary, for tuning media recovery for optimal performance.

This technical paper is intended for Oracle Database Administrators familiar experienced with Oracle Database recovery and having a working knowledge of Data Guard and Active Data Guard.

http://www.oracle.com/technetwork/database/availability/redo-apply-2745943.pdf