Home |
Previous Page | Next Page Logging and Log Administration > Logical Log >
If you back up a logical-log file, that file is not necessarily
free to receive new log records. The following criteria must be
satisfied before the database server frees a logical-log file for
reuse:
-
The log file is backed up.
- No records within the logical-log file are associated with open
transactions.
- The logical-log file does not contain the oldest
update not yet flushed to disk. Perform a full checkpoint using
the onmode -c command to ensure that the logical-log
file does not contain the oldest update.
Tip:
You can free a logical log with a status of U-B (and
not L) only if it is not spanned by an
active transaction and does not contain the oldest update.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]