1.增加新磁盘,并分区,确定文件格式
mkfs.ext3 sdh1
mount
2.把备份拷贝到新的磁盘上
cp * /u01/app/oracle/oradata/demo2/
3.创建pfile,并修改
SQL> create pfile from spfile
修改其中的控制文件路径
4.通过pfile创建spfile
SQL> create spfile from pfile;
5.启动数据库到mount状态
SQL> startup mount
6.备份控制文件,并修改控制文件
SQL> select file#,name from v$datafile;
SQL> alter database rename file '/u01/app/oracle/oradata/demo1/system01.dbf' to '/u01/app/oracle/oradata/demo2/system01.dbf';
SQL> select file#,name from v$tempfile;
SQL> alter database rename file '/u01/app/oracle/oradata/demo1/temp02.dbf' to '/u01/app/oracle/oradata/demo2/temp2.dbf';
SQL> alter database rename file '/u01/app/oracle/oradata/demo1/redo01.log' to '/u01/app/oracle/oradata/demo2/redo01.log';
SQL> alter database rename file '/u01/app/oracle/oradata/demo1/redo02.log' to '/u01/app/oracle/oradata/demo2/redo02.log';
SQL> alter database rename file '/u01/app/oracle/oradata/demo1/redo03.log' to '/u01/app/oracle/oradata/demo2/redo03.log';
7.打开数据库
SQL> alter database open;