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.
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.