Ask the Expert

When can I delete previously backed-up archive files?

I have to back up the archive logs regularly in order to recover from a crash. If i take a complete database backup, after some number of days, can I delete those previously backed up archive files and start with fresh archive log backups?

    Requires Free Membership to View

Your archived redo logs and your backup go hand in hand. Let's say that I backup my database on Saturday. Then the database crashes on Wednesday. In order to restore fully, I need Saturday's backup and all of the archived redo logs since then. So for that reason, I tend to think that the archived redo logs are tied to the backup. Without the backup, the archived redo logs are of little use. And without the archived redo logs, the backup is only as good as the day it was taken.

Many DBAs like to keep multiple backups on hand. We call these generations of backups. The latest backup is generation zero (0). The backup prior to that is generation minus 1 (-1). This type of terminology is from the old mainframe days. Many installations keep many generations available. How many generations? It all depends on the company's policy. Some only keep three generations. Some keep size generations. Some keep enough generations to hold backups for an entire year! It all depends.

I've already discussed how the archived redo logs are "tied" to the backup. If you decide to keep three generations of backups, then you need to keep the archived redo logs for those three backup generations. Once you delete a backup, the archived redo logs from that backup to the next backup are no longer valid. So you can delete those as well.

For More Information

This was first published in July 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: