Database Administration (MOSC)

MOSC Banner

archivelog are marked unreclaimable when they should be deleted

edited Feb 26, 2014 4:22PM in Database Administration (MOSC) 9 commentsAnswered

Archivelogs in the FRA are marked reclaimable after each backup. But after a while, when oracle is deleting olds backuped archivelogs in order to get more free space in the FRA, sum of these are marked 'not reclaimable'. So they are never deleted and reclaimable space in the FRA is shortenning.

This seem to be a random behavior. Sometimes, all old backuped archivelogs are deleted, sometimes not.

This is not the same problem as in Bug 14227959 : STANDBY DID NOT RELEASE SPACE IN FRA.

we tried :

CONFIGURE ARCHIVELOG POLICY ...

then

dbms_backup_restore.refreshagedfiles

but nothing happened.

Any idea ?

database Version 11.2.0.3 RAC with two nodes. No dataguard

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center