- Saya punya 6 buah disk masing masing kapasitas 100 GB.
- Menggunakan ASM saya buat satu diskgroup nama 'dgroupA' dengan normal
redundancy
- didalam 'dgroupA' ada dua failure group 'fg1' dan 'fg2'
- masing-masing failure group mempunyai 3 anggota disk. 'fg1'(disk1, disk2,
disk3) dan 'fg2'(disk4, disk5, disk6)
Pertanyaannya:
- Berapa kapasitas maksimum penyimpanan di diskgroup 'dgroupA' ? (200GB,
300GB, atau 600GB)
- Kalo saya mempunyai satu datafile, untuk redundancy, datafile tersebut
akan disimpan dimana saja ? di tiap failure group, atau di tiap anggota
failure group ?
Thanks-Syauqi
On 4/27/06, Muhamad Ramli <[EMAIL PROTECTED]> wrote:
>
> The components of Automatic Storage Management (ASM) are :
>
> 1. disk groups
> 2. disks
> 3. failure groups
> 4. files
> 5. templates
>
> Disk Groups
> =============
> The primary component of ASM is the disk group. A disk group consists
> of a grouping of disks that are managed together as a unit. You
> configure ASM by creating disk groups to store database files. Oracle
> provides SQL statements that create and manage disk groups, their
> contents, and their metadata.
>
> Disks
> ==============
>
> The disks in a disk group are referred to as ASM disks. On Windows
> operating systems, an ASM disk is always a partition. On all other
> platforms, an ASM disk can be:
>
> - A partition of a logical unit number (LUN)
> - A network-attached file
>
> Failure Groups & its benefits
> ==============================
>
> Failure groups define ASM disks that share a common potential failure
> mechanism. An example of a failure group is a set of SCSI disks
> sharing the same SCSI controller. Failure groups are used to determine
> which ASM disks to use for storing redundant copies of data. For
> example, if two-way mirroring is specified for a file, ASM
> automatically stores redundant copies of file extents in separate
> failure groups. Failure groups apply only to normal and high
> redundancy disk groups. You define the failure groups in a disk group
> when you create or alter the disk group.
>
> Files
> =================
>
> Files written on ASM disks are ASM files, whose names are
> automatically generated by ASM. You can specify user-friendly alias
> names (or just aliases) for ASM files, and you can create a
> hierarchical directory structure for these aliases. Each ASM file is
> completely contained within a single disk group, and is evenly spaced
> over all of the ASM disks in the disk group.
>
> Templates
> ==================
>
> Templates are collections of file attribute values, and are used to
> set mirroring and striping attributes of each type of database file
> (datafile, control file, redo log file, and so on) created in ASM disk
> groups. Each disk group has a default template associated with each
> file type.
>
> You can also create your own templates to meet unique requirements.
> You can then include a template name when creating a file, thereby
> assigning desired attributes on an individual file basis rather than
> on the basis of file type.
>
> Best regards,
> M. Ramli
>
>
>
> --- In [email protected], Syauqi <[EMAIL PROTECTED]> wrote:
> >
> > Thanks,
> >
> > di ASM (Automatic Storage Management) ada istilah FAILURE GROUP.
> > Apa yang dimaksud dengan istilah ini, dan apa manfaat penggunaannya?
> >
> > Thanks-Syauqi
> >
> >
> > On 4/27/06, Tomi Wijanto <[EMAIL PROTECTED]> wrote:
> > >
> > > Heap-organized table adalah tabel yg paling umum kita
> > > pakai. Secara default tipe tabel adalah Heap.
> > >
> > > Index-org table (IOT) adalah tabel yang memiliki
> > > struktur sebagai index. Artinya apabila ada data baru
> > > di-insert, maka data tsb akan diletakkan pada
> > > urutan-nya sesuai dengan primary key.
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
>
>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "indo-oracle<http://groups.yahoo.com/group/indo-oracle>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>
[Non-text portions of this message have been removed]
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
YAHOO! GROUPS LINKS
- Visit your group "indo-oracle" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
