Solution for Downtime in Oracle

v Unplanned Down time: - The result of computer failures or data failures

Ø  System failures

•          Fast-start Fault Recovery: - Fast-Start Fault Recovery enables you to bound the database Crash recovery time. The database self-tunes checkpoint processing to safeguard the desired recovery time objective.

•          RAC Data Guard Stream: - RAC provides optimal performance, scalability, and availability gains.

Ø  Data failures

•          RMAN backup/recovery: - Recovery Manager (RMAN) automates database backup and recovery. Data Recovery Advisor (not supported for RAC) diagnoses data failures and presents repair options.

•          ASM: - ASM provides a higher level of availability using online provisioning of database storage.

•          Flashback: - Flashback provides a quick resolution to human errors.

•          Oracle Hardware Assisted Resilient Data (HARD): - It’s a comprehensive program designed to prevent data corruptions before they happen.

•          Data Guard & Streams: - Data Guard must be the foundation of any Oracle database disaster-recovery plan.

v  Planned down time: - Due to data changes or system changes:

Ø  System changes

•          Rolling upgrades/Online patching: - The Oracle database supports the application of patches to the nodes of a RAC system, as well as database software upgrades, in a rolling fashion.

•          Dynamic provisioning: - The Oracle database continues to broaden support for dynamic reconfiguration, enabling it to adapt to changes in demand and hardware with no disruption of service.

Ø  Data changes

•          Online Redefinition: - With online redefinition, the Oracle database supports many maintenance operations without disrupting database operations or users updating or accessing data.