Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN backup behavior : backup compressed while not requested

3892668Apr 11 2019 — edited Apr 12 2019

Hi all,

A same database is backed up twice a day :

* daily FULL in FRA for rapid recovery

* daily INC on tapes for offsite backup purpose (MML)

The database specs : 9 TB of preallocated, 30% full => 3 TB foreseen for backup

Backup command used for MML :

---------------------------------------------

2> backup

3> incremental level 0

4> tag SID_INCREMENTAL_DATE

5> database

6> current controlfile

7> spfile

8> plus archivelog

9> ;

We have noticed that our MML backup seems to be compressed while not requested on backup launch.

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 6 BACKUP TYPE TO BACKUPSET;

Compression is set to BASIC :

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

This post has been answered by f10r1n-Oracle on Apr 12 2019
Jump to Answer
Comments
Post Details
Added on Apr 11 2019
4 comments
226 views