ORA-01119、ORA-01274、ORA-01110 adg创建数据文件失败

转载：文章转载自墨天轮平台 。用户：对方带有病毒。https://www.modb.pro/db/210272

一、问题描述

dg备库报错

ORA-01119: 创建数据库文件 ‘+DATA’ 时出错
ORA-17502: ksfdcre: 4 未能创建文件 +DATA
ORA-15041: diskgroup “DATA” space exhausted
File #469 added to control file as ‘UNNAMED00469’.
Originally created as:
‘+DATA/pmshisdb/datafile/part_data.778.1062785343’
Recovery was unable to create the file as a new OMF file.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/app/oracle/diag/rdbms/pmshisdb/pmshisdb1/trace/hisdb1_pr00_9147.trc:
ORA-01274: 无法添加数据文件 ‘+DATA/pmshisdb/datafile/part_data.778.10627’ - 无法创建文件
Mon Jan 25 18:09:54 2021
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 17331131078750
Mon Jan 25 18:10:00 2021
Reconfiguration started (old inc 18, new inc 20)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps

---

Thu Jan 28 15:16:43 2021
Errors in file /u01/app/oracle/diag/rdbms/pmshisdb/pmshisdb1/trace/hisdb1_dbw0_24065.trc:
ORA-01186: 文件 469 验证测试失败
ORA-01157: 无法标识/锁定数据文件 469 - 请参阅 DBWR 跟踪文件
ORA-01111: 数据文件 469 名称未知 - 请重命名以更正文件
ORA-01110: 数据文件 469: ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00469’
File 469 not verified due to error ORA-01157
Thu Jan 28 15:16:43 2021
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/pmshisdb/pmshisdb1/trace/hisdb1_pr00_53233.trc:
ORA-01111: 数据文件 469 名称未知 - 请重命名以更正文件
ORA-01110: 数据文件 469: ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00469’
ORA-01157: 无法标识/锁定数据文件 469 - 请参阅 DBWR 跟踪文件
ORA-01111: 数据文件 469 名称未知 - 请重命名以更正文件
ORA-01110: 数据文件 469: ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00469’
Thu Jan 28 15:16:43 2021
Reconfiguration started (old inc 24, new inc 26)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps

经核实有一数据文件未建上：/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00469
重建执行报错：alter database create datafile ‘/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00469’ as ‘+DATA’ size 30g;
ERROR at line 1:
ORA-01275: Operation CREATE DATAFILE is not allowed if standby file management is automatic.

二、解决办法

处理办法：

SQL> show parameter standby

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string AUTO

SQL> alter system set standby_file_management=manual ;

System altered.

SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00469' as '+DATA/hisdb/datafile/part_data.778.1062785343' size 30G;


Database altered.

SQL> alter system set standby_file_management=auto;

System altered.

#SQL> recover managed standby database disconnect from session;
Media recovery complete.

如需要开启实时应用日志，停止日志应用
SQL> alter database recover managed standby database cancel;

再启动日志应用就好
SQL> alter database recover managed standby database using current logfile disconnect;