16 NonStop SQL/MX and RDF
...................................................................................
323
Including and Excluding SQL/MX Objects.........................................................................................323
Creating NonStop SQL/MX Primary and Backup Databases.............................................................323
Creating a NonStop SQL/MX Backup Database From an Existing Primary Database......................326
Online Database Synchronization With NonStop SQL/MX Objects..................................................328
Creating the Fuzzy Copy on the Primary System.........................................................................328
Creating the Fuzzy Copy on the Backup System..........................................................................330
Offline Synchronization for a Single Partition....................................................................................330
Directly From the Primary to the Backup......................................................................................330
Indirectly From the Primary to the Backup By Way of a Temporary File.....................................331
Backup Partition Does Not Already Exist.....................................................................................331
Online Synchronization for a Single Partition....................................................................................331
Correcting Incorrect NonStop SQL/MX Name Mapping...................................................................332
Primary and Backup ANSI Catalog Are the Same........................................................................332
Primary and Backup ANSI Schema Names Are Not the Same.....................................................332
Schema Subvolume Names Are Not the Same..............................................................................332
Guardian Filename Is Incorrect for Partition.................................................................................332
Consideration for Creating Backup Tables.........................................................................................333
Restoring to a Specific Location..........................................................................................................333
Example.........................................................................................................................................333
Comparing NonStop SQL/MX Tables.................................................................................................335
17 Zero Lost Transactions (ZLT)
.....................................................................................
337
How It Works......................................................................................................................................337
Using CommitHoldMode...................................................................................................................340
Hardware Setup..................................................................................................................................340
Assigning CPUs on the Standby System............................................................................................340
RDF Configuration Attributes............................................................................................................341
RDF Remote Mirror Configuration...............................................................................................341
RDF Remote Standby Configuration.............................................................................................341
RDF Configuration Record Validation..........................................................................................341
Extractor Audit-Trail Configuration..............................................................................................341
ALTER RDF Remote Mirror Configuration...................................................................................342
ZLT Takeover Operations...................................................................................................................342
Phase 1 (ZLT Processing)...............................................................................................................342
The Audit-Fixup Process..........................................................................................................343
Phase 2 (Takeover Processing).......................................................................................................343
ZLT Events.....................................................................................................................................343
Error Conditions............................................................................................................................343
STATUS RDF..................................................................................................................................343
RDFCOM INFO and SHOW Commands......................................................................................344
Old Audit-Trail Files......................................................................................................................344
Recovering the Primary System After an RDF ZLT Takeover............................................................344
ZLT and RDF Networks......................................................................................................................346
STOP TMF Operations........................................................................................................................346
During Normal Operations...........................................................................................................346
During ZLT Takeover Processing..................................................................................................346
SQL Shared Access DDL Operations..................................................................................................347
A RDF Commands Quick Reference
............................................................................
349
RDFCOM Run Syntax.........................................................................................................................349
RDFCOM Commands Quick Reference.............................................................................................349
ADD...............................................................................................................................................349
Table of Contents
17
Содержание NonStop RDF
Страница 68: ...68 ...
Страница 186: ...186 ...
Страница 260: ...260 ...
Страница 278: ...278 ...
Страница 284: ...284 ...
Страница 290: ...290 ...
Страница 308: ...308 ...
Страница 322: ...322 ...
Страница 336: ...336 ...
Страница 348: ...348 ...
Страница 464: ...464 ...
Страница 478: ......