Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

When and how to delete archive logs

3817829Dec 28 2018 — edited Jan 20 2019

Hi Guys,

We are still not go live with our production database and we have enabled achieve logs on this database.

Since archive logs are building up in numbers, we may have space related issue.

What I know:

archive logs help us to do a Point in time recovery. Also after enabling archive log one can take a consistent backup of database without downtime.

What I don't know:

1. Since we are taking daily full backup. Can I safely delete archive logs through rman which were created before this backup. Can i get command for this.

2. Also can i get rman command to safely delete the archive logs that are older then 2 days.?

3. What should be my approach so that I can have archive logs related to at least last 2 full backups.

Comments
Post Details
Added on Dec 28 2018
14 comments
21,709 views