1. ASM FileNames

(1) fully qualified filename

+group/dbname/file_type/file_type_tag.file.incarnation

file_type和file_type_tag可查表

(2) Numeric ASM Filename

+group.file.incarnation

(3) Alias ASM Filenames

+dgroup1/myfiles/control_file1

Alias不可以以数字结尾,以区别于fully qualified filename

(4) Alias ASM Filename with Template

+dgroup(template_name)/alias

(5) Incomplete ASM Filename

+dgroup1

系统自动产生相应的文件名

(6) Incomplete ASM Filename with Template

+dgroup1(my_template)


2. Alias FileName

ALTER DISKGROUP dgroup1 ADD ALIAS '+dgroup1/mydir/second.dbf' FOR '+dgroup1/sample/datafile/mytable.342.3';

ALTER DISKGROUP dgroup1 RENAME ALIAS '+dgroup1/mydir/datafile.dbf' TO '+dgroup1/payroll/compensation.dbf';

ALTER DISKGROUP dgroup1 DROP ALIAS '+dgroup1/payroll/compensation.dbf';

ALTER DISKGROUP dgroup1 DROP FILE '+dgroup1/payroll/compensation.dbf';

3. FTP Access

4. DBMS_FILE_TRANSFER

5. Directories

ALTER DISKGROUP dgroup1 ADD DIRECTORY '+dgroup1/mydir';

ALTER DISKGROUP dgroup1 RENAME DIRECTORY '+dgroup1/mydir' TO '+dgroup1/yourdir';

ALTER DISKGROUP dgroup1 DROP DIRECTORY '+dgroup1/yourdir' FORCE;

6. Templates

ALTER DISKGROUP disk_group_name ADD TEMPLATE template_name ATTRIBUTES ([{MIRROR|HIGH|UNPROTECTED}] [{FINE|COARSE}]);

ALTER DISKGROUP dgroup2 ADD TEMPLATE unreliable ATTRIBUTES (UNPROTECTED);
ALTER DISKGROUP dgroup2 MODIFY TEMPLATE reliable ATTRIBUTES (COARSE);
ALTER DISKGROUP dgroup2 DROP TEMPLATE unreliable;

ALTER SYSTEM SET DB_CREATE_FILE_DEST = '+dgroup1(my_template)';
CREATE TABLESPACE tspace3;

6. 一本关于ASM的好书

McGraw.Hill.Oracle.Automatic.Storage.Management