计算机组成怎么生成asm文件名,学习ASM技术（五）--文件名和Template

1、数据文件命名含义

SQL> select file_name from dba_data_files;

FILE_NAME

------------------------------------------------------------

+ASM_DISKGROUP/ora10g/datafile/system.259.712716453

+DG1/ora10g/datafile/undotbs1.259.712716475

+ASM_DISKGROUP/ora10g/datafile/sysaux.260.712716487

+ASM_DISKGROUP/ora10g/datafile/users.261.712716503

格式说明：

+DATA/yoda/datafile/tbs_name.asm_filenumber.incarnation_number

+DATA: diskgroup名

yoda: 该数据库名

datafile: 文件类型，表示是数据文件

tbs_name: 表空间名

asm file#: 表示ASM file编号，$asm_file.file_number

incarnation number:  从时间戳提取，唯一值  。

2、在ASM实例中查询文件编号和大小

$export ORACLE_SID=+ASM

SQL>sqlplus '/as sysdba'

SQL> select file_number, bytes/1024/1024 from v$asm_file;

FILE_NUMBER        BYTES/1024/1024

-------------------------- ---------------

259                      500.007813

260                      340.007813

261                      5.0078125

259                      340.007813

所查询到的值，与dba_data_files相匹配。

3、数据文件的模板(template)管理

查看数据文件属性

SQL>select name, redundancy, striped

from v$asm_alias a, v$asm_file b

where a.file_number = b.file_number

and  a.group_number = b.group_number

order by name;

NAME                                                        REDUND     STRIPE

------------------------------------------------ ----------------- ------------

Current.256.712716441                            HIGH           FINE

Current.257.712716441                            HIGH           FINE

Current.258.712716441                            HIGH           FINE

SYSAUX.260.712716487                          MIRROR      COARSE

SYSTEM.259.712716453                          MIRROR      COARSE

TEMP.260.712716493                               UNPROT     COARSE

UNDOTBS1.259.712716475                    UNPROT     COARSE

USERS.261.712716503                            MIRROR      COARSE

control01.ctl                                                  HIGH            FINE

control02.ctl                                                  HIGH            FINE

control03.ctl                                                  HIGH            FINE

group_1.256.712716443                          UNPROT      FINE

group_2.257.712716445                          UNPROT      FINE

group_3.258.712716447                          UNPROT      FINE

redo01.log                                                    UNPROT      FINE

redo02.log                                                    UNPROT      FINE

redo03.log                                                    UNPROT      FINE

spfile.262.712718229                                MIRROR      COARSE

spfileora10g.ora                                          MIRROR      COARSE

系统管理人员能改变系统缺省 template, 但不能删除该删除，管理员能增加自己的template，然后在该模板上创建数据文件。

SQL> alter diskgroup dg1 add template noncritical_files attributes (unprotected);

SQL> create tablespace test datafile '+DG1/test.dbf(noncritical_files)' size 100M;

更改template属性

SQL>alter diskgroup dg1 alter template noncritical_files attributes (coarse);

删除template

SQL> alter diskgroup dg1 drop template noncritical_files;

以下是ASM 缺省template信息

文件类型                              缺省模板                缺省条带化

------------------------------- ------------------------  ---------------------

archived redo logs       ARCHIVELOG             coarse

control files                   CONTROLFILE            fine

control files autobackup AUTOBACK              coarse

datafile                            DATAFILE                    coarse

datafile backup piece   BACKUPSET              coarse

DataGuard broker

configuration                  DATAGUARDCONFIG coarse

datapump Dumpset     DUMPSET                    coarse

flashback logs               FLASHBACK                fine

Online Redo Logs         ONLINELOG                fine

spfile                                PARAMETERFILE        coarse

tempfiles                         TEMPFILE                      coarse

查看ASM template

SQL>select * from v$asm_template;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/354732/viewspace-629497/，如需转载，请注明出处，否则将追究法律责任。