Add space to the ASM disk group!

Source: Internet
Author: User

The space of the ASM disk group is insufficient.
[Oracle @ linux117 ~] $ ID
Uid = 1101 (Oracle) gid = 1000 (oinstall) groups = 1000 (oinstall), 1200 (DBA), 1300 (asmdba), 1400 (region)
[Oracle @ linux117 ~] $ Asmcmd
Asmcmd> lsdg
State type rebal sector block au total_mb free_mb req_mir_free_mb usable_file_mb offline_disks voting_files name
Mounted extern n 512 4096 1048576 6 0 6 0 n data/

[Oracle @ linux117 ~] $ ID
Uid = 1101 (Oracle) gid = 1000 (oinstall) groups = 1000 (oinstall), 1200 (DBA), 1300 (asmdba), 1400 (region)

[Oracle @ linux117 ~] $. Oraenv
Oracle_sid = [orcl]? + ASM
The Oracle base for ORACLE_HOME =/u01/APP/11.2.0/grid is/u01/APP/Oracle
[Oracle @ linux117 ~] $ Sqlplus/As sysdba

SQL * Plus: Release 11.2.0.1.0 production on Thu Aug 30 10:56:33 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Automatic Storage Management Option

SQL> select status from V $ instance;

Status
------------
Started
SQL> alter diskgroup data add disk 'orcl: vdisk2 ';
Alter diskgroup data add disk 'orcl: vdisk2'
*
Error at line 1:
ORA-15032: not all alterations saved med
ORA-15260: Permission denied on ASM disk group

SQL> shutdown immediate;
ORA-01031: insufficient privileges

 

SQL> select * from V $ asm_diskgroup;

1 Data 512 4096
1048576 mounted extern 511993 6 0
511987 0 6 0
11.2.0.0.0
10.1.0.0.0 n

SQL> select path from V $ asm_disk;

Orcl: vdisk2
Orcl: vdisk1
[Oracle @ linux117 ~] $ Su-grid
[Grid @ linux117 ~] $ ID
Uid = 1100 (GRID) gid = 1000 (oinstall) groups = 1000 (oinstall), 1100 (asmadmin), 1200 (DBA), 1300 (asmdba), 1301 (asmoper)

SQL> Conn/As sysasm
Connected.

SQL> alter diskgroup data add disk 'orcl: vdisk2 ';

Diskgroup altered.

SQL>
--------------------------------------------------------------------------------
Udid
----------------------------------------------------------------
Product create_da mount_dat repair_timer reads
------------------------------------------------------------------------
Writes read_errs write_errs read_time write_time bytes_read bytes_written
-------------------------------------------------------------------------
P hash_value hot_reads hot_writes hot_bytes_read hot_bytes_written cold_reads
------------------------------------------------------------------------
Cold_writes cold_bytes_read cold_bytes_written v sector_size failgro
---------------------------------------------------------------

SQL> set head off
SQL>/

0 0 0 3915934782 closed candidate online
Normal unknown
ASM library-generic Linux, version 2.0.4 (kabi_v2) 221183
0 0 0 0
Vdisk2
Orcl: vdisk2

0

0
N 512 regular

1 0 16777216 3915934781 cached Member Online

Normal unknown
ASM library-generic Linux, version 2.0.4 (kabi_v2) 511993
511993 6 0 511987 vdisk1
Vdisk1 vdisk1
Orcl: vdisk1

16-apr-12 28-aug-12 0 384822
224042 0 0 875.256 1803.663 2.7934e + 10 2725892096
3076181572 0 0 0 381455
134792 2.7920e + 10 2360324096 n 512 regular

SQL> alter diskgroup data add disk 'orcl: vdisk2 ';
SQL> exit
[Oracle @ linux117 ~] $ Asmcmd
Asmcmd> lsdg
State type rebal sector block au total_mb free_mb req_mir_free_mb usable_file_mb offline_disks voting_files name
Mounted extern n 512 4096 1048576 733176 0 56444 0 n data/

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.