rman中压缩备份集

最新推荐文章于 2021-09-17 21:43:49 发布

conghan9137

最新推荐文章于 2021-09-17 21:43:49 发布

阅读量221

点赞数

文章标签：数据库

前两天在一个装有10G的PC SERVER上进行rman备份,进行了多次备份,都在备份脚本运行一段时间后就停止了,也不返回错误很是郁闷。
但是发现CPU使用率很高。仔细看了看rman脚本,发现脚本中对备份集进行了压缩 as compressed backupset, 这是10G rman的新增功能。
最后修改了备份脚本,去掉备份集压缩选项,备份成功。看来这压缩大有文章啊
今天对压缩和不压缩备份集进行了测试,在测试过程中用vmstat对系统进行了跟踪

export ORACLE_SID=rac1
[oracle@rac1 rman]$ rman target /

Recovery Manager: Release 10.1.0.5.0 - Production

connected to target database: RAC (DBID=2213666500)

[@more@]

不压缩备份集RMAN> backup database include current controlfile format '/u01/rman/dbfull_%s_%t_%p.rman' plus archivelog format '/u01/rman/archivelog_%s_%t_%p.rman';
Starting backup at 20-JUL-07
current log archived
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=274 recid=1 stamp=628395327
input archive log thread=1 sequence=275 recid=2 stamp=628395564
input archive log thread=1 sequence=276 recid=3 stamp=628395832
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/archivelog_4_628395834_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 20-JUL-07

Starting backup at 20-JUL-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/rac/datafile/system.256.1
input datafile fno=00003 name=+DATA/rac/datafile/sysaux.257.1
input datafile fno=00002 name=+DATA/rac/datafile/undotbs1.258.1
input datafile fno=00004 name=+DATA/rac/datafile/users.259.1
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/dbfull_5_628395838_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:56
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/dbfull_6_628395955_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 20-JUL-07

Starting backup at 20-JUL-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=277 recid=4 stamp=628395965
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/archivelog_7_628395965_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 20-JUL-07

vmstat 跟踪结果

[oracle@rac1 asm]$ vmstat 2
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
1 2 79660 1772 2256 160660 3 12 112 70 1022 580 3 10 85 2
0 0 79660 1788 2272 160660 0 0 113 323 935 704 4 13 63 20
0 2 81112 1144 2280 160984 52 790 4337 1580 1120 1006 15 40 19 25
1 0 96600 2064 2288 159292 0 6918 9747 7003 1018 781 5 39 0 56
0 4 115472 2336 2300 164304 32 12198 7759 20169 971 713 9 44 0 47
1 1 115472 1632 2320 173520 0 0 8483 799 987 702 6 27 0 67
1 2 121480 1648 2136 185576 0 4232 10257 7633 980 729 7 35 0 58
0 5 126460 1820 924 185144 0 560 9001 15646 963 753 7 32 0 61
5 1 137428 2144 812 181756 0 3584 6683 5209 989 735 5 26 0 69
0 4 140100 1948 712 185052 238 228 14861 2333 976 741 9 39 0 52
0 4 142460 2400 576 185312 112 1838 6829 14643 990 759 5 26 0 69
3 2 142472 1248 580 186604 0 18 11019 52 970 739 10 33 0 57
0 5 143136 1760 552 187312 0 48 10225 79 980 781 7 33 0 61
0 6 143140 1908 612 187620 0 2488 3753 21567 984 720 7 25 0 68
1 5 144560 2144 724 193032 4 2822 11147 2831 963 766 9 35 0 56
0 5 144556 1996 820 190176 16 1108 10643 16530 995 791 12 48 0 41
2 5 144556 772 876 193560 96 1186 7725 1251 980 840 4 26 0 69
2 3 144556 800 900 197316 96 2 13299 41 993 1041 9 39 0 52
0 3 145088 2160 908 196292 0 332 5937 17883 979 715 5 25 0 70
0 2 145276 2112 888 198344 36 6 13083 17 939 777 11 35 0 55
0 4 149808 1432 868 195232 16 914 11063 21435 950 767 9 37 0 54
3 3 150592 1496 912 196332 60 96 4979 369 1030 697 5 18 0 77
3 3 150928 1952 924 194456 212 0 10509 18 967 759 8 38 0 54
0 5 150980 812 968 195220 16 0 6259 17005 998 731 6 26 0 68
0 3 151392 2236 944 192668 62 300 9663 339 956 720 9 36 0 56
2 6 151336 2104 976 189008 144 172 13565 16616 978 801 9 43 0 48
3 8 151264 1692 1020 191836 68 1124 5447 1252 995 750 4 22 0 74
0 2 151164 2120 1016 196416 128 902 8289 941 984 840 8 39 0 53
3 0 151192 2284 1024 196996 114 306 7365 17243 992 739 5 27 0 68
3 1 151164 2072 1040 197232 96 66 22813 101 964 753 12 40 0 48
0 4 151132 1624 1008 197080 84 50 15915 8790 962 798 8 41 0 50
0 2 151068 2184 964 196868 138 36 13443 67 980 753 8 33 0 59
0 5 150988 752 896 199576 84 212 13879 257 973 811 9 44 0 47
0 4 150956 2096 876 198892 50 10 4475 21072 994 727 5 27 0 68
1 3 150864 2144 848 198476 80 14 11811 29 964 751 8 38 0 54
0 4 150848 1952 828 197260 128 22 9863 21084 965 762 8 44 0 49
0 4 150844 1248 840 199344 16 0 4255 35 999 693 5 18 0 77
3 3 151056 840 788 198520 172 58 12903 104 980 824 10 47 0 43
0 8 151920 2256 788 195824 36 608 6059 21835 992 724 8 27 0 65
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
2 2 151812 1056 768 199144 60 0 6317 215 1004 732 7 27 0 66
0 5 151952 2144 704 196836 312 128 11931 18432 965 774 8 40 0 53
1 3 152104 1436 696 198504 222 60 5607 115 970 702 5 23 0 72
0 4 152800 2080 632 197956 246 324 8823 350 947 755 7 31 0 62
0 7 152716 2680 592 197112 118 0 6287 19323 964 699 6 25 0 70
1 1 152992 1504 520 198716 202 148 12015 195 941 772 8 39 0 53
3 3 152864 1568 504 197504 492 100 8753 17149 990 770 7 40 0 53
0 4 152712 1872 536 199664 58 0 5533 78 984 698 5 26 0 69
0 4 152692 1504 612 199696 32 0 10527 43 982 758 8 38 0 54
0 8 152616 2592 660 197596 76 8 6457 20613 973 729 7 28 0 64
2 3 152528 2016 740 198540 36 0 9179 81 969 809 8 37 0 55
3 2 152396 1720 768 196620 200 112 11039 10111 986 811 11 51 0 39
1 4 152340 2144 788 197076 98 0 5771 9065 998 717 5 24 0 71
2 2 152136 1820 808 196724 280 0 12231 91 957 774 9 40 0 52
0 6 152064 2144 780 195616 134 0 9593 19001 988 737 7 34 0 59
3 2 151796 1696 740 196320 400 0 12151 745 982 755 8 36 0 56
3 2 151364 1320 760 196212 644 0 1453 7219 1018 878 4 31 0 65
0 2 147548 2092 740 193524 2334 0 2715 247 1093 889 8 31 0 61
0 2 147068 1280 760 193928 398 0 1477 282 1023 989 10 43 0 47
0 2 146892 1316 828 192644 418 0 2077 315 1025 970 8 38 0 54
2 2 146768 1468 948 191728 76 0 1593 67 1018 901 7 37 0 56
1 3 146688 4060 1052 190276 134 0 1915 466 1051 950 17 49 0 34
0 4 146608 2044 1052 191116 58 0 5639 4917 1061 873 5 40 0 55
2 3 144428 1304 1048 190616 1884 0 2122 226 1069 968 5 28 0 67
0 2 144356 1632 1064 186540 40 0 1573 4941 1031 849 9 36 0 55
2 0 144228 4552 1112 187108 54 0 1578 836 1080 1025 9 45 0 46
2 0 143948 3256 1152 187940 202 0 1468 717 1013 847 8 25 37 30
0 0 143948 2168 1192 188520 0 0 744 628 944 745 7 15 73 5
0 3 143944 1968 1184 186900 0 0 5869 4981 1074 832 5 28 7 60
0 0 143900 3464 1176 185988 12 0 1129 252 1007 798 19 40 18 23
0 0 143900 3480 1184 185988 0 0 273 31 903 635 3 11 86 1
0 0 143900 3484 1192 185988 0 0 35 15 901 661 3 11 86 0

压缩备份集

RMAN> backup as compressed backupset database include current controlfile format '/u01/rman/dbfull_%s_%t_%p.rman' plus archivelog format '/u01/rman/archivelog_%s_%t_%p.rman';

