移动jfzl02.dbf和system01.dbf到/oracle/backup路径下
sql>shutdown immediate; --->关闭数据库
$cp /data/test/jfzl02.dbf /oracle/backup/ --->拷贝数据文件
$cp /oracle/oradata/OCM/system01.dbf /oracle/backup/
sql>startup mount; ->数据库启动到mount 状态
sql>alter database rename file '/data/test/jfzl02.dbf' to '/oracle/backup/jfzl02.dbf'; ->修改参数文件中数据文件
sql>alter database rename file '/oracle/oradata/OCM/system01.dbf' to '/oracle/backup/system01.dbf';
sql>alter database open;
oracle -移动数据文件
最新推荐文章于 2024-07-15 19:23:25 发布