run{
2> backup incremental level 0 database
3> format '+FRA/db_%d_%U'
4> tag=db_full_inc_0;
5> }
Starting backup at 30-SEP-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=982 instance=mpac1 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
channel ORA_DISK_1: finished piece 1 at 01-OCT-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/01/2014 07:11:43
ORA-19510: failed to set size of 34982410 blocks for file "+FRA/db_mpac_0kpju2r6_1_1" (blocksize=8192)
ORA-17505: ksfdrsz:1 Failed to resize file to size 34982410 blocks
ORA-15041: diskgroup space exhausted
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 3583440 568885 0 568885 0 DATA/
MOUNTED EXTERN N N 512 4096 1048576 921456 273296 0 273296 0 FRA/
从报错提示上看是因为空间不够,但是查看空间还剩270多G呀,查阅了很多资料也没中找到具体解决办法,请各位帮忙看看,谢谢谢谢!!
rman备份报错 ORA-19510 ORA-17505 ORA-15041
答案:2 悬赏:40 手机版
解决时间 2021-02-07 07:11
- 提问者网友:练爱
- 2021-02-06 17:08
最佳答案
- 五星知识达人网友:像个废品
- 2021-02-06 18:01
必要采取如下两个步骤来保证今后的备份空间和备份完整性:
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;
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;
全部回答
- 1楼网友:你哪知我潦倒为你
- 2021-02-06 19:22
ORA-15041: diskgroup space exhausted
EXTERN redundancy 的diskgroup ,你没告诉我们oracle是说什么版本。
askmaclean oracle
再看看别人怎么说的。
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