oracle特殊数据文件名修改

来源:这里教程网 时间:2026-03-03 21:26:49 作者:

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.DBFRMAN> 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 NEWNAMEdatafile 2 switched to datafile copy input datafile copy RECID=19 STAMP=1173460799 file name=/home/oracle/app/oradata/orcl/SYSAUX01.DBF

相关推荐