Archivelogs in the FRA are deleted in a random order when space pressure arises (Doc ID 1608956.1)

Last updated on DECEMBER 22, 2016

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 +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_21/thread_1_seq_33035.999.802633791
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_21/thread_1_seq_33037.1003.802638649
Mon Feb 11 16:37:47 2013
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_21/thread_1_seq_33038.903.802650623
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_22/thread_1_seq_33040.1007.802677627
Mon Feb 11 16:41:38 2013
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_22/thread_1_seq_33041.1146.802677785
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/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 +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_21/thread_1_seq_33036.1005.802636237

Mon Apr 01 22:30:22 2013
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/archivelog/2012_12_21/thread_1_seq_33039.963.802650809
Deleted Oracle managed file +DGRECOVERY_RIALTO/rialto/archivelog/2013_03_22/thread_1_seq_40906.1319.810725215

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

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms