adg备库报错
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;
