My Oracle Support Banner

RMAN Sparse Backup Is Full Size (not Sparse Data) (Doc ID 2437886.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Running rman backup of a CDB with 2 Test Masters in DATA1 disk group and 5 new Sparse Clones with files in Sparse1 disk group.

SQL> select substr(name,1,8) FN, round(sum(bytes)/1024/1024/1024) size_GB from v$datafile
        group by substr(name,1,8);

FN SIZE_GB
-------------------------------- ----------
+DATA1/L 236
+SPARSE1 637

RMAN backup job should only backup data1 files and delta blocks in sparse (all thin clones are new so delta blocks should be small)

run {
backup AS SPARSE BACKUPSET
incremental level 0
filesperset=1
section size 64G
format '/nas/<path>/df.d%d.t%t.s%s.p%p'
(database);
}

Size of backupset files are much larger than they should be for a sparse database backup.  This started after applying the 12.2.0.1.180116 DBJAN2018RU patchset to to the database.

$ du -sh ./6496690*
727G ./6496690

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.