SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/home/oracle/app/oradata/orcl\SYSTEM01.DBF
/home/oracle/app/oradata/orcl/SYSAUX01.DBF
/home/oracle/app/oradata/orcl\UNDOTBS01.DBF
/home/oracle/app/oradata/orcl\USERS01.DBF
/home/oracle/app/oradata/orcl\TNS_LUNA.DBF
/home/oracle/app/oradata/orcl\TNS_LUNA01.DBF

很多“orcl\”由于斜杠写反了，导致文件名是“orcl”的文件，而不是orcl目录下生成的文件

[oracle@ewell-nursing-db oradata]$ ls /home/oracle/app/oradata/
orcl  orclSYSAUX01.DBF

RMAN> copy datafile 2 to '/home/oracle/app/oradata/orcl/SYSAUX01.DBF';
RMAN> run{
set newname for datafile 2 to '/home/oracle/app/oradata/orcl/SYSAUX01.DBF';
switch datafile 2;
}2> 3> 4>

executing command: SET NEWNAME

datafile 2 switched to datafile copy
input datafile copy RECID=19 STAMP=1173460799 file name=/home/oracle/app/oradata/orcl/SYSAUX01.DBF