Oracle rman compress 压缩于时间对比

最近八天备份情况

INPUT_TYPE    OUTPUT_DEVICE_TYP START_TIME             ET(Mins)  SIZE (GB) STATUS
------------- ----------------- -------------------- ---------- ---------- ----------
DB INCR       DISK              20241006 03:25:29           240        845                        COMPLETED
DB INCR       DISK              20241005 03:29:01           300        984                        COMPLETED
DB INCR       DISK              20241004 03:29:46            37        101                         COMPLETED
DB INCR       DISK              20241003 16:33:09           225      17530 (19817GB)   COMPLETED  
DB INCR       DISK              20241003 03:28:15            14         19                          COMPLETED
DB INCR       DISK              20241002 14:51:26          1074       3709(29107GB)     COMPLETED

30TB 压缩备份3.7TB  19TB 不压缩17TB  30TB 不压缩 28TB  7倍

29/20*225=330分钟 压缩后时间要原来的3.X 倍

               
 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
 Incr 0  697.86G    DISK        01:06:19     2024-10-03 18:45:54     

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
 Incr 0  692.05G    DISK        01:05:25     2024-10-03 17:39:08

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
 Incr 0  104.64G    DISK        03:33:41     2024-10-02 18:25:52         

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
 Incr 0  105.39G    DISK        03:37:21     2024-10-02 18:29:30
 

 
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 10 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES256';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO