Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

AIX adds bare device data files to oracle

2025-02-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

Platform:AIX 5.3 standalone has a free disk hdisk1

General idea: Physical Volume PV-> Volume Group VG-> Logical Volume LV (type: raw)-> Add Tablespace

1. View all available volume groups

# lsvg -o

rootvg

2. Create volume group datavg for ORACLE

# smitty lvm

Volume Groups

Add a Volume Group

Add an Original Volume Group

[Entry Fields]

VOLUME GROUP name [datavg]

Physical partition SIZE in megabytes 64 +

* PHYSICAL VOLUME names [hdisk1] +

Force the creation of a volume group? no +

Activate volume group AUTOMATICALLY yes +

at system restart?

Volume Group MAJOR NUMBER [] +#

Create VG Concurrent Capable? no +

# lsvg -o

datavg

rootvg

3. Create lvdata002 bare device for datavg

Create a bare device

# mklv -t raw -y lvdata002 -a e -e x -o y datavg 10

lvdata002

-e x Set bare device to multi-disk partition

Assign 10 PPs, i.e. 640M

# lsvg -l datavg

datavg:

LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT

lvdata002 raw 10 10 1 closed/syncd N/A

1 logical volume (bare device) of this volume group is unused (if logical volume with closed/syncd status is displayed in results)

Bare Device Permission

# chown -R oracle:oinstall /dev/rlvdata*

# chown -R oracle:oinstall /dev/lvdata*

4. Log in to ORACLE and add bare device data files to table space USERS

SQL> alter tablespace users add datafile '/dev/rlvdata002' size 100M; //SIZE cannot be equal to or greater than LV value, bare device name/dev/rlv*

Tablespace altered.

added successfully

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report