Robert G Freeman alerted the Oracle blogs world there : Grid Infrastructure 220.127.116.11 bring us a small but quite important feature for Exadata appliance , ACFS is now supported on Exadata stack !
For those of you who doesn’t now what is ASM Cluster File System , more details in the Administration Guide.
In the overview you can read the main facts :
» ACFS is a multi-platform, scalable file system, and storage management technology that extends Oracle Automatic Storage Management (Oracle ASM) functionality to support all customer files.
Oracle ACFS supports Oracle Database files and application files, including executables, database data files, database trace files, database alert logs, application reports, BFILEs,and configuration files.
Other supported files are video, audio, text, images, engineering drawings, and other general-purpose application file data.
Oracle ACFS conforms to POSIX standards for Linux and UNIX, and to Windows standards for Windows. »
Until now ACFS on Exadata was not supported. Best of practise was to remove ressouces from the CRS stack (ora.registry.acfs) . These days were gone , MOS note 1326938.1 cleary stated that in bold :
ACFS is now supported for Grid Infrastructure 18.104.22.168 or later. See Mos Note: 888828.1 – Section « Automatic Storage Management Cluster File System (ACFS) »
Furthermore, we’ve got support for 10.2.0.4 or 10.2.0.5 database files on ACFS, extract from MOS note 888828.1 :
|Automatic Storage Management Cluster File System (ACFS)||Creating AFCS file systems on Exadata storage requires the following:
Database files stored in ACFS on Exadata storage are subject to the following guidelines and restrictions:
First time 10G release appears as supported on someway on Exadata, that could be the key gateway missing on this system. Without that, no way to consolidate all these olds 10G DBs running this criticals sofware on the Exa stack. No way to discard these old and expensive servers. Now even if performance are not at maximum due to lack of smart scan capabilities with ACFS, We could expect more than correct results on the Database Server machine full of CPU Power, memory and even flash cache. Lets have this dream !
Requirements for running ACFS on Exadata are :
- You need to use Oracle Enterprise Linux
- You must setup Grid Infrastrucure 22.214.171.124 or later
- You have to ask a patch resquest for bug 19136936 if you forward to use HCC (Hybrid Column Compression)
The last and not least point to get this gateway running is to verify that Oracle Database RAC Sofware 10.2.0.1 with patchset 10.2.0.4 or 10.2.0.5 could be installed and relink on the Oracle Enterprise Linux release packaged and certified on the Exadata machine. As this was never certified it could be painful and laborious. We’re going to try that as soon as we can, challenge Oracle with it if neeeded and share the result with you, stay tuned.