HPlogo ALLBASE/SQL Database Administration Guide: HP 3000 MPE/iX Computer Systems

Chapter 6 Backup and Recovery

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Table of Contents

Choosing an Approach to Backup and Recovery
Choosing Nonarchive Logging
Choosing Archive Logging
Understanding Log File Types
Understanding the LOG FULL Condition
Using Single or Dual Logs
Using Multiple Log Files
Log Names and Numbers
Using Nonarchive Logs
Using Archive Logs
Choosing Full or Partial Backup Procedures
Choosing Full or Partial Recovery Procedures
Backup and Recovery Procedures for Nonarchive Logging
Nonarchive Backup Procedures
Adding Files to the Nonarchive Log
Nonarchive Full Recovery Procedures
Nonarchive Partial Recovery Procedures
Backup and Recovery Procedures for Archive Logging
Online Backup Procedures in Archive Mode
Static Full or Partial Backup Procedures in Archive Mode
Adding Files to the Archive Log
Archive Recovery Procedures
ALLBASE/SQL Interface to True Online Backup
Managing Log Files
Monitoring the Log with SHOWLOG
Adding Log Files with ADDLOG
Storing Log Files with STORELOG
Rescuing Log Files with RESCUELOG
Restoring Log Files with RESTORELOG
Purging Log Files with PURGELOG
Moving Log Files with MOVELOG
Starting a New Log
Monitoring the Log with SQLMON
Setting up a Wrapper DBEnvironment
Selecting Valid Log Files with SHOWLOG
Creating a DBEnvironment
Wrapping the DBEnvironment Around the Log Files
Example of Setting Up a Wrapper DBE

Backup and recovery are activities that let you reconstruct your DBEnvironments in the event of database corruption or damage to your system. The type of backup and recovery you can perform depends in part on whether you choose archive or nonarchive logging for your system. The following activities are described in the sections that follow:

  • Choosing an approach to backup and recovery

  • Understanding log file types

  • Choosing full or partial backup procedures

  • Choosing full or partial recovery procedures

  • Backup and recovery procedures for nonarchive logging

  • Backup and recovery procedures for archive logging

  • ALLBASE/SQL interface to True Online Backup

  • Managing log files

  • Starting a new log

  • Monitoring the log with SQLMON

  • Setting up a wrapper DBEnvironment

Once you have chosen a logging approach for your system, use the appropriate sections below to carry out these tasks.

Feedback to webmaster