My Oracle Support Banner

Archivelogs in the FRA Area are Deleted in a Random Order When Space Pressure Arises (Doc ID 1608956.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Goal

Archivelogs from the Flash Recovery Area are deleted in a random fashion when space pressure occurs:

Mon Feb 11 16:28:10 2013
Deleted Oracle managed file  /<PATH> /2012_12_21/thread_1_seq_33035.999.802633791
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_21/thread_1_seq_33037.1003.802638649
Mon Feb 11 16:37:47 2013
Deleted Oracle managed file  /<PATH>g/2012_12_21/thread_1_seq_33038.903.802650623
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_22/thread_1_seq_33040.1007.802677627
Mon Feb 11 16:41:38 2013
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_22/thread_1_seq_33041.1146.802677785
Deleted Oracle managed file  /<PATH>/archivelog/2013_02_01/thread_1_seq_36401.1392.806241813

The logs in the 'gaps' from Feb 11th were deleted months later:

Mon Apr 01 12:30:38 2013
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_21/thread_1_seq_33036.1005.802636237

Mon Apr 01 22:30:22 2013
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_21/thread_1_seq_33039.963.802650809
Deleted Oracle managed file  /<PATH>/archivelog/2013_03_22/thread_1_seq_40906.1319.810725215

Mon Apr 15 08:25:59 2013
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_22/thread_1_seq_33042.1006.802740215
Mon Apr 15 08:45:36 2013
Deleted Oracle managed file  /<PATH>/archivelog/2012_12_23/thread_1_seq_33043.1010.802826671

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.