把文件系统的数据文件迁移到ASM存储(二)

RMAN> switch datafile '/u01/oracle/product/11.2.0/db_1/dbs/user01.dbf' to copy;

datafile 5 switched to datafile copy "+DATA/asmdevdb/datafile/users.266.847407067"

RMAN> alter database open;

database opened

RMAN> report schema;

Report of database schema for database with db_unique_name ASMDEVDB

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 700 SYSTEM *** +DATA/asmdevdb/datafile/system.273.845258673
2 600 SYSAUX *** +DATA/asmdevdb/datafile/sysaux.274.845258703
3 200 UNDOTBS1 *** +DATA/asmdevdb/datafile/undotbs1.264.845258723
4 5 USERS *** +DATA/asmdevdb/datafile/users.271.845258761
5 10 USERS *** +DATA/asmdevdb/datafile/users.266.847407067

List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 +DATA/asmdevdb/tempfile/temp.275.845258729

注意：
以后在添加数据文件时，使用如下命令
alter tablespace users add datafile '+DATA' size 10m;
文件的路径要写存储路径，不用写文件名，ASM文件的命名不同于普通文件的命名，它的文件名一般不直接指定，由ASM系统自己生成，并且其管理方式是OMF。

SQL> conn / as sysdba
Connected.
SQL> alter tablespace users add datafile '+DATA' size 10m;

Tablespace altered.

SQL> select file_name from dba_data_files;

FILE_NAME
------------------------------------------------------------
+DATA/asmdevdb/datafile/system.273.845258673
+DATA/asmdevdb/datafile/sysaux.274.845258703
+DATA/asmdevdb/datafile/undotbs1.264.845258723
+DATA/asmdevdb/datafile/users.271.845258761
+DATA/asmdevdb/datafile/users.266.847407067
+DATA/asmdevdb/datafile/users.270.847408759

6 rows selected.