Viewing entries tagged
Oracle 10g

1 Comment

2012-11 – ASM Disk Groups and Rebalancing

Oracle Automatic Storage Management(ASM) was introduced in release 10g. ASM is Oracle’s logical volume manager, it uses OMF (Oracle Managed Files) to name and locate the database files. It can use raw disks, filesystems, or files which can be made to look like disks as long as the device is raw.

ASM uses its own database instance to manage the disks. It has its own processes and pfile or spfile and uses ASM disk groups to manage disks as one logical unit. In some ways ASM makes things more complicated – like accessing the files, copying to different locations, and viewing the time stamps of the files. It’s considered good practice to create one disk group for data (DATA) and one for archive logs and fast recovery area(FRA) per ASM instance. One disk group gets created during the cluster install and configuration (OCR). For a larger production database it’s common for it to have its own DATA and FRA disk groups.

1 Comment

Comment

2011-08 – Transportable Tablespaces and ASM

In the Oracle 10g release, Automatic Storage Management (ASM) was introduced, which provided a simplified way for DBAs to manage the storage of Oracle-related files.  However, ASM did make maintenance of the files more complicated as the files could not be directly accessed using system commands.  For the most part, this was not a problem, but it does hinder the use of another Oracle feature: transportable tablespaces.

Comment