SQL> create tablespace TEST datafile '+DG/asmdb/datafile/TEST.DBF' SIZE 3M;

表空间已创建。

SQL> SELECT FILE_NAME FROM DBA_DATA_FILES;

FILE_NAME
--------------------------------------------------------------------------------

+DG/asmdb/datafile/users.266.688401581
+DG/asmdb/datafile/sysaux.264.688401529
+DG/asmdb/datafile/undotbs1.263.688401515
+DG/asmdb/datafile/system01.dbf
+DG/asmdb/datafile/test.dbf

--=====================================
ASMCMD> pwd
+dg/asmdb/datafile
ASMCMD> ls
SYSAUX.264.688401529
SYSTEM.262.688401443
SYSTEM01.DBF
TEST.268.689004557
TEST.DBF
UNDOTBS1.263.688401515
USERS.266.688401581
ASMCMD> ls -a
none => SYSAUX.264.688401529
+DG/ASMDB/DATAFILE/SYSTEM01.DBF => SYSTEM.262.688401443
SYSTEM01.DBF
+DG/ASMDB/DATAFILE/TEST.DBF => TEST.268.689004557
TEST.DBF
none => UNDOTBS1.263.688401515
none => USERS.266.688401581
ASMCMD>
--========================================
很显然我们创建的表空间test其对应的数据文件TEST.DBF是一个别名，真实
的数据文件是TEST.268.689004557，然而在创建db时系统自动创建的几个表空间
(system,undotbs,sysaux,users)对应的都是真实的数据文件，没有别名，如何让
这几个文件使用别名呢？
SQL> select file_name from dba_data_files;

FILE_NAME
-------------------------------------------------------------------------------

+DG/asmdb/datafile/system.262.688401443
+DG/asmdb/datafile/users.266.688401581
+DG/asmdb/datafile/sysaux.264.688401529
+DG/asmdb/datafile/undotbs1.263.688401515

SQL>
--首先创建别名
SQL> alter diskgroup dg add alias '+dg/asmdb/datafile/SYSTEM01.DBF' FOR '+dg/asm
db/datafile/SYSTEM.262.688401443';

磁盘组已变更。

SQL>
--需要重建控制文件，因为controlfile中记录的名字目前是真实的名字，需要在
这里指向别名就可以了
--======================================
SQL> CREATE CONTROLFILE REUSE DATABASE "ASMDB" NORESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 '+DG/asmdb/redo01.log' SIZE 5M,
9 GROUP 2 '+DG/asmdb/redo02.log' SIZE 5M,
10 GROUP 3 '+DG/asmdb/redo03.log' SIZE 5M
11 -- STANDBY LOGFILE
12 DATAFILE
13 '+DG/asmdb/datafile/system01.dbf',
14 '+DG/asmdb/datafile/undotbs1.263.688401515',
15 '+DG/asmdb/datafile/sysaux.264.688401529',
16 '+DG/asmdb/datafile/users.266.688401581'
17 CHARACTER SET ZHS16GBK
18 ;

控制文件已创建。

SQL> alter database open;

数据库已更改。

SQL> select file_name from dba_data_files;

FILE_NAME
-------------------------------------------------------------------------------

+DG/asmdb/datafile/users.266.688401581
+DG/asmdb/datafile/sysaux.264.688401529
+DG/asmdb/datafile/undotbs1.263.688401515
+DG/asmdb/datafile/system01.dbf

SQL>