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';
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对