HP NonStop RDF, Руководство по управлению

Страница: 8 / 478

Monitor Considerations...........................................................................................................143
Updater Considerations...........................................................................................................143
Takeover and Triple Contingency..................................................................................................143
Checking Exception Files for Uncommitted Transactions............................................................143
How to Plan for the Fastest Movement of Business Operations to Your Backup System After
Takeover.........................................................................................................................................144
Restoring the Primary System.......................................................................................................147
Online Method of Resynchronizing the Primary Database.....................................................148
Offline Method of Resynchronizing the Primary Database.....................................................148
Reading the Backup Database (BROWSE versus STABLE Access)....................................................149
Near Real Time Read Access to Updates on the Primary System......................................................149
Access to Backup Databases with Stable Access................................................................................150
Stopping TMF on the Primary System..........................................................................................150
Using the STOP RDF, DRAIN Command.....................................................................................150
STOP UPDATE to a Timestamp....................................................................................................150
RDF and NonStop SQL DDL Operations...........................................................................................151
Performing Nonshared Access DDL Operations..........................................................................152
Performing Shared Access DDL Operations.................................................................................152
Network Configurations and Shared Access NonStop SQL DDL Operations........................153
RDF and NonStop SQL/MX Operations.............................................................................................153
Backing Up Image Trail Files..............................................................................................................153
TMF and Online Dumps on the Backup System................................................................................154
Doing FUP RELOAD Operations With Updaters Running...............................................................155
Exception File Optimization...............................................................................................................155
Switching Disks on Updater UPDATEVOLUMES.............................................................................155
Online Remirroring of Updater SUBVOLUMES................................................................................156
6 Maintaining the Databases
......................................................................................
157
Understanding Database States..........................................................................................................157
Making Changes to Database Structures............................................................................................159
NonStop SQL/MP or NonStop SQL/MX Databases......................................................................160
Catalog Changes.......................................................................................................................160
DDL Operations.......................................................................................................................160
With Shared Access.............................................................................................................160
Without Shared Access.......................................................................................................161
Adding a New Column.......................................................................................................161
Guidelines for Create Index and Alter Table Move Operations.........................................162
Example for CREATE INDEX With Shared Access............................................................162
Multiple Indexes on a Single Base Table.............................................................................162
Partition Key Changes..............................................................................................................163
Table Purges.............................................................................................................................163
Enscribe Databases........................................................................................................................164
The STOP TMF Method............................................................................................................164
The STOP RDF DRAIN Method...............................................................................................164
Resynchronizing Databases................................................................................................................164
Resynchronizing Entire Databases Offline....................................................................................165
Resynchronizing Individual Volumes, Tables, and Files Offline..................................................165
Resynchronizing Individual Tables or Files Offline......................................................................166
7 Online Database Synchronization ........................................................................... 167
Overview.............................................................................................................................................167
Synchronizing Entire Databases Online.............................................................................................168
Considerations When Synchronizing Entire Databases................................................................169
8 Table of Contents