Remote Mirroring of an Oracle Database

• Chapter 1: Remote Volume Mirroring Requirements
  • Solution Preparation
  • Required Expertise
  • Required Documents
  • Required Components
  • Required Methodology
• Chapter 2: Preinstallation Tasks
  • Example Configuration
  • Preinstallation Task Flow
  • Preinstallation Checklist
  • Verifying the WAN and the LAN Infrastructure
  • Installing the Storage Systems and Software
  • Activating the Premium Features
• Chapter 3: Solution Installation
  • Installation Task Flow
  • Script Process Flow
  • Configuring the Remote Mirroring Sites
    • Database Mirroring Best Practices
    • Mirroring Databases
  • Creating Volumes
  • Creating Mirrors
  • Verifying the Installation
  • Troubleshooting
• Chapter 4: Oracle on the AIX OS Configuration for Remote Volume Mirroring
  • Starting the Database Mirroring
  • Stopping the Previously Mirrored Database
  • Suspending the Primary Database
  • Creating a Snapshot on the Remote Mirroring Site
  • Resuming the Primary Database
  • Creating a Volume Copy on the Remote Mirroring Site
  • Recovering the Database on the Remote Mirroring Site
  • Scripts Verification Checklist
    • Sample Oracle Trace File:
• Chapter 5: Oracle on the Sun OS Configuration for Remote Volume Mirroring
  • Script Process Flow
  • Moving Critical Oracle Files to Volumes That Will Be Mirrored
  • Starting the Database Mirroring
  • Stopping a Previously Mirrored Remote Database
  • Putting the Database in Backup Mode
  • Creating a Snapshot on the Remote Mirroring Site
  • Resuming the Database
  • Creating a Volume Copy on the Remote Mirroring Site
  • Recovering the Database on the Remote Mirroring Site
  • Scripts Verification Checklist
• Chapter 6: Oracle on the Linux Red Hat OS Configuration for Remote Volume Mirroring
  • Script Process Flow
  • Moving Critical Oracle Files to Volumes that Will Be Mirrored
  • Starting the Database Mirroring
  • Stopping a Previously Mirrored Remote Database
  • Putting the Database in Backup Mode
  • Creating a Snapshot on the Remote Mirroring Site
  • Resuming the Database
  • Creating a Volume Copy on the Remote Mirroring Site
  • Recovering the Database on the Remote Mirroring Site
  • Scripts Verification Checklist
  • Troubleshooting
• Chapter 7: Tools and Utilities
• Appendix A: References
  • LSI
• Appendix B: Oracle on the AIX OS Scripts
  • erm_setup.ksh
  • erm.ksh
  • erm.conf
  • ./.remote/oracle/db_stop
  • ./.remote/oracle/db_stop.sql
  • ./.remote/oracle/db_start
  • ./.primary/oracle/db_get_udump
  • ./.primary/oracle/db_suspend
  • ./.primary/oracle/db_resume
  • ./.primary/oracle/ db_archive_log_current.sql
  • ./.primary/oracle/ db_backup_controlfile.sql
  • ./.primary/oracle/db_begin_backup.sql
  • ./.primary/oracle/db_check_pfile.sql
  • ./.primary/oracle/db_create_pfile.sql
  • ./.primary/oracle/db_create_pfile.sql
  • ./goodies/move_ora_admin_files.ksh
  • ./goodies/undo_move_admin_files.ksh
• Appendix C: Oracle on the Sun Solaris OS Scripts
  • Stop the Database on the Remote Site
  • Suspend the Database on the Primary Site
  • Recreate a Snapshot
  • Resume a Primary Database on the Primary Site
  • Restart the Remote Database
  • Archive the Unarchived Redo Logs on the Primary Site
  • Begin the Online Backup on the Primary Site
  • End the Online Backup on the Primary Site
  • Back Up the Control File on the Primary Site
  • Create a PFILE if Using an SPFILE on the Primary Site
  • Get the userdump Destination Location on the Primary Site
  • Create Links for Oracle Configuration and Dump Files on the Remote Site
  • Verify that the Database Is Online on the Remote Site
  • Verify that the Database Is Offline on the Remote Site
  • Shut Down the Oracle Database on the Remote Site
  • Start the Oracle Database with Backup Control on the Remote Site
  • Shut Down the Oracle Database on the Remote Site
  • The sun_erm.ksh Script
  • The sun_erm_setup.ksh Script
  • RVM Configuration Samples
• Appendix D: Oracle on the Linux OS Scripts
  • Stop the Database on the Remote Site
  • Suspend the Database on the Primary Site
  • Re-create a Snapshot
  • Resume a Primary Database on the Primary Site
  • Restart the Remote Database
  • Archive the Unarchived Redo Logs on the Primary Site
  • Begin the Online Backup on the Primary Site
  • End the Online Backup on the Primary Site
  • Back Up the Control File on the Primary Site
  • Create a PFILE if Using an SPFILE on the Primary Site
  • Get the userdump Destination Location on the Primary Site
  • Create Links for Oracle Configuration and Dump Files on the Remote Site
  • Verify that the Database Is Online on the Remote Site
  • Verify that the Database Is Offline on the Remote Site
  • Shut Down the Oracle Database on the Remote Site
  • Start the Oracle Database with Backup Control on the Remote Site
  • Shut Down the Oracle Database on the Remote Site
  • The linux_erm.ksh Script
  • The linux_erm_setup.ksh Script
  • RVM Configuration Samples