Starting backup at 20-JUL-07
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=274 recid=1 stamp=628395327
input archive log thread=1 sequence=275 recid=2 stamp=628395564
input archive log thread=1 sequence=276 recid=3 stamp=628395832
input archive log thread=1 sequence=277 recid=4 stamp=628395965
input archive log thread=1 sequence=278 recid=5 stamp=628396388
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/archivelog_8_628396389_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 20-JUL-07

Starting backup at 20-JUL-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=+DATA/rac/datafile/system.256.1
input datafile fno=00003 name=+DATA/rac/datafile/sysaux.257.1
input datafile fno=00002 name=+DATA/rac/datafile/undotbs1.258.1
input datafile fno=00004 name=+DATA/rac/datafile/users.259.1
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/dbfull_9_628396393_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current controlfile in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 20-JUL-07
channel ORA_DISK_1: finished piece 1 at 20-JUL-07
piece handle=/u01/rman/dbfull_10_628396529_1.rman comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 20-JUL-07

vmstat 跟踪结果

[oracle@rac1 asm]$ vmstat 2
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
2 1 143540 1668 2308 173424 4 18 207 139 1023 589 3 10 84 2
2 1 143580 2016 2276 173152 0 0 8209 26 901 636 79 21 0 0
3 0 143916 2140 2200 172676 2 20 8997 2885 905 655 74 26 0 0
2 0 144048 2144 2108 173084 0 78 9233 357 918 635 79 21 0 0
1 1 144048 1376 2044 173956 0 14 10769 40 902 643 77 23 0 0
3 1 144256 1772 2060 173580 0 84 7203 3191 913 647 78 22 0 0
3 1 144476 2160 2056 173168 0 20 6673 49 889 637 78 22 0 0
5 2 144520 2000 2052 173348 0 76 8227 2784 914 661 77 23 0 0
2 0 144524 2180 2028 173468 0 46 5905 507 914 627 79 21 0 0
2 0 144592 2072 1980 173768 0 8 7443 39 906 614 79 21 0 0
1 2 145168 2064 1316 173892 0 26 8483 3653 926 643 77 23 0 0
1 0 145616 2152 1108 174136 0 102 6929 169 909 626 79 21 0 0
2 1 145940 1768 1028 175732 2 30 9501 56 915 660 78 22 0 0
3 0 146132 2144 956 176468 0 156 7441 3787 918 609 72 23 0 5
2 1 146240 1624 808 177624 0 130 7699 171 912 614 78 21 0 2
2 0 146976 1344 716 178268 0 204 7715 230 925 644 78 22 0 0
2 1 147008 1376 716 180100 0 64 6929 3175 905 616 75 21 0 5
2 1 147124 1616 724 180104 0 86 8227 123 901 639 77 23 0 0
2 0 147284 2172 728 179304 0 36 6929 3152 920 631 79 21 0 0
2 1 147292 1848 768 179532 42 10 5525 47 917 652 77 23 0 0
2 4 153080 1288 808 175660 42 1360 5401 1427 966 720 65 35 0 0
2 0 153212 4336 784 175836 2 10 6219 2632 916 626 65 35 0 0
1 1 153208 1556 792 178540 2 0 7975 7 914 617 77 23 0 0
2 1 153208 1496 792 178668 0 12 10249 83 905 623 77 23 0 0
1 0 153208 2072 764 178424 0 92 6417 3210 915 625 77 19 0 4
2 1 153208 1568 616 179400 16 48 4915 55 912 642 77 21 0 1
2 0 153208 2440 640 181088 0 0 6969 3643 913 615 75 21 0 4
1 0 153208 1440 640 182112 0 0 27939 26 912 666 49 37 0 14
4 0 153212 2352 652 180808 0 10 21783 27 905 618 56 40 0 4
3 3 153212 1376 696 181924 0 10 8781 1591 910 604 78 22 0 0
2 0 153272 1464 764 180284 80 78 6963 115 942 675 73 27 0 0
2 1 153272 1248 764 180604 10 8 7195 85 913 633 80 20 0 0
2 1 153272 1376 764 180584 0 10 6179 3151 915 643 80 20 0 0
2 1 153272 2016 744 180024 0 10 5393 60 903 642 78 22 0 0
3 2 153272 864 720 179536 0 32 5665 3179 945 660 75 25 0 0
2 1 153408 1988 728 180356 16 92 6579 117 916 673 80 20 0 0
1 1 155856 1940 764 179576 0 838 5821 912 942 645 73 27 0 0
3 3 156976 4212 844 178420 68 536 5671 3205 942 925 67 32 0 1
2 2 156976 2296 872 181492 0 12 6575 37 931 677 72 28 0 0
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
3 1 157148 1784 864 183012 34 702 5419 3421 924 656 80 20 0 0
2 0 158512 2144 860 184748 0 1078 5923 1085 912 639 78 22 0 0
2 1 158764 2008 856 185976 0 510 6161 536 892 629 79 21 0 0
3 2 159124 1044 864 187372 0 500 5411 4141 915 637 78 22 0 0
1 0 159436 2080 836 186876 0 102 6417 109 901 621 79 21 0 0
2 0 159468 2216 848 186720 0 0 6417 2602 907 642 80 20 0 0
1 1 159564 1184 848 187644 0 0 6179 41 905 639 78 22 0 0
2 0 159668 2176 820 186624 0 0 6161 7 905 620 81 19 0 0
2 1 160032 1248 820 187212 0 18 6929 3134 901 627 78 22 0 0
2 2 160604 1440 832 186464 0 0 6207 147 915 631 74 25 0 1
2 0 161800 2112 820 184588 0 18 4883 25 905 630 80 20 0 0
2 1 162224 1824 820 184460 0 2 6435 3116 917 645 78 22 0 0
2 0 164560 2144 776 178828 0 0 4281 93 932 630 65 35 0 0
1 0 164556 4264 784 180880 0 0 6673 3117 923 605 78 19 0 3
2 1 164556 1816 788 183312 0 0 5667 28 909 627 77 23 0 0
1 0 164576 2072 796 183052 0 0 6161 43 913 625 81 19 0 0
1 0 164608 2080 800 183064 0 0 7205 3633 918 629 79 21 0 0
2 0 164716 2080 796 182972 0 0 5649 26 904 611 81 19 0 0
1 0 164736 2080 800 182880 0 0 7953 13 892 636 78 22 0 0
2 0 164864 2140 808 182788 0 12 7971 3125 917 633 77 23 0 0
2 0 165016 2080 808 182760 44 14 6205 46 917 641 77 21 0 1
3 1 165056 2848 828 183656 0 0 10339 3107 917 642 74 25 0 1
0 0 165020 2144 836 184204 46 0 655 925 916 688 6 16 66 12
0 2 165404 1888 892 183604 0 192 385 224 914 714 4 16 72 9
0 0 165676 2080 920 182104 2 132 355 173 920 729 3 15 73 9
0 1 165668 2016 932 182176 0 0 223 101 916 702 11 13 71 5
0 1 167488 1968 904 182200 0 744 5031 5713 1022 818 4 23 0 73
0 0 167520 2120 924 180340 458 0 916 828 978 739 17 20 46 17
0 0 167348 2752 996 178204 222 10 1550 754 1074 992 13 39 13 34
0 1 167336 2612 1024 178320 8 0 984 406 1018 813 7 23 62 9
0 0 167248 2228 1048 178488 80 0 5329 5057 1018 778 6 27 7 60
0 0 167232 2164 1048 178520 6 0 475 97 919 736 7 14 75 4

