Extended Oracle Database Under Aix

Current Environment Description
Operating System: AIX
Cluster software: HACMP
The following are the storage usage of the existing B-Host:

Hdisk2 00c8970083c14f90 xxora
Hdisk3 00c8970083c150c6 xxora
Hdisk4 00c8970083c151d8 xxora
Hdisk5 00c897b01a96a7a4 ggtt active
Hdisk8 00c897b01a96ed89 ggtt active
Hdisk9 00c897b01a97020.ggtt active
Hdisk10 00c897b01a971f55 ggtt active
Hdisk11 00c897b01a973596 ggtt active
Hdisk12 00c897b01a974a62 ggtt active
Hdisk13 00c897b01a9766ae ggtt active
Hdisk14 00c897b01a977e22 ggtt active

Ggtt is the logical volume group used locally, and xxora is the logical volume group to be operated on by HACMP.
Because it is in the active/standby mode, the xxora logical volume group is now mounted on machine.

Operation objective: there is no available space in the tablespace. Because the expansion slot has been used up, you can only find a solution from the existing storage space, and finally determine the solution to reduce the ggtt volume group, add the excess pv to the xxora volume group and create bare devices to ensure the database storage space.

1. Reduce the Directory
The following shows the file system with ip address 10.20.10.4. The directory to be reduced is ggtt and 2 TB.
# Df-g
Filesystem GB blocks Free % Used Iused % Iused Mounted on
/Dev/hd4 4.00 3.92 2% 5157 1%/
/Dev/hd2 4.00 1.88 54% 47368 10%/usr
/Dev/hd9var 4.00 2.89 28% 946 1%/var
/Dev/hd3 4.00 3.31 18% 1297 1%/tmp
/Dev/fwdump 0.50 0.50 1% 4 1%/var/adm/ras/platform
/Dev/hd1 4.00 4.00 1% 77 1%/home
/Proc---/proc
/Dev/hd10opt 4.00 3.84 4% 1723 1%/opt
/Dev/app 60.00 37.62 38% 7097 1%/app
/Dev/lvggtt01 7550.00 4585.20 40% 380415 1%/ggtt
/Dev/gtOracle 1898.00 1692.82 11% 27137 1%/app/gtoracle

Note: Because the sched policy is parallel rather than striped, the two PVS hdisk12 and hdisk13 can be smoothly released when chfs is used. For striped, some additional operations may be required to migrate the remaining pv data to another small pv.

# Lslv lvgtyx01
Logical volume: lvgtyx01 volume group: gtyx
Lv identifier: 00c897b000004c00000001291a9d3124. 1 PERMISSION: read/write
Vg state: active/complete lv state: opened/syncd
TYPE: jfs2 write verify: off
MAX LPs: 20000 pp size: 512 megabyte (s)
COPIES: 1 sched policy: parallel
LPs: 15100 PPs: 15100
STALE PPs: 0 bb policy: relocatable
INTER-POLICY: minimum RELOCATABLE: yes
INTRA-POLICY: middle upper bound: 1024
Mount point:/gtyx LABEL:/gtyx
Mirror write consistency: on/ACTIVE
Each lp copy on a separate pv? : Yes
Serialize IO? : NO
DEVICESUBTYPE: DS_LVZ

Reduce file system commands
# Chfs-a size =-2100G/ggtt
Filesystem size changed to 11429478400

The reduced file system is as follows:
# Df-g
Filesystem GB blocks Free % Used Iused % Iused Mounted on
/Dev/hd4 4.00 3.92 2% 5157 1%/
/Dev/hd2 4.00 1.88 54% 47369 10%/usr
/Dev/hd9var 4.00 2.88 28% 947 1%/var
/Dev/hd3 4.00 3.31 18% 1307 1%/tmp
/Dev/fwdump 0.50 0.50 1% 4 1%/var/adm/ras/platform
/Dev/hd1 4.00 4.00 1% 77 1%/home
/Proc---/proc
/Dev/hd10opt 4.00 3.84 4% 1723 1%/opt
/Dev/app 60.00 37.62 38% 7097 1%/app
/Dev/lvggtt01 5450.00 2485.52 55% 380415 1%/ggtt
/Dev/gtoracle 1898.00 1692.32 11% 27149 1%/app/gtoracle

1 2 3 4 Next Page