My Oracle Support Banner

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

Last updated on FEBRUARY 03, 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 +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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.