OracleforAIX bare-device-based tablespace expansion step Aggregation

View existing VG # lsvgrootvgoravgdatavg view the usage status of each VG # lsvgoravg focuses on several values PPSIZE: 512 megabyte (s)

View existing VG # lsvg rootvg oravg datavg view the status of each VG # lsvg oravg focuses on several values pp size: 512 megabyte (s)

View existing VG

# Lsvg

Rootvg

Oravg

Datavg

View the usage status of each VG

# Lsvg oravg

Focus on several values

Pp size: 512 megabyte (s) Note: SIZE of each PP

FREE PPs: 147 (75264 megabytes) Note: number of available pp and Space

# Lsvg datavg

Pp size: 512 megabyte (s)

FREE PPs: 3974 (2034688 megabytes)

View the number of created lv instances

# Lsvg-l rootvg Note: The rootvg does not contain the lv information about the database.

# Lsvg-l oravg

..................................

Lv_users_49 raw 128 128 1 open/syncd N/

Lv_users_50 raw 128 128 1 open/syncd N/

Lv_users_51 raw 128 128 1 open/syncd N/

Lv_users_52 raw 128 128 2 open/syncd N/

# Lsvg-l datavg

Datavg:

Lv name type LPs PPs PVs LV STATE MOUNT POINT

Lv_users_53 raw 128 128 1 open/syncd N/

Lv_users_54 raw 128 128 1 open/syncd N/

Lv_users_55 raw 128 128 1 open/syncd N/

Lv_users_56 raw 128 128 1 open/syncd N/

Lv_users_57 raw 128 128 1 open/syncd N/

Lv_users_58 raw 128 128 1 open/syncd N/

Lv_users_59 raw 128 128 1 open/syncd N/

Lv_users_60 raw 128 128 1 open/syncd N/

After viewing, the new lv is created from lv_users_61.

For example:

Create ten lv blocks under oravg, each of which is 64 GB in size and is named

Lv_users_61 lv_users_62 lv_users_63 ...... lv_users_64

PP_Size = 512 M, 64G/PP_Size = 128 (NumPPs)

Command Format:

"/Usr/sbin/mklv-y LVname-t o-w n-s n-r n VGname NumPPs"

# Mklv-y lv_users_61-t 'raw '-t o-w n-s n-r n datavg 128

# Mklv-y lv_users_62-t 'raw '-t o-w n-s n-r n datavg 128

# Mklv-y lv_users_63-t 'raw '-t o-w n-s n-r n datavg 128

......

# Mklv-y lv_users_70-t 'raw '-t o-w n-s n-r n datavg 128

Modify rlv block Device Permissions

# Cd/dev/

# Ls-l rlv_user_60 view previous block Device Permissions

# Ls-l rlv_user_61 view the block device permission just created

# Chown Oracle: dba rlv_user_61

# Chown oracle: dba rlv_user_62

# Chown oracle: dba rlv_user_63

......

# Chown oracle: dba rlv_user_70

Add the command to the tablespace Usersoracle and add the space

# Su-oracle

$ Sqlplus/nolog

$ Conn sys/oracle as sysdba;

Go to sqlplus

> Alter tablespace "USERS" add datafile '/dev/rlv_users_61' SIZE 65500 m reuse;

> Alter tablespace "USERS" add datafile '/dev/rlv_users_62' SIZE 65500 m reuse;

> Alter tablespace "USERS" add datafile '/dev/rlv_users_63' SIZE 65500 m reuse;

......

> Alter tablespace "USERS" add datafile '/dev/rlv_users_70' SIZE 65500 m reuse;

Add one by one, enter the space addition command, and wait patiently until the prompt that the addition is successful.

Add command.

Check the table space after adding the table. Make sure that the table is added successfully!