Shulou(Shulou.com)06/01 Report--

1. RMAN backup has been compressed by default. 1) unused block compression When employing unused block compression, RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated.So if a database table is dropped, RMAN will not backup the space that was occupied by that table until new objects are created in that space.Unused block compression is used automatically when the following conditions are true:The COMPATIBLE initialization parameter is set to 10.2 or higher.There are currently no guaranteed restore points defined for the database.The data file is locally managed.The data file is being backed up to a backup set as part of a full backup or a level 0 incremental backup.The backup set is created on disk Or Oracle Secure Backup is the media manager.2) empty block compression When employing null block compression, RMAN omits from its output any block that has never contained data.Null block compression is always used with level 0 or full backups that are created in backup set format. Summary: 1) in this way we can explain why the size of the full backup input is not the same as that of the output. 2) the input and output of archived logs are the same, which means that there will be no compression, only full archived log backups. START_TIME INPUT_TYPE STATUS INPUT_SIZE DEVICE_TYP OUTPUT_SIZE TIME_TAKEN IN_SPEED OUT_SPEED -2018-10-04 12:01 ARCHIVELOG COMPLETED 2.58G SBT_TAPE 2.58G 00:03:06 14.20M 14.20M2018-10-04 13:00 ARCHIVELOG COMPLETED 2.50G SBT_TAPE 2.50G 00:03:24 12.54M 12.55M2018-10-04 18:01 ARCHIVELOG COMPLETED 2 .17G SBT_TAPE 2.17G 00:03:15 11.39M 11.39M2018-10-04 19:01 ARCHIVELOG COMPLETED 2.11G SBT_TAPE 2.11G 00:03:29 10.33M 10.34M2018-10-05 01:01 DB FULL COMPLETED 686.17G SBT_TAPE 565.61G 00:37:05 315.79M 260.31M2018-10-05 06:00 ARCHIVELOG COMPLETED 1.50G SBT_TAPE 1.51G 00:03:14 7.94M 7.95M2018-10-05 07:01 ARCHIVELOG COMPLETED 992.30M SBT_TAPE 993.00M 00:02:59 5.54M 5.55M2018-10-05 12:01 ARCHIVELOG COMPLETED 2.41G SBT_TAPE 2.41G 00:03:14 12.73M 12.74m

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.