Oracle Magazine - September/October 2010

Automatic Storage Management Cluster File System administration tools.

To drop a volume, he issues
completely online operation:

/sbin/acfsutil size +2000M /acfsdir1

of the cluster without requiring any specialized software. W

SQL> alter diskgroup ACFSDG1 drop volume ACFSVOL11;

John explains that other commands are
equally simple and that the graphical inter-
face of Oracle Enterprise Manager offers an
even easier-to-use administrative interface.

Finally, John reviews the team’s original problems and shows how his solution addresses them, as summarized in Table 1.

To unregister a file system from the Oracle Automatic Storage Management volume registry, he uses

acfsutil registry -d /acfs1

To delete the snapshots, he issues

/sbin/acfsutil snap delete backup1 /acfsdir1

One of Craig’s requirements is to add space to the file system on the fly without any application outages. John shows how to add 2,000 MB to the file system, using a

CONCLUSION

Oracle Automatic Storage Management Cluster File System is a very powerful addition to Oracle Database 11 g Release 2 that enables the creation of sophisticated, feature-rich clustered file systems. Oracle Automatic Storage Management Cluster File System makes it possible for legacy applications to access files through a regular file system visible to all the nodes

Arup Nanda (arup@
proligence.com) has
been an Oracle DBA
for more than 14 years,
handling all aspects of
database administration,
from performance tuning to security and
disaster recovery. He was Oracle Magazine’s
DBA of the Year in 2003.

NEXT STEPS

LEARN more about Oracle Automatic Storage Management Cluster File System and Oracle Automatic Storage Management download.oracle.com/docs/cd/E11882_01/ server.112/e10500/asmfilesystem .htm#CACCHAFH oracle.com/technology/products/database/asm

...and here, and here. LOADSPRING the enterprise level web-hosting solution for project management software, hosts over 45 PM applications. Consider us your PM application destination.