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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22967847/viewspace-3071204/ ，如需转载，请注明出处，否则将追究法律责任。
