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

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.2 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


.

Cause

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