从两次备份中发现

1 、第二次备份中，由于要压缩备份集，RMAN进程占用cpu72%-80%的使用率，系统占用20%-30%的使用率，内存 cache占用少,在将压缩备份集写入磁盘时, io才会占用80%左右的Cpu,但持续时间短。

2、第一次备份中因为一边备份一边将备份集写入磁盘，所以cache利用率比第一次高,而80%的CPU被io占用,rman进程占用cpu20%左右

3、而且压缩备份集比不压缩备份集的备份时间要短,短的原因是压缩备份中只是在将备份集写入磁盘时,磁盘写入比较厉害。而不压缩备份集时磁盘读写频繁，不停的与内存交互。

4、压缩与不压缩的存储容量的比接近1:5 ,可能没有lob格式的数据,压缩比较大。

通过以上测试发现压缩备份集不仅可以节省存储容量,而且可以提高备份性能，虽然性能观测不是很明显，但还是一中提高。

看见压缩备份集不备份的原因很可能是CPU问题。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/129805/viewspace-926972/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/129805/viewspace-926972/

conghan9137

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
rman中压缩备份集

前两天在一个装有10G的PC SERVER上进行rman备份,进行了多次备份,都在备份脚本运行一段时间后就停止了,也不返回错误很是郁闷。但是发现CPU使用率很高。仔细看了看rman脚本,发现脚本中对备份集进行了压缩 as com...
复制链接

扫一扫