Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 427 / 536

CHAPTER 11 Backup and Data Recovery
407
In an IQ Multiplex, you must restore on the write server in simplex mode, and
synchronize the query server following the completion of the restore. For more
information on multiplex restores, see Adaptive Server IQ Multiplex User’s
Guide.
This restriction extends to any incremental restores you may need if your
system crashes during recovery. If you need to recover from a system or media
failure that occurs during a restore, you must do one of the following:
• Continue the original sequence of full and incremental restore operations,
or
• Perform a full restore, followed by any incremental restores needed to
fully recover your database.
The default database server startup setting
-gd DBA
makes DBA privileges a
requirement for starting up a database. When the DBA runs
RESTORE
, the
command automatically starts the database, gets the information it needs for
the restore, and then stops the database. At the end of the restore, the command
starts the database, issues a checkpoint, and stops it again. This procedure
ensures that the DBA has exclusive write access throughout a restore.
When all incremental restores are complete, the DBA issues the
START
DATABASE
command again to allow other users access to the database.
Displaying header information
You can display the contents of the header file by using the
RESTORE
statement with the
CATALOG ONLY
option and no
FILE
clauses. The header file
includes the following information:
• Database name
• Database type (Adaptive Server IQ or Adaptive Server Anywhere)
• Backup creation date
• Approximate number of tapes or disk files in the backup
• User who did the backup
• Backup type (full, incremental, or incremental-since-full)
• Medium (always Othr)
• Number, type, and size of dbspaces