Disaster Recovery Solution for Oracle Databases Using Remote Replication Feature of Sun Storage 7000 Unified Storage System

Sridhar Ranganathan and Jeffrey Wright, June 2009

Introduction

This paper shows how to use Sun Storage 7000 Unified Storage System remote replication with Oracle databases and how to perform disaster recovery (DR) at the target site. The release used here was 2008.Q4.

The article covers these topics: overview and capabilities of the remote replication feature, full database replication DR scenarios, and DR scenarios for online redo log replication.

For more details, see the list of contents below.

Download the document as PDF.

Contents

• 1.0 Introduction
• 2.0 Remote Replication Feature of the Sun Storage 7000 Unified Storage System
• • 2.1 Terminology and Operations
  • 2.2 Modes of Replication
  • • 2.2.1 Scheduled Replication
    • 2.2.2 Continuous Replication
  • 2.3 Advantages of Deploying the Remote Replication Feature
  • 2.4 Considerations While Deploying the Remote Replication Feature
• 3.0 Replicating Oracle Databases
• • 3.1 Replicate Full Database
  • 3.2 Replicate Online Redo Logs
• 4.0 DR Scenarios for Full Database Replication
• • 4.1 Setting Up for Full Database Replication
  • 4.2 Full DB Replication: Failover for Testing and Backup Purposes
  • 4.3 Full DB Replication: Failover Without Role-Reversal
  • 4.4 Full DB Replication: Failover With Role-Reversal
  • 4.5 Failback to Source Site After a Failover
• 5.0 DR Scenarios for Online Redo-Log Replication
• • 5.1 Setting Up the Standby Database at the Target Using Remote Replication
  • 5.2 Online Log Replication: Failover to Standby Site
• 6.0 Glossary

For More Information

Here are some additional resources:

• Oracle Technology Network
• Sun product documentation at http://docs.sun.com, for example, Unified Storage documentation
• Sun download site
• Sun training courses at http://www.sun.com/training/, such as Sun Storage 7000 Unified Storage System Administration (NWS-6425)
• Discussions:
  • Sun Storage forums
  • BigAdmin Discussions collection
• Wikis:
  • Sun BluePrints wiki, which provides papers (registration required), such as Configuring Sun Storage 7000 Systems for Oracle Databases
  • Sun Storage Administration wiki
  • BigAdmin Storage Tech Tips wiki
  • BigAdmin Databases wiki
• Other Sun resources:
  • Sun Storage 7000 Unified Storage System web site
  • Sun Storage web site
  • Storage Stop Blog
• BigAdmin resources:
  • Storage resource collection (includes community content)
  • Database resource collection (includes community content)
  • Feature Articles, with information on Sun Storage 7000 Unified Storage System, for example:
    • Deploying Oracle Databases Using NFS on Sun Storage 7000 Unified Storage System
    • Deploying Oracle ASM Using iSCSI on Sun Storage 7000 Unified Storage System
    • Deploying Oracle Real Application Clusters on Sun Storage 7000 Unified Storage System
• Support:
  • Sun resources:
    • Register your Sun gear
    • Services
    • SunSolve Online
  • Community system administration experts
• Events of interest to users of Sun products:
  • Worldwide Developer Events and Sun Tech Days
  • Current Events