學習ASM技術（五）--檔名和Template

yezhibin發表於2010-03-15
ASM
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章