Oracle RECOVER DATABASE报错：RMAN-03002、RMAN-06094

RECOVER DATABASE报错，报错如下：

RMAN> switch datafile all;
RMAN> RECOVER DATABASE;

Starting recover at 2021/07/26 23:48:13
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/26/2021 23:48:13
RMAN-06094: datafile 1 must be restored

原因：v$datafile和RMAN的REPORT SCHEMA中显示的数据文件名称目录不一致

报告数据库的物理结构。模式包括数据文件名、数据文件号、为这些数据文件指派的表空间、数据文件大小、以及数据文件是否含有回滚段

RMAN> report schema;    
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name UQREPORT

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    0        SYSTEM               ***     /data/oracle/oradata/reporting/system01.dbf
2    0        SYSAUX               ***     /data/oracle/oradata/reporting/sysaux01.dbf
3    0        UNDOTBS1             ***     /data/oracle/oradata/reporting/undotbs01.dbf
4    0        USERS                ***     /data/oracle/oradata/reporting/users01.dbf
5    0        DLEX_DATA            ***     /data/oracle/oradata/reporting/dlex_data.dbf
6    0        DLEX_INDEX           ***     /data/oracle/oradata/reporting/dlex_index.dbf
7    0        DMIN_REPORTAQ_SMALL  ***     /data/oracle/oradata/reporting/dmin_reportaqdata.dbf
8    0        ADMIN_REPORTAQ_INDEX ***     /data/oracle/oradata/reporting/admin_reportaqindex.dbf
9    0        PURGE_DATA           ***     /data/oracle/oradata/reporting/purge_data.dbf
10   0        INDEX                ***     /data/oracle/oradata/reporting/index.dbf
11   0        LOB                  ***     /data/oracle/oradata/reporting/lob.dbf
12   0        DATA                 ***     /data/oracle/oradata/reporting/data.dbf
13   0        MONITORING_INDEX     ***     /data/oracle/oradata/reporting/monitoring_index.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /data/oracle/oradata/reporting/temp01.dbf

看SIZE和NAME列，SIZE为0 说明该文件在物理上不存在于磁盘上，可能上一步执行的switch datafile all不生效

将数据文件重命名为磁盘上的正确副本，再执行恢复就OK了，操作如下：

RMAN>  switch database to copy;

datafile 1 switched to datafile copy "/oracledata/oradata/report/system01.dbf"
.........
.........
.........
datafile 12 switched to datafile copy "/oracledata/oradata/report/data.dbf"
datafile 13 switched to datafile copy "/oracledata/oradata/report/monitoring_index.dbf"

RMAN> recover database;