冷备份--模拟磁盘损坏恢复

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;