实验目的:在ASM存储环境下,要删除一个磁盘组,从而将磁盘组中的数据文件移动到另外一个磁盘组中。
查看数据文件存放的位置:
SQL> select file#,name from v$datafile;
FILE# NAME
----- ----------------------------------------
1 +ASM/orcl/datafile/system.271.847398023
2 +ASM/orcl/datafile/undotbs1.273.84739817
1
3 +ASM/orcl/datafile/sysaux.272.847398127
4 +ASM/orcl/datafile/users.276.847398185
5 +KEL/orcl/datafile/kel.259.850521765
6 +ASM/orcl/datafile/kelly.275.847398181
6 rows selected.
在rman中将数据文件offline:
RMAN> sql "alter database datafile 5 offline";
using target database control file instead of recovery catalog
sql statement: alter database datafile 5 offline