Add a disk to ASM diskgroup.

Add a disk to ASM diskgroup.

分类： ORACLE11G 2011-06-16 16:02 124人阅读 评论(0) 举报

# format
Searching for disks...done

 

AVAILABLE DISK SELECTIONS:
0. c1t0d0

1. c1t1d0

2. c2t201700A0B84863FEd31

3. c2t202700A0B84863FEd31

4. c3t201600A0B84863FEd31

5. c3t202600A0B84863FEd31

6. c4t600A0B8000485F3800000EB74DE279D2d0 cl_files

7. c4t600A0B8000485F3800000EB84DE27A3Cd0 oraredo1

8. c4t600A0B8000485F3800000EC94DE281C0d0 oradata1

9. c4t600A0B8000485F3800000ECB4DE28688d0 ora_arch

10. c4t600A0B80004863FE00000EA24DE275A6d0 oraredo2

11. c4t600A0B80004863FE00000EA44DE27928d0 oraredo3

12. c4t600A0B80004863FE00000EB04DE280AAd0 oradata2

13. c4t600A0B80004863FE00000EB84DE280E2d0 oradata3

14. c4t600A0B80004863FE00000EBA4DE28635d0 orabckup

Specify disk (enter its number):
Specify disk (enter its number):
Specify disk (enter its number): 8
selecting c4t600A0B8000485F3800000EC94DE281C0d0: oradata1
[disk formatted]

 

FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show vendor, product and revision
volname - set 8-character volume name
! - execute , then return
quit
format> partition

 

PARTITION MENU:
0 - change `0' partition
1 - change `1' partition
2 - change `2' partition
3 - change `3' partition
4 - change `4' partition
5 - change `5' partition
6 - change `6' partition
7 - change `7' partition
select - select a predefined table
modify - modify a predefined partition table
name - name the current table
print - display the current table
label - write partition map and label to the disk
! - execute , then return
quit
partition> 4
Part Tag Flag Cylinders Size Blocks
4 unassigned wm 0 0 (0/0/0) 0

Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]: 3
Enter partition size[0b, 0c, 3e, 0.00mb, 0.00gb]: 199gb
partition> l
Ready to label disk, continue? y

partition> q

 

FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show vendor, product and revision
volname - set 8-character volume name
! - execute , then return
quit
format> q
On Both nodes:
# chown grid:oinstall /dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6
# chmod 666 /dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6
# ls -lL /dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6
crw-rw-rw- 1 grid oinstall 118, 70 Jun 16 06:12 /dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6
# ls -l /dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6
lrwxrwxrwx 1 root root 67 May 30 00:28 /dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6 -> ../../devices/scsi_vhci/ssd@g600a0b8000485f3800000ec94de281c0:g,raw

SQL> conn / as sysasm
Connected.

SQL> ALTER DISKGROUP DATA5 ADD DISK '/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6' SIZE 204760M;
ALTER DISKGROUP DATA5 ADD DISK '/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6' SIZE 204760M
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15033: disk '/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6' belongs to
diskgroup "DATA5"

SQL> select disk_number, name, path, state from v$asm_disk
2 where path = '/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6';

DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
STATE
--------
2
/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6
NORMAL

SQL> !
$ dd if=/dev/zero of=/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6 bs=4096 count=1
1+0 records in
1+0 records out
$ exit
SQL> ALTER DISKGROUP DATA5 ADD DISK '/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6' SIZE 204760M;

Diskgroup altered.

SQL> select disk_number, name, path, state from v$asm_disk;

DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
STATE
--------
0
/dev/rdsk/c1t0d0s5
NORMAL

1
/dev/rdsk/c4t600A0B80004863FE00000EBA4DE28635d0s6
NORMAL

DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
STATE
--------

0 DATA5_0000
/dev/rdsk/c4t600A0B8000485F3800000ECB4DE28688d0s6
NORMAL

3 DATA5_0003
/dev/rdsk/c4t600A0B8000485F3800000EC94DE281C0d0s6

DISK_NUMBER NAME
----------- ------------------------------
PATH
--------------------------------------------------------------------------------
STATE
--------
NORMAL