Header block is the first one of an ASM disk device, and its default size is 4096 bytes (This size is available in _asm_blksize undocumented parameter). SQL> select path from v$asm_disk where group_number=1 Īnd now, we erase the header block of each disk. SQL> select group_number,name,type,state from v$asm_diskgroup My ASM instance manages two diskgroups DATA (external redundancy) and RL (normal redundancy).ĭATA is a 2 disks diskgroup managed by asmlib. SQL> select file_id,tablespace_name,file_name,status,online_status from dba_data_filesįILE_ID TABLESPACE_NAME FILE_NAME STATUS ONLINE_Ĥ USERS /u02/oradata/orcl/users01.dbf AVAILABLE ONLINEģ UNDOTBS1 /u02/oradata/orcl/undotbs01.dbf AVAILABLE ONLINEĢ SYSAUX /u02/oradata/orcl/sysaux01.dbf AVAILABLE ONLINEġ SYSTEM /u02/oradata/orcl/system01.dbf AVAILABLE SYSTEMĥ EXAMPLE /u02/oradata/orcl/example01.dbf AVAILABLE ONLINEĦ TEST +DATA/orcl/datafile/test.258.798578613 AVAILABLE ONLINE SQL> select instance_name from v$instance SQL> create tablespace test datafile '+data' size 5M autoextend on maxsize unlimited The Oracle base remains unchanged with value ~]$ sqlplus / as sysdba The TEST’s datafile will be managed by ASM. In this post, I will explain one of my last works about the ASM disk header block.įirst, I will create a TEST tablespace in my orcl database.
0 kommentar(er)
