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

面对一个全新的环境,作为一个Oracle DBA,首先应该了解什么?
2 Oracle GridControl 11gR1 for Linux 安装和配置指南
exadata x2-8的技术方向终于向正确的方向有所改进
Oracle Support Master Note for 10g Enterprise Manager Grid Control Agent Performance & Core Dump issues (Doc ID 1087997.1)
Working with Materialized Views Creation, Refresh and Monitoring
Starting and Stopping Oracle Enterprise Manager 11g Grid Control
Grid Control 11 Known Issues, Bugs and Features
Master Note: How to diagnose Database Performance - FAQ [ID 402983.1]
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: , , , , , , , ,