SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Contents

HP NonStop SQL/MX Installation and Management Guide—523723-004

5. Planning Database Security and

Recovery (continued)

5. Planning Database Security and Recovery (continued)

Planning Database Recovery 5-6

Using Guardian Physical Names for SQL/MX Objects 5-6

Database Recovery Guidelines 5-7

Recovering Dropped Database Objects 5-8

Using TMF for Transaction Recovery, Database Consistency, and Database

Recovery 5-10

TMF Concepts 5-10

Levels of Database Recovery With TMF 5-11

SQL/MX Requirements for TMF 5-12

Guidelines for Configuring TMF 5-13

Guidelines for Creating and Managing Online Dumps 5-14

Operations That Impact TMF Online Dumps 5-15

Using the TMF DUMP FILES Command 5-17

TMF Considerations in Using MXCI 5-19

Using TMF In Recovery Operations 5-20

Using RDF to Set Up a Backup System 5-21

Using Guardian Physical Names for SQL/MX Objects 5-21

Configuring Disk Volumes for RDF 5-22

Creating RDF Backup Catalogs 5-22

Creating RDF Backup Schemas 5-22

Using Backup and Restore 2 to Create Offline RDF Backup Databases 5-23

Using Backup and Restore 2 for Database Recovery 5-27

Frequency of Backups 5-30

Backup Objects Hierarchy 5-31

SQL/MX Objects That Are Backed Up Explicitly 5-32

SQL/MX Objects That Are Backed Up Implicitly 5-33

SQL/MX Objects That Are Not Restored by BRCOM 5-34

Other Restrictions on Backup and Restore 2 Operations 5-34

Backing Up and Restoring OSS Program Files and SPJs 5-35

Using the RESTORE SHOWDDL ON Option to Re-Create Objects 5-36

6. Reviewing and Setting System Defaults

Setting and Updating System Defaults 6-1

Consequences of Inserting Rows Into the SYSTEM_DEFAULTS Table 6-2

New System Defaults for Release 2.0 6-3

New System Default for Release 2.1 6-6

Default Settings to Review After Installing NonStop SQL/MX 6-7

Alternative Settings For Selected System Defaults 6-7

Settings to Achieve ANSI Compliance 6-12