Tuesday, July 25, 2017

How to make the ACFS on the Exadata

The usual case: customer on IBM POWER or HP Itanium wants to migrate its database to Exadata.

In order to migrate the database from non-x64 hw platform we usually need the additional storage to convert datafiles or to store DataPump files. But customer wishing make such migration have no such storage usually.

In this case the Exadata with HC-disks is the great platform which can help us.

The idea is to create the file system from RECO disk group on the Exadata and mount it on the source server.

CREATE:

# su - grid


U can use asmca or sqlplus:

$ sqlplus / as sysasm
SQL> alter diskgroup RECOC1 add volume expdp size 36T;


$ ls -l /dev/asm
total 0
brwxrwx--- 1 root asmadmin 251, 44033 Jul 19 09:12 expdp-86

$ /sbin/mkfs -t acfs /dev/asm/expdp-86


[grid@edbadm01 ~]$ /u01/app/12.2.0.1/grid/bin/srvctl add filesystem -d /dev/asm/expdp-86 -m /expdp -u oracle -fstype ACFS -autostart ALWAYS
PRCN-2018 : Current user grid is not a privileged user
 

# /u01/app/12.2.0.1/grid/bin/srvctl add filesystem -d /dev/asm/expdp-86 -m /expdp -u oracle -fstype ACFS -autostart ALWAYS
 

# /u01/app/12.2.0.1/grid/bin/srvctl start filesystem -d /dev/asm/expdp-86
# chown oracle:dba /expdp
# chmod 775 /expdp


[root@edbadm01 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
...
/dev/asm/expdp-86      12T   25G   12T   1% /expdp

[root@edbadm01 ~]# ls -ld /expdp/
drwxrwxr-x 4 oracle dba 32768 Jul 18 15:20 /expdp/


REMOVE:


[root@edbadm01 ~]# /u01/app/12.2.0.1/grid/bin/srvctl stop filesystem -d /dev/asm/expdp-86
[root@edbadm01 ~]# /u01/app/12.2.0.1/grid/bin/srvctl remove filesystem -d /dev/asm/expdp-86
[root@edbadm01 ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VGExaDb-LVDbSys1
                       30G  7.4G   21G  27% /
tmpfs                 253G  3.2G  250G   2% /dev/shm
/dev/sda1             504M   40M  439M   9% /boot
/dev/mapper/VGExaDb-LVDbOra1
                       99G   63G   31G  68% /u01
/dev/mapper/VGExaDb-LVStore
                      962G   49G  865G   6% /store

[root@edbadm01 ~]# ls -l /dev/asm/
total 0
brwxrwx--- 1 root asmadmin 251, 44033 Jul 18 20:14 expdp-86
[root@edbadm01 ~]# su - grid
[grid@edbadm01 ~]$ sqlplus / as sysasm
SQL> alter diskgroup RECOC1 drop volume expdp;

Diskgroup altered.


The next step is to configure the NFS server on Exadata and present the NFS-share to external server.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...