Oracle Automatic Storage Management
Cluster File System (ACFS) on Exadata Database Machine:
Starting with Oracle Grid Infrastructure version 12.1.0.2, Oracle ACFS supports all database files and general purpose files on Oracle Exadata Database Machine running Oracle Linux on database servers.
The following database versions are supported by Oracle ACFS on Exadata Database Machine:
Starting with Oracle Grid Infrastructure version 12.1.0.2, Oracle ACFS supports all database files and general purpose files on Oracle Exadata Database Machine running Oracle Linux on database servers.
The following database versions are supported by Oracle ACFS on Exadata Database Machine:
- Oracle Database 10g Rel. 2 (10.2.0.4 and 10.2.0.5)
- Oracle Database 11g (11.2.0.4 and higher)
- Oracle Database 12c (12.1.0.1 and higher)
The below steps are duly tested in Exadata X7 machines
Pre-requisite for ACFS creation
- Verify if ACFS/ADVM module is loaded ( oracleacfs & oracleadvm )
dcli -g
/home/oracle/dbs_group -l oracle 'lsmod | grep oracle'
Step by step instruction to
create ACFS on Exadata
- As ORAGRID : Create ASM volume to be used for ACFS file systems on FLASH01 DG
|
asmcmd volcreate -G FLASH01 -s 10G
acfsvol
|
2) As ORAGRID: Capture the
volume device name
|
asmcmd volinfo -G
FLASH01 acfsvol
|
For example this case:
Diskgroup Name: FLASH01
Volume Name: ACFSVOL
Volume Device: /dev/asm/acfsvol-118
State: ENABLED
Size
(MB): 10240
Resize Unit (MB): 512
Redundancy: MIRROR
Stripe Columns: 8
Stripe Width (K): 1024
Usage:
Mountpath:
3) As ORAGRID: verify if the
volume device name created on all the nodes
|
dcli -g
/home/oracle/dbs_group -l oracle ‘s -l /dev/asm/acfsvol-118’
|
4) As ORAGRID: Verify if ADVM
is enabled
|
crsctl stat res ora.FLASH01.ACFSVOL.advm
-t
|
For example this case:
crsctl stat res ora.FLASH01.ACFSVOL.advm -t
--------------------------------------------------------------------------------
Name Target State
Server State
details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FLASH01.ACFSVOL.advm
ONLINE ONLINE
fraespou0101 STABLE
ONLINE ONLINE
fraespou0102 STABLE
ONLINE ONLINE
fraespou0103 STABLE
ONLINE ONLINE
fraespou0104 STABLE
--------------------------------------------------------------------------------
For example this case:
5) AS ORAGRID: Create ACFS on ADVM
|
/sbin/mkfs -t acfs
/dev/asm/acfsvol-321 –b 4K
|
6) As root -
Create the mount points for the file systems and change ownership
|
dcli -g ~/dbs_group -l
root ‘mkdir /u01/app/oracle/admin/common’
dcli -g ~/dbs_group -l
root 'chown oracle:oinstall /u01/app/oracle/admin/common’
dcli -g ~/dbs_group -l
root 'chmod 775 /u01/app/oracle/admin/common’
|
7) As ROOT: Add filesystem
|
/u01/app/oragrid/product/18.0/bin/srvctl
add filesystem -d /dev/asm/acfsvol-321 -m
/u01/app/oracle/admin/common -u oracle -fstype ACFS
-autostart ALWAYS
|
8) As ROOT/Oracle: Start filesystem
|
/u01/app/oragrid/product/18.0/bin/srvctl
start filesystem -d /dev/asm/acfsvol-321
|
Verifications
9) root/oragrid: Verify if
change ownership and permission
|
crsctl stat res
ora.FLASH01.ACFSVOL.acfs -t
|
crsctl stat res ora.FLASH01.ACFSVOL.advm –t
10) as Oracle: list the ACFS
FS from all the nodes
|
dcli -g /home/oracle/dbs_group -l oracle df –h /u01/app/oracle/admin/common
|
11) as Oracle: Touch a file on
the ACFS FS from all the nodes
|
dcli -g /home/oracle/dbs_group -l oracle touch /u01/app/oracle/admin/common/a.txt
dcli -g /home/oracle/dbs_group -l oracle cat /u01/app/oracle/admin/common/a.txt
|
No comments:
Post a Comment