oracle移到桌面,给ORACLE数据库移个地方

最新推荐文章于 2023-04-04 11:46:00 发布

Patchouli Exarch

最新推荐文章于 2023-04-04 11:46:00 发布

阅读量151

点赞数

文章标签： oracle移到桌面

由于数据库所在的磁盘已经满了现在需要把数据库移动到另一个容量比较大的磁盘上去，都是在一个机器上操作而已。

1 shutdown immediate

2 mv /opt/oracle/oradata/zhaobiao/ /ora9idata/zhaobiao/

3 startup mount

4 alter database rename file '/opt/oracle/oradata/zhaobiao/system01.dbf' to '/ora9idata/zhaobiao/system01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/undotbs01.dbf' to '/ora9idata/zhaobiao/undotbs01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/cwmlite01.dbf' to '/ora9idata/zhaobiao/cwmlite01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/drsys01.dbf' to '/ora9idata/zhaobiao/drsys01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/example01.dbf' to '/ora9idata/zhaobiao/example01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/indx01.dbf' to '/ora9idata/zhaobiao/indx01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/odm01.dbf' to '/ora9idata/zhaobiao/odm01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/tools01.dbf' to '/ora9idata/zhaobiao/tools01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/users01.dbf' to '/ora9idata/zhaobiao/users01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/xdb01.dbf' to '/ora9idata/zhaobiao/xdb01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/ZHUDB01.dbf' to '/ora9idata/zhaobiao/ZHUDB01.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/ZHUDB02.dbf' to '/ora9idata/zhaobiao/ZHUDB02.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/ZHUDB0.ORA3.dbf' to '/ora9idata/zhaobiao/ZHUDB0.ORA3.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/ZHUDB04.dbf' to '/ora9idata/zhaobiao/ZHUDB04.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/ZHUDB05.dbf' to '/ora9idata/zhaobiao/ZHUDB05.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/DOCMAN.dbf' to '/ora9idata/zhaobiao/DOCMAN.dbf';

alter database rename file '/opt/oracle/oradata/zhaobiao/BJPIMS.dbf' to '/ora9idata/zhaobiao/BJPIMS.dbf';

5 alter database open

上面就是把数据文件给移动到另外一个地方，如果控制文件要是也移动的话就得编辑一下PFILE修改控制文件的路径。如果redo log也好改地方的话，那么就可以新建3组 redo log 把原来的删除即可，但是正在使用的 redo log 需要alter database switch logfile

关注