RMAN备份失败ORA-15041

于 2012-06-12 01:05:44 发布
阅读量309 收藏
点赞数
文章标签： 数据库

今天发现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/

congjiaqing0635
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值