迁移备库所有文件到新的路径 - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

alter database rename file '<旧路径>' to '<新路径>'；（包括所有的数据文件、临时文件、日志文件）

例如：
--数据文件
alter database rename file '/hisdg/oradata/orcl/indx.465.1116292851' to '/data/orcl/indx.465.1116292851';
alter database rename file '/hisdg/oradata/orcl/sysaux.383.1116279919' to '/data/orcl/sysaux.383.1116279919';
alter database rename file '/hisdg/oradata/orcl/sysaux.384.1116280243' to '/data/orcl/sysaux.384.1116280243';
alter database rename file '/hisdg/oradata/orcl/sysaux.408.1116287629' to '/data/orcl/sysaux.408.1116287629';
alter database rename file '/hisdg/oradata/orcl/system.415.1116289697' to '/data/orcl/system.415.1116289697';
alter database rename file '/hisdg/oradata/orcl/tools.466.1116292853' to '/data/orcl/tools.466.1116292853';
alter database rename file '/hisdg/oradata/orcl/tsp_acct.460.1116292845' to '/data/orcl/tsp_acct.460.1116292845';
alter database rename file '/hisdg/oradata/orcl/tsp_asset.440.1116292687' to '/data/orcl/tsp_asset.440.1116292687';
alter database rename file '/hisdg/oradata/orcl/tsp_aud.391.1116282441' to '/data/orcl/tsp_aud.391.1116282441';
.......

--临时文件
alter database rename file '/hisdg/oradata/orcl/temp.311.1151058347' to '/data/orcl/temp.311.1151058347';
alter database rename file '/hisdg/oradata/orcl/temp.491.1151058389' to '/data/orcl/temp.491.1151058389';
alter database rename file '/hisdg/oradata/orcl/temp.263.1151058379' to '/data/orcl/temp.263.1151058379';

--重做日志文件
alter database rename file '/hisdg/oradata/orcl/redo01.log' to '/data/orcl/redo01.log';
alter database rename file '/hisdg/oradata/orcl/redo02.log' to '/data/orcl/redo02.log';
alter database rename file '/hisdg/oradata/orcl/redo03.log' to '/data/orcl/redo03.log';
alter database rename file '/hisdg/oradata/orcl/redo04.log' to '/data/orcl/redo04.log';
alter database rename file '/hisdg/oradata/orcl/redo05.log' to '/data/orcl/redo05.log';
alter database rename file '/hisdg/oradata/orcl/redo06.log' to '/data/orcl/redo06.log';
alter database rename file '/hisdg/oradata/orcl/redo07.log' to '/data/orcl/redo07.log';
alter database rename file '/hisdg/oradata/orcl/redo08.log' to '/data/orcl/redo08.log';

--备用日志文件
alter database rename file '/hisdg/oradata/orcl/std11.log' to '/data/orcl/std11.log';
alter database rename file '/hisdg/oradata/orcl/std12.log' to '/data/orcl/std12.log';
alter database rename file '/hisdg/oradata/orcl/std13.log' to '/data/orcl/std13.log';
alter database rename file '/hisdg/oradata/orcl/std14.log' to '/data/orcl/std14.log';
alter database rename file '/hisdg/oradata/orcl/std15.log' to '/data/orcl/std15.log';
alter database rename file '/hisdg/oradata/orcl/std21.log' to '/data/orcl/std21.log';
alter database rename file '/hisdg/oradata/orcl/std22.log' to '/data/orcl/std22.log';
alter database rename file '/hisdg/oradata/orcl/std23.log' to '/data/orcl/std23.log';
alter database rename file '/hisdg/oradata/orcl/std24.log' to '/data/orcl/std24.log';
alter database rename file '/hisdg/oradata/orcl/std25.log' to '/data/orcl/std25.log';

rename某些备用日志会出现失败情况，这是因为在停止同步前，其处于active状态，后面再处理