暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

DG 备库空间满后报ORA-01274 ORA-19502 ORA-27072

原创 xusmallhorse 2023-11-01
232

报错信息:

Tue Oct 31 20:02:23 2023
Errors in file /u01/app/oracle/diag/rdbms/intgdbd_std/intgdbd_std/trace/intgdbd_std_pr00_27508.trc:
ORA-19502: write error on file "/oradata/intgdbd_std/INTGDBD_STD/datafile/o1_mf_tbs_newc_ln1txm51_.dbf", block number 1969536 (block size=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 1969536
Additional information: -1
File #127 added to control file as 'UNNAMED00127'.
Originally created as:
'+DATA/intgdbd/datafile/tbs_newcarrule_data.414.1151686305'
Recovery was unable to create the file as a new OMF file.
Errors with log /oradata/arch/2_8962_1132423422.dbf
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/intgdbd_std/intgdbd_std/trace/intgdbd_std_pr00_27508.trc:
ORA-01274: cannot add datafile '+DATA/intgdbd/datafile/tbs_newcarrule_data.414.1151686305' - file could not be created
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!



解决方法:

alter database recover managed standby database cancel;
alter system set standby_file_management=manual scope=both;
alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00125' as '/oradata/intgdbd_pri/INTGDBD_PRI/datafile/tbs_newcarrule_data.412.1151681379';
alter system set standby_file_management=auto scope=both;
alter database recover managed standby database using current logfile disconnect from session;


参考文档:

Upon Primary Creation Of Tablespace/Add datafile, Standby MRP(Media Recovery) failing with ORA-01110,ORA-01565 and ORA-27037 (Doc ID 2811172.1)



「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论