Starting backup at 12-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=138 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/oracle/product/11.2.0/db_1/dbs/user01.dbf
output file name=+DATA/asmdevdb/datafile/users.266.847407067 tag=TAG20140512T225103 RECID=1 STAMP=847407068
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:04
Finished backup at 12-MAY-14
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