ITPub博客

首页 > 应用开发 > IT综合 > 转移部分datafile到其它目录

转移部分datafile到其它目录

原创 IT综合 作者:ningzi82 时间:2010-12-09 08:12:13 0 删除 编辑

1.shutdown immediate

2.startup mount

3.rename file:

alter database rename file '/ora104/oradata/APPSTB/users01.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users01.dbf';
alter database rename file '/ora104/oradata/APPSTB/users02.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users02.dbf';
alter database rename file '/ora104/oradata/APPSTB/users03.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users03.dbf';
alter database rename file '/ora104/oradata/APPSTB/users04.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users04.dbf';
alter database rename file '/ora104/oradata/APPSTB/users05.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users05.dbf';
alter database rename file '/ora104/oradata/APPSTB/users06.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users06.dbf';
alter database rename file '/ora104/oradata/APPSTB/users07.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users07.dbf';
alter database rename file '/ora104/oradata/APPSTB/users08.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users08.dbf';
alter database rename file '/ora104/oradata/APPSTB/users09.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users09.dbf';
alter database rename file '/ora104/oradata/APPSTB/users10.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users10.dbf';
alter database rename file '/ora104/oradata/APPSTB/users11.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users11.dbf';
alter database rename file '/ora104/oradata/APPSTB/users12.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users12.dbf';
alter database rename file '/ora104/oradata/APPSTB/users13.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users13.dbf';
alter database rename file '/ora104/oradata/APPSTB/users14.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users14.dbf';
alter database rename file '/ora104/oradata/APPSTB/users15.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users15.dbf';
alter database rename file '/ora104/oradata/APPSTB/users16.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users16.dbf';
alter database rename file '/ora104/oradata/APPSTB/users17.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users17.dbf';
alter database rename file '/ora104/oradata/APPSTB/users18.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users18.dbf';
alter database rename file '/ora104/oradata/APPSTB/users19.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users19.dbf';
alter database rename file '/ora104/oradata/APPSTB/users20.dbf' to '/ora104/oradata/FAB1STB/APPSTB/users20.dbf';

4.alter database open;

[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/789833/viewspace-1042834/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-16

  • 博文量
    130
  • 访问量
    358880