Table space management for bare devices on AIX

As a widely used database, Oracle runs stably on the AIX database and is widely used in some key departments and industries. As a special data storage medium, bare devices can directly operate data, saving the first level of the operating system and making it faster. Although oracle began to provide less and less support for bare devices at the beginning of the 11g, it is believed that the management of bare devices in the database is still quite extensive.

1. view the active volume group

2. view the volume group space

Each pp size512MB and free pp1062 are displayed.

3. Create a logical volume

Create a logical volume. You can specify the size or number of pp.

4. View logical volumes under a volume group

Logical volumes include open and closed, where open is used and closed is not used. To delete a logical volume, you must first Delete the tablespace above it.

5. Modify volume group attributes

We just created a logic volume for nagios, which is also a device block.

First, we need to understand two concepts.

Block: starts with B. Random access devices use cache technology to access data by block. Typical is the file system on the hard disk.

Character device: starts with c. Stream-oriented device types written in sequence are used, and the buffer method is not used for optimization during access. This is typically a bare device.

The created/dev/nagios is a block device, And/dev/rnagios is the corresponding character device.

Chown-R oracle: dba/dev/rnagios

6. Create a tablespace

SQL> conn/as sysdba

SQL> create tablespace nagios datafile '/dev/rnagios' size 45 m;

The size here is slightly smaller than the capacity of the bare device.

Then, specify the user who uses the tablespace to use the bare device space for the data created by the user.

By the way, if it is in the rac environment, it is difficult to set up the tablespace here to restart the data synchronization node. You can refer to my "RAC environment database restart instance" to share with me.

Install Oracle 10g RAC-ASM + bare Device on VMware

Install Oracle on bare devices on AIX

Oracle for AIX bare-device-based tablespace expansion step Aggregation