Shulou(Shulou.com)06/01 Report--

Foreword:

The pre-project needs to deploy multiple sets of RAC clusters under the AIX environment. Before, there was little contact with the AIX system, but it was hit by basic commands such as creating logical volumes. In fact, there are a lot of information on the Internet. To sum up, it is also convenient for you to consult in the future.

Create a logical volume

1. View all disk Devic

# lsdev-Cc disk

Hdisk0 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk1 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk2 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk3 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk4 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk5 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk6 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk7 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk8 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk9 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk10 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk11 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk12 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk13 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk14 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk15 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Hdisk16 Available 50-T1-01 Huawei XSG1 FC Disk Drive

Note: where hdisk0 is the local storage, hdisk1-13 is the shared storage of the database, and hdisk14-16 is the shared storage applied for later mount for OGG data synchronization storage path and database backup

two。 View disk siz

# bootinfo-s hdisk14

819200

# bootinfo-s hdisk15

# bootinfo-s hdisk16

3. Create PV, backup of user database and OGG data synchronization hdisk14-16

# chdev-a pv=yes-l hdisk14

# chdev-a pv=yes-l hdisk15

# chdev-a pv=yes-l hdisk16

4. Create a volume group vg

# mkvg-y vgbackup hdisk14 hdisk15 hdisk16

# lsvg vgbackup

5. Create logical volume LV-allocate 2T space

# mklv-t jfs2-y lvbackup vgbackup 2000

# crfs-v jfs2-d lvbackup-m / oracle-p 'rw'-a logname='INLINE'

6. View mount point-view the allocation of LV in VG and the corresponding file system

# lsvg-l vgbackup

# mount / oracle

# chown-R oracle.dba / oracle

Note: it is important to set boot auto-mount, modify / etc/filesystems configuration file, mount yes

Add:

1. View volume groups and volume group details

# lsvg-o

Vgbackup

Rootvg

# lsvg rootvg

VOLUME GROUP: rootvg VG IDENTIFIER: 00fa363400004c0000000154ec43ceef

VG STATE: active PP SIZE: 256 megabyte (s)

VG PERMISSION: read/write TOTAL PPs: 799 (204544 megabytes)

MAX LVs: 256 FREE PPs: 592 (151552 megabytes)

LVs: 12 USED PPs: 207 (52992 megabytes)

OPEN LVs: 11 QUORUM: 2 (Enabled)

TOTAL PVs: 1 VG DESCRIPTORS: 2

STALE PVs: 0 STALE PPs: 0

ACTIVE PVs: 1 AUTO ON: yes

MAX PPs per VG: 32512

MAX PPs per PV: 1016 MAX PVs: 32

LTG size (Dynamic): 256kilobyte (s) AUTO SYNC: no

HOT SPARE: no BB POLICY: relocatable

PV RESTRICTION: none INFINITE RETRY: no

DISK BLOCK SIZE: 512 CRITICAL VG: no

FS SYNC OPTION: no

Note: the useful information here for creating new logical volumes is PP SIZE free PPS. We see that the PP size is 256m, and there are 592 PP unallocated to logical volumes (151552m free space).

two。 Create a logical volume

First check the disk where the volume group is located:

# lsvg-p rootvg

Rootvg:

PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION

Hdisk0 active 799 592 159..103..10..160..160

Create a logical volume:

-- View the type of file system used

# lsvg-l rootvg

# mklv-yearly lvested oracle'- tasking jfs2' rootvg 400G-create 100G

Format the file system:

# / usr/sbin/crfs-v jfs2-d 'lv_oracle'-m' / app'-A yes-p rw

File system created successfully.

104854196 kilobytes total disk space.

New File System size is 209715200

Mount:

# mount / app

View the mount path you just specified

# df-sg / app

Filesystem GB blocks Free* Used Iused Iused Mounted on

/ dev/lv_oracle 100.00 99.98% 41% / app

View the mount information of / app in / etc/filesystems:

/ app:

Dev = / dev/lv_oracle

Vfs = jfs2

Log = / dev/hd8

Mount = true

Options = rw

Account = false

Logical volume expansion

When the installation directory of oracle is insufficient, when you log in to the oracle database, you will be prompted that the device space is insufficient, as follows:

Oracle@ s1p2 [/ oracle/dumpfile] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 14 17:44:09 2016

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:

ORA-09817: Write to audit file failed.

IBM AIX RISC System/6000 Error: 28: No space left on device

Additional information: 12

ORA-01075: you are currently logged on

Logical volume expansion:

# lsvg-lp rootvg

Rootvg:

PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION

Hdisk0 active 799 328 159..39..00..00..130

# chfs-a size=+50G / dev/fslv00-- 50G extension

After expansion, check out:

# df-sg / app

Filesystem GB blocks Free* Used Iused Iused Mounted on

/ dev/fslv00 100.00 49.68 51% 69126 / app

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.