SQL/MP Installation and Management Guide

Planning Database Security and Recovery
HP NonStop SQL/MP Installation and Management Guide—523353-004
4-19
Daily Backups
•
BACKUP has two formats for files: ARCHIVEFORMAT and DP2FORMAT.
ARCHIVEFORMAT is the default used by BACKUP when a system includes
SQL/MP. If you need to back up non-SQL files with DP2FORMAT, you must specify
a file set list that does not contain any SQL objects and specify DP2FORMAT in
the BACKUP command.
•
If your system has only one tape drive, be careful not to perform a long backup at a
time when the TMF subsystem might also need to dump an audit trail to tape.
Before starting the backup, verify the status of the TMF audit trails to make sure no
dump is currently queued. If the TMF subsystem reaches its maximum file limit
during a period when the tape drive is unavailable for audit trail dumping, the TMF
subsystem suspends transaction processing until an audit trail is dumped.
•
If your system has multiple tape drives, you can use one drive for backups and
another for the TMF audit-trail dumps.
•
BACKUP accepts a qualified file set list for file-mode backups. You can use
DEFINE names for the tape drive name and within the qualified file set list.
BACKUP has many parameters that can improve the performance of tape
handling, qualify the file set list, ignore errors, verify tape validity, and perform
conversion between file types. For information about these parameters, see the
Guardian Disk and Tape Utilities Reference Manual.
Daily Backups
To provide a high degree of protection, you can perform daily backups. Then the
maximum amount of data lost from a failure never exceeds one working day.
A daily backup could be either a full backup of all files or a limited backup of specific
files. If you use limited daily backups, you should also perform periodic full backups, as
explained in Periodic Full Backups on page 4-20.
This example shows a BACKUP command to perform a full backup on all Enscribe
files and on all SQL audited and nonaudited files (except catalogs) on the local node:
BACKUP $TAPE, *.*.* , AUDITED, OPEN, LISTALL
For recovering a volume separately, it can be helpful to perform the backup by volume
name. This technique provides the same protection as the preceding command but
separates each volume on a set of tape reels.
This example backs up volumes separately:
BACKUP $TAPE, $SYSTEM.*.*, AUDITED, OPEN, LISTALL
BACKUP $TAPE, $VOL1.*.*, AUDITED, OPEN, LISTALL
...
BACKUP $TAPE, $VOL9.*.*, AUDITED, OPEN, LISTALL
Caution. If an SQL object has the UNRECLAIMED FREESPACE (F) or INCOMPLETE
SQLDDL OPERATION (D) attribute set, do not attempt to back up, move, or duplicate the
object until the attribute is reset. For more information, see UNRECLAIMED FREESPACE (F)
and INCOMPLETE SQLDDL OPERATION (D) Flags on page 7-24.