1.故障现象：
告警环境：灾备环境
告警系统：整合库
告警主机：10.1.XX.XX
告警级别：严重
告警事件ID：69244623
告警时间：2023-09-08 10:15:55
告警信息：文件系统：/oradata 可用空间小于15天标准限额
登陆上数据库服务器查看，此时/oradata空间已满。
清理完归档后，登陆数据库，查看dataguard备库MRP进程状态，发现没有启动。
查看alert日志，发现报错如下：
Errors in file /u01/app/oracle/diag/rdbms/intgdbesty4/intgdbesty4/trace/intgdbesty4_dbw0_29034.trc:
ORA-01186: file 158 failed verification tests
ORA-01157: cannot identify/lock data file 158 - see DBWR trace file
ORA-01111: name for data file 158 is unknown - rename to correct file
ORA-01110: data file 158: '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/UNNAMED00158'
158号文件出现异常，没有创建到正确的数据目录路径下。
2.处理过程：
alter database recover managed standby database cancel;
alter system set standby_file_management=manual;
alter database create datafile '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/UNNAMED00158' as '/oradata/intgdbesty4/tbs_act_data.495.1146933537';
alter system set standby_file_management=auto;
alter database recover managed standby database using current logfile disconnect from session;
再查看alert日志，发现已恢复正常，可以正常应用日志。
2023-09-08T10:28:44.097946+08:00
alter database create datafile '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/UNNAMED00158' as '/oradata/intgdbesty4/tbs_act_data.495.1146933537'
2023-09-08T10:29:02.849023+08:00
RFS[8]: Opened log for T-2.S-10838 dbid 2833883573 branch 1120959234
2023-09-08T10:29:50.143423+08:00
Archived Log entry 886 added for T-2.S-10836 ID 0xa8e9fbb5 LAD:1
2023-09-08T10:30:01.379427+08:00
Completed: alter database create datafile '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/UNNAMED00158' as '/oradata/intgdbesty4/tbs_act_data.495.1146933537'
2023-09-08T10:30:01.427157+08:00
RFS[6]: Selected log 6 for T-1.S-6412 dbid 2833883573 branch 1120959234
2023-09-08T10:30:02.504080+08:00
Archived Log entry 887 added for T-1.S-6411 ID 0xa8e9fbb5 LAD:1
2023-09-08T10:30:46.665912+08:00
ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;
2023-09-08T10:30:58.113844+08:00
Warning: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE has been deprecated.
alter database recover managed standby database using current logfile disconnect from session
2023-09-08T10:30:58.116014+08:00
Attempt to start background Managed Standby Recovery process (intgdbesty4)
Starting background process MRP0
2023-09-08T10:30:58.135738+08:00
MRP0 started with pid=127, OS id=18710
2023-09-08T10:30:58.137328+08:00
MRP0: Background Managed Standby Recovery process started (intgdbesty4)
2023-09-08T10:31:03.166907+08:00
Started logmerger process
2023-09-08T10:31:03.199402+08:00
Managed Standby Recovery starting Real Time Apply
2023-09-08T10:31:03.737459+08:00
Parallel Media Recovery started with 16 slaves
2023-09-08T10:31:03.860698+08:00
Media Recovery Log /oradata/arch/2_10823_1120959234.arc
2023-09-08T10:31:03.911750+08:00
Media Recovery Log /oradata/arch/1_6398_1120959234.arc
2023-09-08T10:31:04.141609+08:00
Completed: alter database recover managed standby database using current logfile disconnect from session
