Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what is the method of expanding disk space in Oracle". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Oracle expands disk space

Environment:

OS:Oracle Linux Server release 6.3

DB:Oracle 11.2.0.4.0

Question:

There is not enough disk space in the root directory, with 6.5g left

Solution:

Expand disk space

Since LVM is not used when installing the operating system, the root directory cannot be expanded directly, and the database-related files on disk cannot be deleted.

You can add a new disk and migrate the database files to the new disk

1 check the files related to the database are all under / U01 directory

[root@cjc ~] # cat / home/oracle/.bash_profile

.

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

.

SQL > select file_name from dba_data_files

FILE_NAME

/ u01/app/oracle/oradata/dapuchai/users01.dbf

/ u01/app/oracle/oradata/dapuchai/undotbs01.dbf

/ u01/app/oracle/oradata/dapuchai/sysaux01.dbf

/ u01/app/oracle/oradata/dapuchai/system01.dbf

/ u01/app/oracle/oradata/dapuchai/cjc_tbs01a.dbf

/ u01/app/oracle/oradata/dapuchai/ogg_tbs01.dbf

6 rows selected.

2 Linux add a new partition

-shutdown and add 100g disk, / dev/sdb

[root@dapuchai] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 28G 20G 6.5G 76% /

Tmpfs 1004M 239M 765M 24% / dev/shm

/ dev/sda1 194m 51m 134m 28% / boot

[root@cjc ~] # fdisk-l

Disk / dev/sda: 32.2 GB, 32212254720 bytes

255 heads, 63 sectors/track, 3916 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000ccbd2

Device Boot Start End Blocks Id System

/ dev/sda1 * 1 26 204800 83 Linux

Partition 1 does not end on cylinder boundary.

/ dev/sda2 26 287 2097152 82 Linux swap / Solaris

Partition 2 does not end on cylinder boundary.

/ dev/sda3 287 3917 29154304 83 Linux

Disk / dev/sdb: 107.4 GB, 107374182400 bytes

255 heads, 63 sectors/track, 13054 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x00000000

3 Division / dev/sdb1

[root@cjc ~] # fdisk / dev/sdb

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel

Building a new DOS disklabel with disk identifier 0xf58baf0e.

Changes will remain in memory only, until you decide to write them.

After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w (rite)

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to

Switch off the mode (command 'c') and change display units to

Sectors (command'u').

Command (m for help): P-view

Disk / dev/sdb: 107.4 GB, 107374182400 bytes

255 heads, 63 sectors/track, 13054 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xf58baf0e

Device Boot Start End Blocks Id System

Command (m for help): n-add

Command action

E extended

P primary partition (1-4)

P

Partition number (1-4):

Value out of range.

Partition number (1-4): 1

First cylinder (1-13054, default 1):

Using default value 1

Last cylinder, + cylinders or + size {KMagne Mpeng} (1-13054, default 13054):

Using default value 13054

Command (m for help): P

Disk / dev/sdb: 107.4 GB, 107374182400 bytes

255 heads, 63 sectors/track, 13054 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xf58baf0e

Device Boot Start End Blocks Id System

/ dev/sdb1 1 13054 104856223 + 83 Linux

Command (m for help): W-write save

The partition table has been altered!

Calling ioctl () to re-read partition table.

Syncing disks.

[root@cjc ~] # fdisk-l

Disk / dev/sda: 32.2 GB, 32212254720 bytes

255 heads, 63 sectors/track, 3916 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0x000ccbd2

Device Boot Start End Blocks Id System

/ dev/sda1 * 1 26 204800 83 Linux

Partition 1 does not end on cylinder boundary.

/ dev/sda2 26 287 2097152 82 Linux swap / Solaris

Partition 2 does not end on cylinder boundary.

/ dev/sda3 287 3917 29154304 83 Linux

Disk / dev/sdb: 107.4 GB, 107374182400 bytes

255 heads, 63 sectors/track, 13054 cylinders

Units = cylinders of 16065 * 512 = 8225280 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I size (minimum/optimal): 512 bytes / 512 bytes

Disk identifier: 0xf58baf0e

Device Boot Start End Blocks Id System

/ dev/sdb1 1 13054 104856223 + 83 Linux

4 formatting

[root@cjc] # mkfs-t ext4 / dev/sdb1

Mke2fs 1.41.12 (17-May-2010)

Filesystem label=

OS type: Linux

Block size=4096 (log=2)

Fragment size=4096 (log=2)

Stride=0 blocks, Stripe width=0 blocks

6553600 inodes, 26214055 blocks

1310702 blocks (5.00%) reserved for the super user

First data block=0

Maximum filesystem blocks=4294967296

800 block groups

32768 blocks per group, 32768 fragments per group

8192 inodes per group

Superblock backups stored on blocks:

32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208

4096000, 7962624, 11239424, 20480000, 23887872

Writing inode tables: done

Creating journal (32768 blocks): done

Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 21 mounts or

180 days, whichever comes first. Use tune2fs-c or-i to override.

5 mounting

[root@cjc ~] # mkdir / U02

[root@cjc ~] # mount / dev/sdb1 / U02

[root@cjc] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 28G 20G 6.5G 76% /

Tmpfs 1004M 88K 1004m 1% / dev/shm

/ dev/sda1 194m 51m 134m 28% / boot

/ dev/sdb1 99G 188m 94G 1% / u02

6 migrate / U01 to the newly added disk

[root@cjc ~] # mv / U01 / U03

[root@cjc ~] # mv / U02 / U01

Mv: cannot move `/ u02' to` / u01regions: Device or resource busy

[root@cjc ~] # umount / U02

[root@cjc ~] # mv / U02 / U01

[root@cjc ~] # mount / dev/sdb1 / U01

[root@cjc ~] # mv / u03swap * / U01

[root@cjc] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda3 28G 14G 13G 54% /

Tmpfs 1004M 88K 1004m 1% / dev/shm

/ dev/sda1 194m 51m 134m 28% / boot

/ dev/sdb1 99G 6.0G 88G 7% / U01

[root@cjc /] # lsblk

NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT

Sr0 11:0 1 1024M 0 rom

Sr1 11:1 1 1024M 0 rom

Sda 8:0 0 30G 0 disk

├─ sda1 8:1 0 200M 0 part / boot

├─ sda2 8:2 0 2G 0 part [SWAP]

└─ sda3 8:3 0 27.8G 0 part /

Sdb 8:16 0 100G 0 disk

└─ sdb1 8:17 0 100G 0 part / u01

7 add auto mount

[root@cjc ~] # vi / etc/fstab

.

/ dev/sdb1 / u01 ext4 defaults 0 0

8 start the database

[root@cjc ~] # su-oracle

[oracle@cjc ~] $lsnrctl start

[oracle@cjc ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 11 15:00:47 2020

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

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 839282688 bytes

Fixed Size 2257880 bytes

Variable Size 541068328 bytes

Database Buffers 289406976 bytes

Redo Buffers 6549504 bytes

Database mounted.

Database opened.

SQL > conn cjc

Enter password:

Connected.

SQL > select count (*) from T1

COUNT (*)

This is the end of the content of "what is the method of expanding disk space in Oracle". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.