Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, vinod.

Asked: January 30, 2018 - 8:22 am UTC

Last updated: February 01, 2018 - 12:39 am UTC

Version: 11.2.0.0.4

Viewed 10K+ times! This question is

You Asked

Hi,

I want to keep archived logs for 5 days in physical location on windows.

can you please suggest on this ?

and Connor said...

I think this is not a good way to go about things.

The *duration* of archivelogs is less important than making sure they are backed up. So I would be setting an archivelog deletion policy to something like:

RMAN> configure archivelog deletion policy to backed up 2 times to disk;

Then when you issue "delete archivelog all", it will only delete those archives that have been backed up at least 2 times.

If you *really* want to use days, you can use RMAN to do:

RMAN> delete archivelog until time 'sysdate-5';


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Oracle DBA

VINOD KUMAR KORADA, January 31, 2018 - 2:54 am UTC

Clarified my doubt but i have one more doubt.
As per our RMAN Script backup retention period is 2 days. so after 2 days..will archive logs become a obsolete ?
Change archivelog all validate --> will it delete all archive log which are in obsolete state ? so Please clarify...
Connor McDonald
February 01, 2018 - 12:39 am UTC

If those archivelog backups also meet the requirements of your *archivelog* retention policy (eg backed up twice) then yes, they'll become obsolete.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.