今天发现Oracle备份空间使用比例比平时高得多,查看备份日志发现如下:
piece handle=+FRADG/test/backupset/data_test_20120609_1303_5 tag=TAG20120609T050443 comment=NONE
channel d2: starting piece 6 at 09-JUN-12
RMAN-03009: failure of backup command on d2 channel at 06/09/2012 05:50:22
ORA-19510: failed to set size of 2361610 blocks for file "+FRADG/test/backupset/data_test_20120609_1303_6" (blocksize=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 2361610 blocks
ORA-15041: diskgroup space exhausted
channel d2 disabled, job failed on it will be run on another channel
channel d1: finished piece 6 at 09-JUN-12
piece handle=+FRADG/test/backupset/data_test_20120609_1302_6 tag=TAG20120609T050443 comment=NONE
channel d1: backup set complete, elapsed time: 00:45:52
channel d1: starting full datafile backupset
[@more@]
piece handle=+FRADG/test/backupset/data_test_20120609_1304_5 tag=TAG20120609T050443 comment=NONE
channel d1: starting piece 6 at 09-JUN-12
released channel: d1
released channel: d2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 06/09/2012 06:15:36
ORA-19510: failed to set size of 1657610 blocks for file "+FRADG/test/backupset/data_test_20120609_1304_6" (blocksize=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 1657610 blocks
ORA-15041: diskgroup space exhausted
是因为备份空间不足导致,Rman 备份失败。处理过程如下:
RMAN> list backup summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1276 B F A DISK 02-JUN-12 1 1 NO TAG20120602T050407
1277 B F A DISK 02-JUN-12 6 1 NO TAG20120602T050407
1278 B F A DISK 02-JUN-12 1 1 NO TAG20120602T050407
1279 B A A DISK 02-JUN-12 1 1 NO TAG20120602T055006
1280 B A A DISK 02-JUN-12 1 1 NO TAG20120602T055006
1281 B A A DISK 03-JUN-12 1 1 NO TAG20120603T050023
1282 B A A DISK 03-JUN-12 1 1 NO TAG20120603T050023
1283 B A A DISK 04-JUN-12 1 1 NO TAG20120604T050025
1284 B A A DISK 04-JUN-12 1 1 NO TAG20120604T050025
1285 B A A DISK 05-JUN-12 1 1 NO TAG20120605T050024
1286 B A A DISK 05-JUN-12 1 1 NO TAG20120605T050024
1287 B A A DISK 06-JUN-12 1 1 NO TAG20120606T050102
1288 B A A DISK 06-JUN-12 1 1 NO TAG20120606T050102
1289 B A A DISK 06-JUN-12 1 1 NO TAG20120606T050102
1290 B A A DISK 07-JUN-12 1 1 NO TAG20120607T050023
1291 B A A DISK 07-JUN-12 1 1 NO TAG20120607T050023
1292 B A A DISK 08-JUN-12 1 1 NO TAG20120608T050022
1293 B A A DISK 08-JUN-12 1 1 NO TAG20120608T050022
1294 B A A DISK 09-JUN-12 1 1 NO TAG20120609T050022
1295 B A A DISK 09-JUN-12 1 1 NO TAG20120609T050022
1296 B A A DISK 09-JUN-12 1 1 NO TAG20120609T050022
1297 B F A DISK 09-JUN-12 6 1 NO TAG20120609T050443
1298 B A A DISK 10-JUN-12 1 1 NO TAG20120610T050025
1299 B A A DISK 10-JUN-12 1 1 NO TAG20120610T050025
1300 B A A DISK 10-JUN-12 1 1 NO TAG20120610T050025
1301 B A A DISK 11-JUN-12 1 1 NO TAG20120611T050023
1302 B A A DISK 11-JUN-12 1 1 NO TAG20120611T050023
以为归档日志空间紧张,决定临时删除冗余备份来临时解决空间不足问题。执行如下语句:
RMAN> DELETE NOPROMPT backupset COMPLETED BEFORE 'SYSDATE-4';
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1786 1276 1 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1282_1
1787 1277 1 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1281_1
1788 1277 2 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1281_2
1789 1277 3 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1281_3
1790 1277 4 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1281_4
1791 1277 5 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1281_5
1792 1277 6 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1281_6
1793 1278 1 1 AVAILABLE DISK +FRADG/test/backupset/data_test_20120602_1283_1
1794 1279 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120602_1285
1795 1280 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120602_1284
1796 1281 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120603_1286
1797 1282 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120603_1287
1798 1283 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120604_1288
1799 1284 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120604_1289
1800 1285 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120605_1290
1801 1286 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120605_1291
1802 1287 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120606_1292
1803 1288 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120606_1293
1804 1289 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120606_1294
1805 1290 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120607_1295
1806 1291 1 1 AVAILABLE DISK +FRADG/test/backupset/arch_test_20120607_1296
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1282_1 recid=1786 stamp=784878597
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1281_1 recid=1787 stamp=784875852
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1281_2 recid=1788 stamp=784876339
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1281_3 recid=1789 stamp=784876809
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1281_4 recid=1790 stamp=784877290
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1281_5 recid=1791 stamp=784877759
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1281_6 recid=1792 stamp=784878230
deleted backup piece
backup piece handle=+FRADG/test/backupset/data_test_20120602_1283_1 recid=1793 stamp=784878601
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120602_1285 recid=1794 stamp=784878608
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120602_1284 recid=1795 stamp=784878608
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120603_1286 recid=1796 stamp=784962025
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120603_1287 recid=1797 stamp=784962162
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120604_1288 recid=1798 stamp=785048426
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120604_1289 recid=1799 stamp=785048533
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120605_1290 recid=1800 stamp=785134826
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120605_1291 recid=1801 stamp=785135013
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120606_1292 recid=1802 stamp=785221264
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120606_1293 recid=1803 stamp=785221461
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120606_1294 recid=1804 stamp=785221677
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120607_1295 recid=1805 stamp=785307624
deleted backup piece
backup piece handle=+FRADG/test/backupset/arch_test_20120607_1296 recid=1806 stamp=785307771
Deleted 21 objects
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1292 B A A DISK 08-JUN-12 1 1 NO TAG20120608T050022
1293 B A A DISK 08-JUN-12 1 1 NO TAG20120608T050022
1294 B A A DISK 09-JUN-12 1 1 NO TAG20120609T050022
1295 B A A DISK 09-JUN-12 1 1 NO TAG20120609T050022
1296 B A A DISK 09-JUN-12 1 1 NO TAG20120609T050022
1297 B F A DISK 09-JUN-12 6 1 NO TAG20120609T050443
1298 B A A DISK 10-JUN-12 1 1 NO TAG20120610T050025
1299 B A A DISK 10-JUN-12 1 1 NO TAG20120610T050025
1300 B A A DISK 10-JUN-12 1 1 NO TAG20120610T050025
1301 B A A DISK 11-JUN-12 1 1 NO TAG20120611T050023
1302 B A A DISK 11-JUN-12 1 1 NO TAG20120611T050023
RMAN>
如下为删除前后的ASM空间利用率对比:
删除前:
ASMCMD> lsdg
State Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED 999760 460234 0 460234 0 DATADG/
MOUNTED 980256 289016 0 289016 0 FRADG/
删除后:
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATADG 999760 460234
FRADG 980256 685120
以上只是应急处理步骤,只能腾出足够备份空间,有必要采取如下两个步骤来保证今后的备份空间和备份完整性:
1、为了保证备份的完整性,有必要进行重新全备份。虽然list backup方式现显示备份为AVAILABLE,但是空间不足导致的备份日志总是让人放不下心;
2、如果备份存放空间确实紧张,则可以采用Rman的压缩备份参数 AS COMPRESSED BACKUPSET:
backup AS COMPRESSED BACKUPSET database plus archivelog delete all input;
另外,如下删除归档日志的参数也值得记录一下了:
RMAN>delete archivelog until time 'sysdate-7';--删除7天前的无用的归档日志
RMAN> crosscheck archivelog all;
RMAN> delete noprompt expired archivelog all;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/18841027/viewspace-1058482/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/18841027/viewspace-1058482/