SQL/MP Installation and Management Guide

Moving a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
9-5
DUP and BACKUP/RESTORE
•
BACKUP/RESTORE allows these options:
°
Choosing either automatic duplication or explicit duplication for dependent
indexes
°
Using tape handling features
°
Automatically moving protection views with the underlying table
°
Explicitly duplicating shorthand views named in a file set list
°
Automatically SQL-compiling program files upon restoration with the
SQLCOMPILE ON option
°
Automatically creating necessary catalogs with the AUTOCREATECATALOG
ON option
°
Copying the source object while other users have access to the object
°
Choosing either automatic duplication or explicit duplication of individual table
and index partitions
To handle SQL files, both the BACKUP and RESTORE processes must be licensed.
During a typical INSTALL operation, both BACKUP and RESTORE are licensed
automatically. In special circumstances, sites might deliberately create unlicensed
BACKUP and RESTORE object files, but these processes cannot access SQL files.
The success of the DUP and BACKUP/RESTORE operations depends upon several
factors, including whether operations involve different versions of SQL/MP software
and different versions of SQL objects.
Guidelines for DUP Operations
You cannot perform a DUP operation within a user-defined TMF transaction. If the
source object is audited, the DUP command completes the DUP operation on a
nonaudited target object and then automatically changes the AUDIT attribute to AUDIT
as the operation completes. BACKUP and RESTORE can move audited files by using
the AUDITED option, in the same manner as DUP. You must make TMF online dumps
of all restored audited objects, after using DUP or RESTORE, to create a new recovery
point.
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.