SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Contents
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
xi
12. Performing Recovery Operations
12. Performing Recovery Operations
Recovering Databases After Disk or Node Failures 12-1
Recovering Disk Volumes 12-2
Recovering Files 12-2
Recovering Files With the TIME Option 12-3
Recovering Files to New Locations 12-4
Recovering Metadata 12-6
Recovering Database Objects 12-7
Recovering Range Partitions 12-7
Recovering SPJs
12-8
Recovering Tables
12-8
Recovering Views and Indexes 12-22
Restoring Objects With BRCOM RESTORE 12-22
Restoring Catalogs 12-23
Restoring Schemas 12-23
Restoring Tables and Partitions 12-23
Restoring Indices and Index Partitions 12-24
Using SHOWDDL 12-24
Repairing Damaged SQL/MX Metadata and Objects 12-25
Strategies for Repairing Damaged Metadata and Objects 12-25
Identifying Problem Data and Objects 12-27
Using FIXUP to Correct Problem Data and Objects 12-32
Examples of Using FIXUP 12-35
Using GOAWAY to Delete Damaged Objects 12-37
Recovering From SCF Commands
12-37
ABORT DISK 12-37
ALTER DISK, ALTNAME and ALTER DISK, VOLNAME
12-38
ALTER DISK, LABEL
12-39
INITIALIZE DISK
12-39
START DISK and STOP DISK 12-40
13. Managing an SQL/MX Distributed Database
Managing a Locally Distributed SQL/MX Database 13-1
Managing a Network-Distributed SQL/MX Database 13-2
SQL/MX Distributed Database Features 13-3
Naming Network Nodes
13-6
Naming SQL/MX Database Objects
13-6
Using Catalog References in an SQL/MX Distributed Database 13-8
Managing Network Security 13-11