报错信息:
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)




