首页 > 应用开发 > IT综合 > 转移部分datafile到其它目录
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/ ,如需转载,请注明出处,否则将追究法律责任。