Henry
Care must be taken when determining which log files to delete. At the time
of the backup we record what log file contains the start of the oldest
active transaction. If this image is restored then this will be the first
log file that rollforward will need.
For example
Txn A starts at 09:00 in log file 100
online backup started at 16:00 and the current log file is 120
online backup completed at 17:00 and the current log file is 130
Txn A completes at 18:00 and the current log file is 140
In this scenario you will need all log files starting at 100 to
successfully roll the database to a consistent point. This information is
located in the history file.
Regards,
_____________________________________________
Dale M. McInnis IBM Toronto Lab
Senior Technical Manager, DB2 UDB Backup, Data Protection and Recovery
Email: [EMAIL PROTECTED]
Phone: (416) 448-2397, Fax: (416) 448-4414, T/L: 778-2397
|--------+-------------------------------->
| | "Henry J. Cobb" |
| | <[EMAIL PROTECTED]> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | a.best.com |
| | |
| | |
| | 04/10/2001 09:22 AM |
| | Please respond to |
| | db2eug |
| | |
|--------+-------------------------------->
>-----------------------------------------------------------------------------------------------------------|
|
|
| To: [EMAIL PROTECTED]
|
| cc:
|
| Subject: DB2EUG: Tossing archivelogs
|
|
|
|
|
>-----------------------------------------------------------------------------------------------------------|
I've been thinking that if you're doing rotating online backups (to remain
continuously up, 24x7x365.25) your script should simply delete all archive
logs older than the last backup you care to keep and it might be nice to
backup (and remove) all logs older than than the active log when the
current backup was started, once it's completed successfully.
Henry J. Cobb [EMAIL PROTECTED]
http://www.io.com/~hcobb
Any sufficiently cool technology is indistinguishable from religion.
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
