Monday, March 7, 2011

How to extend disk space in Linux LVM

Environment
Quater rack Exadata

Problem
Limited disk space in the DB server.

[oracle@thordb02 ~]$ df -h
Filesystem                                           Size  Used   Avail       Use%   Mounted on
/dev/mapper/VGExaDb-LVDbSys1
                                                          30G  4.4G    24G       16%     /
/dev/sda1                                        124M   16M   102M     14%     /boot
/dev/mapper/VGExaDb-LVDbOra1
                                                         99G   12G    82G        13%    /u01
tmpfs                                                81G   192M   81G       1%     /dev/shm

However, "vgdisplay" shows that there are 403 GB free physical extends:

[root@exadata02~]# vgdisplay
  --- Volume group ---
  VG Name               VGExaDb
  System ID
  Format                lvm2
  Metadata Areas        1
  Metadata Sequence No  4
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                3
  Open LV               3
  Max PV                0
  Cur PV                1
  Act PV                1
  VG Size               557.62 GB
  PE Size               4.00 MB
  Total PE              142751
  Alloc PE / Size       39424 / 154.00 GB
  Free  PE / Size       103327 / 403.62 GB
  VG UUID               97W2L1-SnRc-MyS2-UvNJ-hkiB-df6t-b0SdWf


Solution
I followed instructions found in this article to extend the free disk space in the server, here are the commands I used:
1 lvcreate --name u02 --size 400g VGExaDb
2 mkfs.ext3 /dev/VGExaDb/u02
3 mount /dev/VGExaDb/u02 /u02
4 Edit /etc/fstab file to add /u02 so that when server reboots, /u02 will be automatically mounted.

References

  1. A Beginner's Guide To LVM - Page 2
  2. Extending a logical volume
  3. Linux Logical Volume Manager Walkthrough
  4. Can I run fsck or e2fsck when Linux file system is mounted?
  5. Extending a Logical Volume
  6. Logical Volume Manager: How can I extend a Volume Group?
  7. Quick HOWTO : Ch27 : Expanding Disk Capacity
  8. The Linux Logical Volume Manager





Labels: ,

Thursday, March 3, 2011

EXADATA: How to obtain key information like serial numbers [ID 748983.1]

EXADATA: How to obtain key information like serial numbers [ID 748983.1]
Following was copied from the above note:

[root ~]# dmidecode -s system-product-name
ProLiant DL360 G5
[root ~]# dmidecode -s system-serial-number
USE835NAJG

Another option will be generating a file with the data generated by command dmidecode and uploading the file to the Service Request.

#dmidecode > `hostname`_dmidecode.txt

Labels:

Friday, January 28, 2011

Exadata Related Oracle Notes

Oracle Sun Database Machine Setup/Configuration Best Practices [ID 1067527.1]




Exadata V2 Starter Kit [ID 1244344.1]

Contents

Labels: ,

Monday, January 10, 2011

Some good articles about Oracle

1 面对一个全新的环境,作为一个Oracle DBA,首先应该了解什么?
2 Oracle GridControl 11gR1 for Linux 安装和配置指南
3 exadata x2-8的技术方向终于向正确的方向有所改进
4 Oracle Support Master Note for 10g Enterprise Manager Grid Control Agent Performance & Core Dump issues (Doc ID 1087997.1)
5 Working with Materialized Views Creation, Refresh and Monitoring
6 Starting and Stopping Oracle Enterprise Manager 11g Grid Control
7 Grid Control 11 Known Issues, Bugs and Features
8 Master Note: How to diagnose Database Performance - FAQ [ID 402983.1]
9 No Response from the Server, Does it Hang or Spin? [ID 68738.1]
10 Data Gathering for Troubleshooting RAC Issues [ID 556679.1]
11 What is enq: TX - row lock contention?
12 enq: TX - row lock contention
13 Use Batch File to Create Filename Using Date and Time
14 EMD upload error: Upload was successful but collections currently disabled - disk full
15 SQL Loader
16 Script to Detect Tablespace Fragmentation [ID 1020182.6]
17 Important Changes to Oracle Database Patch Sets Starting With 11.2.0.2 [ID 1189783.1]
18 Troubleshooting Oracle Clusters and Oracle RAC







Labels: , , , , , , , ,