My Oracle Support Banner

Rman Backup Very Slow After Mass Deletion Of Expired Backups (Disk, Tape) (Doc ID 465378.1)

Last updated on MARCH 02, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

RMAN back is suddenly running very slowly after having deleted a large number of backups.

TKPROF shows problem sql is:

SELECT RECID , STAMP , TYPE OBJECT_TYPE , OBJECT_RECID , OBJECT_STAMP ,
OBJECT_DATA , TYPE , ( CASE WHEN TYPE = 'DATAFILE RENAME ON RESTORE' THEN
DF.NAME WHEN TYPE = 'TEMPFILE RENAME' THEN TF.NAME ELSE TO_CHAR ( NULL )
END) OBJECT_FNAME , ( CASE WHEN TYPE = 'DATAFILE RENAME ON RESTORE'
THEN DF.CREATION_CHANGE# WHEN TYPE = 'TEMPFILE RENAME' THEN
TF.CREATION_CHANGE# ELSE TO_NUMBER ( NULL ) END) OBJECT_CREATE_SCN ,
SET_STAMP , SET_COUNT
FROM
V$DELETED_OBJECT , V$DATAFILE DF , V$TEMPFILE TF WHERE OBJECT_DATA =
DF.FILE# (+) AND OBJECT_DATA = TF.FILE# (+) AND RECID BETWEEN :1 AND
:1 AND ( STAMP >= :1 OR RECID = :1 ) AND STAMP >= :1 ORDER BY RECID


.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.