Breno Tozo - DBA (Oracle Database / RAC / Dataguard / RMAN / GoldenGate) : ACFS 12C - Automatic Storage Management Cluster File System

(Description/Image BY Oracle E17612-20)

Oracle Automatic Storage Management Cluster File System (Oracle 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.

An Oracle ACFS file system communicates with Oracle ASM and is configured with Oracle ASM storage. Oracle ACFS leverages Oracle ASM functionality that enables:

Oracle ACFS dynamic file system resizing
Maximized performance through direct access to Oracle ASM disk group storage
Balanced distribution of Oracle ACFS across Oracle ASM disk group storage for increased I/O parallelism
Data reliability through Oracle ASM mirroring protection mechanisms

Oracle Automatic Storage Management Storage Layers

Capacities:

Oracle ACFS features enabled by disk group compatibility attribute settings

Disk Group Features Enabled	COMPATIBLE.ASM	COMPATIBLE.RDBMS	COMPATIBLE.ADVM
Volumes in disk groups	>= 11.2	n/a	>= 11.2
Encryption, replication, security, tagging (Linux systems)	>= 11.2.0.2	n/a	>= 11.2.0.2
Read-only snapshots	>= 11.2.0.2	n/a	>= 11.2.0.2
Encryption, replication, security, tagging (Windows systems)	>= 11.2.0.3	n/a	>= 11.2.0.3
Read-write snapshots	>= 11.2.0.3	n/a	>= 11.2.0.3
Unlimited file system expansion	>= 11.2.0.4	n/a	>= 11.2.0.4
Performance and scalability improvements in ls and find	>= 11.2.0.4	n/a	>= 11.2.0.4
Storing database data files and redo logs in Oracle ACFS file systems (except for database data files on Windows)	>= 12.1	n/a	>= 12.1
Encryption, replication, security, tagging (Solaris systems)	>= 12.1	n/a	>= 12.1
Replication and tagging (AIX systems)	>= 12.1	n/a	>= 12.1
Creation from an existing snapshot and conversion of a snapshot	>= 12.1	n/a	>= 12.1

Allocating ASM Diskgroup:

[grid@lnxrac121 ~]$ sqlplus / as sysasm

SQL*Plus: Release 12.1.0.1.0 Production on Wed Apr 30 10:33:59 2014

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> set pages 5000 lin 5000

SQL> col path for a25

SQL> SELECT GROUP_NUMBER, NAME, PATH, MOUNT_STATUS FROM V$ASM_DISK;

GROUP_NUMBER NAME PATH MOUNT_S

------------ ------------------------------ ------------------------- -------

0 ORCL:ASMDSK14 CLOSED

0 ORCL:ASMDSK15 CLOSED

0 ORCL:ASMDSK13 CLOSED

0 ORCL:ASMDSK12 CLOSED

1 ASMDSK01 ORCL:ASMDSK01 CACHED

1 ASMDSK02 ORCL:ASMDSK02 CACHED

1 ASMDSK03 ORCL:ASMDSK03 CACHED

1 ASMDSK04 ORCL:ASMDSK04 CACHED

1 ASMDSK05 ORCL:ASMDSK05 CACHED

1 ASMDSK06 ORCL:ASMDSK06 CACHED

1 ASMDSK07 ORCL:ASMDSK07 CACHED

1 ASMDSK08 ORCL:ASMDSK08 CACHED

1 ASMDSK09 ORCL:ASMDSK09 CACHED

1 ASMDSK10 ORCL:ASMDSK10 CACHED

1 ASMDSK11 ORCL:ASMDSK11 CACHED

15 rows selected.

SQL> create diskgroup DGASMFS external redundancy disk 'ORCL:ASMDSK13','ORCL:ASMDSK14' attribute 'compatible.rdbms'='12.1.0.0.0','compatible.asm'='12.1.0.0.0';

Diskgroup created.

SQL> select GROUP_NUMBER, NAME, TOTAL_MB, FREE_MB, COMPATIBILITY, VOTING_FILES FROM V$ASM_DISKGROUP;

GROUP_NUMBER NAME TOTAL_MB FREE_MB COMPATIBILITY V

------------ --------------- ---------- ---------- --------------- -

2 FRA 1019 966 12.1.0.0.0 N

3 DGASMFS 2038 1982 12.1.0.0.0 N

1 DATA 11209 5600 12.1.0.0.0 Y

SQL>

Create Volume

[grid@lnxrac121 ~]$ asmca -silent -createVolume -volumename asmvlacfs -volumeDiskgroup DGASMFS -volumesizeGB 1

Volume asmvlacfs created successfully.

[grid@lnxrac121 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Apr 30 11:07:29 2014

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> select volume_name, volume_device from v$asm_volume;

VOLUME_NAME VOLUME_DEVICE

------------------------------ ------------------------------

ASMVLACFS /dev/asm/asmvlacfs-256

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

Create ACFS

[grid@lnxrac121 ~]$ asmca -silent -createACFS -acfsVolumeDevice /dev/asm/asmvlacfs-256 -acfsMountPoint /u03/asmfs

ASM Cluster File System created on /dev/asm/asmvlacfs-256 successfully. Run the generated ACFS registration script /u01/app/grid/cfgtoollogs/asmca/scripts/acfs_script.sh as privileged user to register the ACFS with Grid Infrastructure and to mount the ACFS. The ACFS registration script needs to be run only on this node: lnxrac121.

[grid@lnxrac121 ~]$

Execute Script:

/u01/app/grid/cfgtoollogs/asmca/scripts/acfs_script.sh

Manually Register:

[root@lnxrac121 u03]# /sbin/acfsutil registry -f -a /dev/asm/asmvlacfs-256 /u03/asmfs

acfsutil registry: mount point /u03/asmfs successfully added to Oracle Registry

Mount ACFS

[root@lnxrac121 u03]# /bin/mount -t acfs /dev/asm/asmvlacfs-256 /u03/asmfs

[root@lnxrac121 u03]#

Verify Resources

Cluster Resources

[grid@lnxrac121 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.DATA.dg

ONLINE ONLINE lnxrac121 STABLE

ONLINE ONLINE lnxrac122 STABLE

ora.DGASMFS.ASMVLACFS.advm

ONLINE ONLINE lnxrac121 Volume device /dev/a

sm/asmvlacfs-256 is

online,STABLE

ONLINE ONLINE lnxrac122 Volume device /dev/a

sm/asmvlacfs-256 is

online,STABLE

ora.DGASMFS.dg

ONLINE ONLINE lnxrac121 STABLE

ONLINE ONLINE lnxrac122 STABLE

ora.FRA.dg

ONLINE ONLINE lnxrac121 STABLE

OFFLINE OFFLINE lnxrac122 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE lnxrac121 STABLE

ONLINE ONLINE lnxrac122 STABLE

ora.asm

ONLINE ONLINE lnxrac121 Started,STABLE

ONLINE ONLINE lnxrac122 Started,STABLE

ora.dgasmfs.asmvlacfs.acfs

ONLINE ONLINE lnxrac121 mounted on /u03/asmf

s,STABLE

ONLINE ONLINE lnxrac122 mounted on /u03/asmf

s,STABLE

ora.net1.network

ONLINE ONLINE lnxrac121 STABLE

ONLINE ONLINE lnxrac122 STABLE

ora.ons

ONLINE ONLINE lnxrac121 STABLE

ONLINE ONLINE lnxrac122 STABLE

--------------------------------------------------------------------------------

Cluster NODE1

[root@lnxrac121 asmfs]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.4G 9.4G 50% /

tmpfs 1.5G 139M 1.4G 10% /dev/shm

/dev/sdb1 20G 6.0G 13G 32% /u01

/dev/sdc1 20G 5.1G 14G 27% /u02

/dev/sdd1 20G 7.2G 12G 39% /u03

medias 448G 430G 19G 96% /media/sf_medias

/dev/asm/asmvlacfs-256

1.0G 207M 818M 21% /u03/asmfs

[root@lnxrac121 asmfs]#

Cluster NODE2

[root@lnxrac122 Desktop]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.8G 9.0G 53% /

tmpfs 2.0G 636M 1.4G 32% /dev/shm

/dev/sdb1 20G 5.8G 13G 31% /u01

/dev/sdc1 20G 5.0G 14G 27% /u02

/dev/sdd1 20G 172M 19G 1% /u03

medias 448G 430G 19G 96% /media/sf_medias

/dev/asm/asmvlacfs-256

1.0G 207M 818M 21% /u03/asmfs

[root@lnxrac122 Desktop]#

Tests

Test 1

[oracle@lnxrac121 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Apr 30 11:19:06 2014

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

SQL> create pfile='/u03/asmfs/pfile_cdb12.bkp.ora' from spfile;

File created.

SQL>

Test 2

[grid@lnxrac121 ~]$ cat >> test_user_grid_acfs.txt

testing acfs

[grid@lnxrac121 ~]$

[grid@lnxrac121 ~]$ cp -rp test_user_grid_acfs.txt /u03/asmfs/

[grid@lnxrac121 ~]$

[grid@lnxrac121 ~]$ ls -l /u03/asmfs/

total 72

drwx------. 2 root root 65536 Apr 30 11:17 lost+found

-rw-r--r--. 1 oracle asmadmin 1386 Apr 30 11:23 pfile_cdb12.bkp.ora

-rw-r--r--. 1 grid oinstall 13 Apr 30 11:29 test_user_grid_acfs.txt

[grid@lnxrac121 ~]$

Test 3

Volume Informations

[grid@lnxrac121 ~]$ asmcmd -p

ASMCMD [+] > volinfo -G DGASMFS asmvlacfs

Diskgroup Name: DGASMFS

Volume Name: ASMVLACFS

Volume Device: /dev/asm/asmvlacfs-256

State: ENABLED

Size (MB): 1024

Resize Unit (MB): 32

Redundancy: UNPROT

Stripe Columns: 4

Stripe Width (K): 128

Usage: ACFS

Mountpath: /u03/asmfs

Volume Statistics

ASMCMD [+] > volstat -G DGASMFS

DISKGROUP NUMBER / NAME: 3 / DGASMFS

---------------------------------------

VOLUME_NAME

READS BYTES_READ READ_TIME READ_ERRS

WRITES BYTES_WRITTEN WRITE_TIME WRITE_ERRS

-------------------------------------------------------------

ASMVLACFS

351 319488 3.913 0

895 3261440 3.944 0

ASMCMD [+] >

Resize (Increase)

[root@lnxrac121 asmfs]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.4G 9.4G 50% /

tmpfs 1.5G 139M 1.4G 10% /dev/shm

/dev/sdb1 20G 6.0G 13G 32% /u01

/dev/sdc1 20G 5.1G 14G 27% /u02

/dev/sdd1 20G 7.2G 12G 39% /u03

medias 448G 430G 19G 96% /media/sf_medias

/dev/asm/asmvlacfs-256

1.0G 207M 818M 21% /u03/asmfs

[root@lnxrac121 asmfs]# /sbin/acfsutil size +200M -d /dev/asm/asmvlacfs-256 /u03/asmfs

acfsutil size: new file system size: 1308622848 (1248MB)

[root@lnxrac121 asmfs]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.4G 9.4G 50% /

tmpfs 1.5G 139M 1.4G 10% /dev/shm

/dev/sdb1 20G 6.0G 13G 32% /u01

/dev/sdc1 20G 5.1G 14G 27% /u02

/dev/sdd1 20G 7.2G 12G 39% /u03

medias 448G 430G 19G 96% /media/sf_medias

/dev/asm/asmvlacfs-256

1.3G 207M 1.1G 17% /u03/asmfs

Resize (Decrease)

[root@lnxrac121 asmfs]# /sbin/acfsutil size 1G -d /dev/asm/asmvlacfs-256 /u03/asmfs

acfsutil size: new file system size: 1073741824 (1024MB)

[root@lnxrac121 asmfs]#

[root@lnxrac121 asmfs]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.4G 9.4G 50% /

tmpfs 1.5G 139M 1.4G 10% /dev/shm

/dev/sdb1 20G 6.0G 13G 32% /u01

/dev/sdc1 20G 5.1G 14G 27% /u02

/dev/sdd1 20G 7.2G 12G 39% /u03

medias 448G 430G 19G 96% /media/sf_medias

/dev/asm/asmvlacfs-256

1.0G 207M 818M 21% /u03/asmfs

[root@lnxrac121 asmfs]#

Mount

[root@lnxrac121 Desktop]# /sbin/mount.acfs -o all

[root@lnxrac121 Desktop]#

[root@lnxrac121 Desktop]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.4G 9.4G 50% /

tmpfs 1.5G 141M 1.4G 10% /dev/shm

/dev/sdb1 20G 6.0G 13G 32% /u01

/dev/sdc1 20G 5.1G 14G 27% /u02

/dev/sdd1 20G 7.2G 12G 39% /u03

medias 448G 430G 19G 96% /media/sf_medias

/dev/asm/asmvlacfs-256

1.0G 207M 818M 21% /u03/asmfs

[root@lnxrac121 Desktop]#

Dismount

[root@lnxrac121 Desktop]# /bin/umount -t acfs -a

[root@lnxrac121 Desktop]#

[root@lnxrac121 Desktop]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda1 20G 9.4G 9.4G 50% /

tmpfs 1.5G 141M 1.4G 10% /dev/shm

/dev/sdb1 20G 6.0G 13G 32% /u01

/dev/sdc1 20G 5.1G 14G 27% /u02

/dev/sdd1 20G 7.2G 12G 39% /u03

medias 448G 430G 19G 96% /media/sf_medias

[root@lnxrac121 Desktop]#

ACFS 12C - Automatic Storage Management Cluster File System

Capacities:

Oracle ACFS features enabled by disk group compatibility attribute settings

Allocating ASM Diskgroup:

Create Volume

Create ACFS

Mount ACFS

Verify Resources

Cluster Resources

Cluster NODE1

Cluster NODE2

Tests

Test 1

Test 2

Test 3

Volume Informations

Volume Statistics

Resize (Increase)

Resize (Decrease)

Mount

Dismount

Um comentário: