Chapter 4 Database Administration Utilities
81
♦
Step 2 The current transaction log remains in its current directory, but
is renamed using the format
yymmdd
xx.
log
, where xx is a number from
00 to 99 and
yymmdd
represents the current year, month and day. This
file is then no longer the current transaction log.
♦
Step 3 A new transaction log file is generated that contains no
transactions. It is given the name of the file that was previously
considered the current transaction log, and is used by the database server
as the current transaction log.
Back up the transaction log file only (–t) This can be used as an
incremental backup since the transaction log can be applied to the most
recently backed up copy of the database file(s).
Back up the database write file only (–w) For a description of database
write files, see "The Write File utility" on page 151.
Delete and restart the transaction log (–x) Back up the existing
transaction log, then delete the original log and start a new transaction log.
This option causes the backup to wait for a point when all transactions from
all connections are committed.
Delete and restart the transaction log without a backup (–xo) Delete
the current transaction log and start a new one. This operation does not carry
out a backup; its purpose is to free up disk space in non-replication
environments.
Operate without confirming actions (–y) Choosing this option creates
the backup directory or the replacement of a previous backup file in the
directory without confirmation.
To Next Page
Loading...