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
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/100682/viewspace-1025037/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/100682/viewspace-1025037/