RMAN备份压缩你了解多少
admin
2023-04-16 12:02:20
0
1、RMAN备份默认已经进行压缩
1)不用的块压缩
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 back up 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)空块压缩
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.

小结:

1)这样我们可以解释了,为什么全备份输入的大小和输出的大小不一致了。
2)归档日志输入输出大小一致,说明不会做压缩,只有全归档日志备份。

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.20M
2018-10-04 13:00 ARCHIVELOG    COMPLETED      2.50G    SBT_TAPE       2.50G    00:03:24      12.54M     12.55M
2018-10-04 18:01 ARCHIVELOG    COMPLETED      2.17G    SBT_TAPE       2.17G    00:03:15      11.39M     11.39M
2018-10-04 19:01 ARCHIVELOG    COMPLETED      2.11G    SBT_TAPE       2.11G    00:03:29      10.33M     10.34M
2018-10-05 01:01 DB FULL       COMPLETED    686.17G    SBT_TAPE     565.61G    00:37:05     315.79M    260.31M
2018-10-05 06:00 ARCHIVELOG    COMPLETED      1.50G    SBT_TAPE       1.51G    00:03:14       7.94M      7.95M
2018-10-05 07:01 ARCHIVELOG    COMPLETED    992.30M    SBT_TAPE     993.00M    00:02:59       5.54M      5.55M
2018-10-05 12:01 ARCHIVELOG    COMPLETED      2.41G    SBT_TAPE       2.41G    00:03:14      12.73M     12.74M

相关内容

热门资讯

我来教教您“新猴王拼三张到底有... 有 亲,根据资深记者爆料新猴王拼三张是可以开挂的,确实有挂(咨询软件无需...
终于懂了“天天微友辅助器?”(... 您好:天天微友这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
今日重大消息“闽游麻将怎么开挂... 您好:闽游麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【4282891】很多玩家在这款游戏...
【今日要闻】“宁波游戏大厅有没... 家人们!今天小编来为大家解答宁波游戏大厅透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里...
玩家分享攻略“TT语音到底有挂... 家人们!今天小编来为大家解答TT语音透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里买很...
终于明白“瓦力棋牌真的有挂吗?... 家人们!今天小编来为大家解答瓦力棋牌透视挂怎么安装这个问题咨询软件客服徽9784099的挂在哪里买很...
玩家最新攻略“九酷众娱炸/金/... 玩家最新攻略“九酷众娱炸/金/花辅助器?”(其实是有挂)您好,九酷众娱炸/金/花这个游戏其实有挂的,...
日媒炒作“台湾有事,美军放弃撤... 【环球时报报道 记者 郭媛丹】日本共同社27日报道称,因考虑台湾突发事态,美军修改了原先拟将驻冲绳海...
玩家分享攻略“青鸾牛牛有挂吗?... 玩家分享攻略“青鸾牛牛有挂吗?”(果然有透视挂)您好,青鸾牛牛这个游戏其实有挂的,确实是有挂的,需要...
终于懂了“微乐云南麻将真的有挂... 您好:微乐云南麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9784099】很多玩家在这款...