At what stage can you safely delete archive logs?

    Requires Free Membership to View

When recovering from a failure you will need a backup and all archived redo logs created since that backup. So you do not need any archived redo logs before that backup. That being said, some DBAs like to keep the last three backups around, just in case something went wrong with the latest backup. So you will need to keep the archived redo logs since the oldest of those backups.

RMAN can also be used to back up your archived redo logs. This is a great way to get those archived redo logs off of your LOG_ARCHIVE_DEST and free up some space. RMAN can even be instructed to delete the archived redo logs after it has backed them up. You may want to look into this option as well.

This was first published in September 2006

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: