22:11:24 sys@stldb>select name,status from v$datafile where con_id=1;
NAME STATUS
-------------------------------------------------- -------
+DATA/STLDB/DATAFILE/system.259.874612989 SYSTEM
+DATA/STLDB/DATAFILE/sysaux.258.874612893 ONLINE
+DATA/STLDB/DATAFILE/undotbs1.261.874613095 ONLINE
+DATA/STLDB/DATAFILE/users.260.874613093 ONLINE
+DATA/STLDB/DATAFILE/undotbs2.269.874613949 ONLINE
/u02/oradata/stldb/kiwi01.dbf ONLINE
22:14:35 sys@stldb> alter database move datafile '/u02/oradata/stldb/kiwi01.dbf' to '+DATA';
Database altered.
Elapsed: 00:00:09.32
22:16:41 sys@stldb> select name,status from v$datafile where con_id=1;
NAME STATUS
-------------------------------------------------- -------
+DATA/STLDB/DATAFILE/system.259.874612989 SYSTEM
+DATA/STLDB/DATAFILE/sysaux.258.874612893 ONLINE
+DATA/STLDB/DATAFILE/undotbs1.261.874613095 ONLINE
+DATA/STLDB/DATAFILE/users.260.874613093 ONLINE
+DATA/STLDB/DATAFILE/undotbs2.269.874613949 ONLINE
+DATA/STLDB/DATAFILE/kiwi.291.874620993 ONLINE
6 rows selected.
12c 的新特性 数据文件的在线移动
最新推荐文章于 2019-06-05 17:11:37 发布