Veritas FlashSnap Point-In-Time Copy Solutions 5.0.1 Administrators Guide, HP-UX 11i v3, First Edition, November 2009

Using off-host processing to back up cluster file systems ..................... 55
Reattaching snapshot plexes .................................................... 59
Chapter 5 Decision support ................................................................. 61
About decision support ................................................................. 61
Creating a replica database on the same host ..................................... 62
Creating an off-host replica database ............................................... 68
Resynchronizing the data with the primary host .......................... 74
Reattaching snapshot plexes .................................................... 76
Chapter 6 Database recovery .............................................................. 79
About database recovery ............................................................... 79
Creating Storage Checkpoints ......................................................... 80
Rolling back a database ................................................................. 80
Appendix A Files and scripts for sample scenarios ........................... 83
About files and scripts for sample scenarios ...................................... 83
Script to initiate online off-host backup of an Oracle database .............. 85
Script to put an Oracle database into hot backup mode ........................ 87
Script to quiesce a Sybase ASE database ........................................... 87
Script to suspend I/O for a DB2 database .......................................... 88
Script to end Oracle database hot backup mode ................................. 88
Script to release a Sybase ASE database from quiesce mode ................. 89
Script to resume I/O for a DB2 database ........................................... 89
Script to perform off-host backup ................................................... 90
Script to create an off-host replica Oracle database ............................ 91
Script to complete, recover and start a replica Oracle database ............. 93
Script to start a replica Sybase ASE database ..................................... 94
Appendix B Preparing a replica Oracle database ............................... 97
About preparing a replica Oracle database ........................................ 97
Text control file for original production database ............................. 100
SQL script to create a control file ................................................... 102
Initialization file for original production database ............................ 102
Initialization file for replica Oracle database ................................... 104
Index ................................................................................................................... 107
Contents8