某客户人管dg库ORA-01111、ORA-01110、ORA-01157报错处理

某日，监控发现人管系统dg库出现报错，如下：

Mon Apr 12 16:36:47 2021
Managed Standby Recovery starting Real Time Apply
Mon Apr 12 16:36:47 2021
Errors in file /u01/app/oracle/diag/rdbms/rgdga/rgdga1/trace/rgdga1_dbw0_16272.trc:
ORA-01186: file 296 failed verification tests
ORA-01157: cannot identify/lock data file 296 - see DBWR trace file
ORA-01111: name for data file 296 is unknown - rename to correct file
ORA-01110: data file 296: '/u01/app/oracle/product/11.2/db_1/dbs/UNNAMED00296'
File 296 not verified due to error ORA-01157
Mon Apr 12 16:36:47 2021
MRP0: Background Media Recovery terminated with error 1111
Errors in file /u01/app/oracle/diag/rdbms/rgdga/rgdga1/trace/rgdga1_pr00_110631.trc:
ORA-01111: name for data file 296 is unknown - rename to correct file
ORA-01110: data file 296: '/u01/app/oracle/product/11.2/db_1/dbs/UNNAMED00296'
ORA-01157: cannot identify/lock data file 296 - see DBWR trace file
ORA-01111: name for data file 296 is unknown - rename to correct file
ORA-01110: data file 296: '/u01/app/oracle/product/11.2/db_1/dbs/UNNAMED00296'
Managed Standby Recovery not using Real Time Apply

经过排查发现由于备库空间耗尽导致数据文件创建失败，处理如下：

在对备库紧急存储扩容之后，再开启 mrp 进程还是报错，分析发现备库新创建的数据文件未放在正确的位置，需要恢复

##主库查询
select file_id,file_name from dba_data_files where file_id in (294,295,296);

   FILE_ID FILE_NAME
---------- --------------------------------------------------
       294 +DATA/rgdb/datafile/piccsmis_tbs.19790.1069627257
       295 +DATA/rgdb/datafile/piccsmis_tbs.19468.1069627271
       296 +DATA/rgdb/datafile/piccsmis_tbs.6150.1069627629

#备库查询
select file_id,file_name from dba_data_files where file_id in (294,295,296);

   FILE_ID FILE_NAME
---------- --------------------------------------------------
       294 +DATA/rgdga/datafile/piccsmis_tbs.7533.1069681393
       295 +DATA/rgdga/datafile/piccsmis_tbs.7535.1069681477

alter system set standby_file_management=manual sid='*';

alter database create datafile  '/u01/app/oracle/product/11.2/db_1/dbs/UNNAMED00296'  as  '+DATA/rgdga/datafile/piccsmis_tbs.6150.1069627629';

ORA-01276: Cannot add file  File has an Oracle Managed             

这里出现报错是因为数据库开启了OMF

alter database create datafile  '/u01/app/oracle/product/11.2/db_1/dbs/UNNAMED00296'  as  '+DATA/rgdga/datafile/piccsmis_tbs.296.dbf';

alter system set standby_file_management=AUTO sid='*';

alter database recover managed standby database using current logfile disconnect from session; 

至此，该报错解决处理完成。