SQL/MP Installation and Management Guide

Contents
HP NonStop SQL/MP Installation and Management Guide—523353-004
viii
11. Performing Recovery Operations (continued)
11. Performing Recovery Operations (continued)
Restoring Programs 11-6
Restoring Databases 11-7
Completing the Planning Phase 11-8
Restoring a Database as a Planned Event 11-9
Restoring a Database as an Unplanned Event 11-10
Recovering Consistent Files by Resetting the BROKEN Flag 11-11
Restoring Objects With TMF Recovery Operations 11-11
Database Recovery After a Disk or Node (System) Failure 11-12
Volume Recovery 11-12
File Recovery 11-13
File Recovery With the TIME Option 11-14
Recovering Purged SQL Tables 11-14
Operations That Invalidate TMF Online Dumps 11-15
Responding to Accidental Loss of an Audited SQL/MP Object 11-17
Recovery Precautions 11-17
Recovering Views and Indexes 11-18
Recovering Tables 11-19
Recovery Example 11-20
Recovering Catalogs 11-29
Purging Damaged Objects With the CLEANUP Utility 11-29
Recovering From Peripheral Utility Program (PUP) Commands (D-series only) 11-31
PUP LABEL 11-31
PUP RENAME 11-32
PUP FORMAT 11-33
PUP REMOVE and PUP REVIVE 11-33
PUP DOWN (or PUP REMOVE) and PUP UP 11-33
SCF Commands (G-series only) 11-35
SCF ALTER DISK, LABEL 11-35
SCF RENAME 11-35
SCF INITIALIZE DISK 11-35
SCF STOP DISK and SCF START DISK 11-35
SCF STOP and SCF START 11-35
Managing Shadow Disk Labels 11-36
Identifying Shadow Labels 11-36
Removing Shadow Labels 11-36