磁盘问题迁移数据文件测试

1.

run
{
SQL "alter database datafile 6 offline";
SET NEWNAME FOR DATAFILE '/u01/app/oracle/product/10.2.0/oradata/orcl/tb/test01.dbf' to '/u01/app/oracle/product/10.2.0/oradata/orcl/tb/test02.dbf';
restore tablespace test;
switch datafile all;
recover teblespace test;
SQL "alter database datafile 6 online";
}

2.

run
{
SQL "ALTER TABLESPACE test OFFLINE IMMEDIATE";
SET NEWNAME FOR DATAFILE '/u01/app/oracle/product/10.2.0/oradata/orcl/tb/test01.dbf' to '/u01/app/oracle/product/10.2.0/oradata/orcl/tb/test02.dbf';
restore tablespace test;
switch datafile all;
recover teblespace test;
SQL "ALTER TABLESPACE test ONLINE";
}

3.

run
{
SQL "ALTER TABLESPACE test OFFLINE IMMEDIATE";
SET NEWNAME FOR DATAFILE '/u01/app/oracle/product/10.2.0/oradata/orcl/test1.dbf' to '/u01/app/oracle/product/10.2.0/oradata/orcl/tb/test01.dbf';
restore datafile 6;
switch datafile 6;
recover datafile 6;
SQL "ALTER TABLESPACE test ONLINE";
}

之前有看过资料，但是测试的时候出了一身汗，前2个都不成功，只有第3个成功！
offline tablespace,restore/switch/recover datafile,online tablespace。
mark!