Operating OnLine 3-47
Plan the Archive Schedule
Plan the Archive Schedule
Each of the following considerations affects the archive schedule you create
for your environment:
■If you want to minimize the time for a restore
■If you want to minimize the time to create an archive
■If you want to create online archives
■Ifyou must use the same tape drive to create archives and to back up
the logical logs
■If the operator is periodically unavailable
Try to avoid unscheduled archives. Because the following administrative
changes require a level-0 archive as part of the procedure, consider waiting
to make these changes until your next regularly scheduled level-0 archive:
■Changing a tape device pathname from/dev/null (archive after)
■Adding logging to a database (archive before)
■Mirroring a dbspace that contains logical log files (archive after to
initiate mirroring)
■Adding a logical log file (archive after to make log file available)
■Dropping a logical log file (archive after)
■Movingone or more logical log files (archives during the procedure)
■Changing the size of the physical log (archive after reinitializing
shared memory)
To ensure the integrity of your archives, periodically verify that all OnLine
dataand control information is consistent before you create a level-0 archive.
You need not perform this checking before every level-0 archive, but
Informixrecommends that you keep the necessary tapes from the most recent
archivecreated immediately after OnLine was verified to be consistent. Refer
topage 4-6 for a detailed explanation of this consistency check.
Duringa restore, OnLine reads and writes all relevant archive tapes to disk.
ThenOnLine reads all logical log files since the last archive and rolls the log
records forward. The time required to perform a restore is a function of two
things: