RDF System Management Manual
Table Of Contents
- RDF System Management Manual
- What’s New in This Manual
- About This Manual
- 1 Introducing RDF
- RDF Subsystem Overview
- RDF Processes
- RDF Operations
- Reciprocal and Chain Replication
- Available Types of Replication to Multiple Backup Systems
- Triple Contingency
- Loopback Configuration (Single System)
- Online Product Initialization
- Online Database Synchronization
- Online Dumps
- Subvolume- and File-Level Replication
- Shared Access DDL Operations
- EMS Support
- SMF Support
- RTD Warning Thresholds
- Process-Lockstep Operation
- Support for Network Transactions
- RDF and NonStop SQL/MX
- Zero Lost Transactions (ZLT)
- Monitoring RDF Entities With ASAP
- 2 Preparing the RDF Environment
- 3 Installing and Configuring RDF
- 4 Operating and Monitoring RDF
- 5 Managing RDF
- Recovering From File System Errors
- Handling Disk Space Problems
- Responding to Operational Failures
- Stopping RDF
- Restarting RDF
- Carrying Out a Planned Switchover
- Takeover Operations
- Reading the Backup Database
- Access to Backup Databases in a Consistent State
- RDF and NonStop SQL/MP DDL Operations
- RDF and NonStop SQL/MX Operations
- Backing Up Image Trail Files
- Making Online Dumps With Updaters Running
- Doing FUP RELOAD Operations With Updaters Running
- Exception File Optimization
- Switching Disks on Updater UPDATEVOLUMES
- 6 Maintaining the Databases
- 7 Online Database Synchronization
- 8 Entering RDFCOM Commands
- 9 Entering RDFSCAN Commands
- 10 Triple Contingency
- 11 Subvolume- and File-Level Replication
- 12 Auxiliary Audit Trails
- 13 Network Transactions
- Configuration Changes
- RDF Network Control Files
- Normal RDF Processing Within a Network Environment
- RDF Takeovers Within a Network Environment
- Takeover Phase 1 – Local Undo
- Takeover Phase 2 – File Undo
- Takeover Phase 3 – Network Undo
- Takeover Phase 3 Performance
- Communication Failures During Phase 3 Takeover Processing
- Takeover Delays and Purger Restarts
- Takeover Restartability
- Takeover and File Recovery
- The Effects of Undoing Network Transactions
- Takeover and the RETAINCOUNT Value
- Network Configurations and Shared Access NonStop SQL/MP DDL Operations
- Network Validation and Considerations
- RDF Re-Initialization in a Network Environment
- RDF Networks and ABORT or STOP RDF Operations
- RDF Networks and Stop-Update-to-Time Operations
- Sample Configurations
- RDFCOM STATUS Display
- 14 Process-Lockstep Operation
- Starting a Lockstep Operation
- The DoLockstep Procedure
- The Lockstep Transaction
- RDF Lockstep File
- Multiple Concurrent Lockstep Operations
- The Lockstep Gateway Process
- Disabling Lockstep
- Reenabling Lockstep
- Lockstep Performance Ramifications
- Lockstep and Auxiliary Audit Trails
- Lockstep and Network Transactions
- Lockstep Operation Event Messages
- 15 NonStop SQL/MX and RDF
- Including and Excluding SQL/MX Objects
- Obtaining ANSI Object Names From Updater Event Messages
- Creating NonStop SQL/MX Primary and Backup Databases from Scratch
- Creating a NonStop SQL/MX Backup Database From an Existing Primary Database
- Online Database Synchronization With NonStop SQL/MX Objects
- Offline Synchronization for a Single Partition
- Online Synchronization for a Single Partition
- Correcting Incorrect NonStop SQL/MX Name Mapping
- Consideration for Creating Backup Tables
- Restoring to a Specific Location
- Comparing NonStop SQL/MX Tables
- 16 Zero Lost Transactions (ZLT)
- A RDF Command Summary
- B Additional Reference Information
- C Messages
- D Operational Limits
- E Using ASAP
- Index
Maintaining the Databases
HP NonStop RDF System Management Manual—524388-003
6-5
NonStop SQL/MP or NonStop SQL/MX Databases
Catalog Changes
RDF views NonStop SQL/MP and NonStop SQL/MX DDL operations as updates to
catalogs. NonStop SQL/MP and NonStop SQL/MX catalogs themselves are audited
tables, even on the backup system. NonStop SQL/MP and NonStop SQL/MX DDL
operations are not replicated by RDF; therefore, RDF does not apply updates to
catalogs.
The following guidelines apply to creating catalogs:
•
If a catalog exists on a volume protected by RDF, this catalog should also be
present on the corresponding volume on the backup system.
•
To avoid errors, create a catalog on the backup system before creating it on the
primary system. If audit data is generated for a primary catalog before the
corresponding backup catalog exists, every audit record for the catalog causes a
file open error.
Updater processes check for catalog tables, which have a file code in the range 550
through 590 and 859 (ODBC catalogs). An updater does not apply any changes to a
table that has a catalog file code.
An update operation to a table that does not exist causes RDF to log an RDF error
message 736, citing file system error 11, and the updater retries until the file is created
by the user.
DDL Operations
Every NonStop SQL/MP or NonStop SQL/MX DDL operation performed on the primary
system must also be performed on the backup system by NonStop SQL/MP or
NonStop SQL/MX if any of the tables or catalogs reside on volumes protected by RDF.
DDL Operations Guidelines
The following guidelines apply to NonStop SQL/MP and NonStop SQL/MX DDL
operations:
•
Creating an index or loading data into an added table partition does not interfere
with RDF protection. Although a CREATE INDEX or ALTER TABLE MOVE FROM
FIRST KEY UP TO KEY operation seems to create an audited index or partition
within a transaction, only the updates to the catalog and file labels are audited. The
index or partition is created nonaudited, and audit is not turned on until after the
operation is complete. Performing either of these DDL operations on the backup
system for a corresponding DDL operation on the primary system does not cause
problems because the operation on the primary system proceeds internally as
follows:
1. Create a nonaudited table (index or partition).
2. Move the data without logging by TMF.
3. Issue an ALTER TABLE table-name AUDIT statement for the table.