Databases Reference
In-Depth Information
At this point in the example, we're a bit out of luck—to create new ASM disk groups, you need available,
unallocated Exadata grid disks. If you attempt to create an ASM disk group, it will fail with the message shown in
Listing 9-3.
Listing 9-3.
lst09-03-create_diskgroup.sql
SQL> create diskgroup MY_DG
normal redundancy
disk 'o/*/DATA*'
attribute 'compatible.rdbms' = '11.2.0.3',
'compatible.asm' = '11.2.0.3.0',
'cell.smart_scan_capable' = 'TRUE',
'au_size' = '4M';
create diskgroup MY_DG
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15029: disk 'o/192.168.10.5/DATA_CD_11_cm01cel03' is already mounted by
this instance
SQL>
■
With exadata, grid disks and aSm disk groups are intimately related; when planning your overall
storage design, these two entities should be planned in parallel. not doing so may lead to situations where you exhaust
available cell disk capacity, preventing additional grid disks and aSm disk groups from being created. this could impose
a non-trivial impact if you have live databases on your exadata database machine or if you have security requirements
that mandate creating additional grid disks. to understand aSm-scoped and database-scoped security steps, please see
recipes 12-3 and 12-4.
Caution
To continue with this recipe, we're going to drop some ASM disk groups and the underlying grid disks so we can
provide a working example. Assuming we've already dropped a handful of ASM disk groups and have also dropped
the associated grid disks, let's resume by creating a new collection of grid disks:
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group cellcli -e \
> create griddisk all harddisk prefix=SDATA, size=141G
cm01cel01: GridDisk SDATA_CD_00_cm01cel01 successfully created
cm01cel01: GridDisk SDATA_CD_01_cm01cel01 successfully created
... lines omitted for brevity
cm01cel02: GridDisk SDATA_CD_00_cm01cel02 successfully created
cm01cel02: GridDisk SDATA_CD_01_cm01cel02 successfully created
... lines omitted for brevity
cm01cel03: GridDisk SDATA_CD_00_cm01cel03 successfully created
cm01cel03: GridDisk SDATA_CD_01_cm01cel03 successfully created
... lines omitted for brevity
[oracle@cm01dbm01 ~]$
Search WWH ::
Custom Search