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

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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/e34838d4abe3f671c5a9c761610886ed.html