solaris10_oracle10g_asm_ora_27094
-bash-3.00$ su - root
Password:
make love with you
You have mail.
-bash: export: `/usr/bin/bash': not a valid identifier
-bash-3.00# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0d0
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c0d1
/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0
2. c1d1
/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0
3. c2t0d0
/pci@0,0/pci1000,30@10/sd@0,0
Specify disk (enter its number): 2
selecting c1d1
Controller working list found
[disk formatted, defect list found]
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
! - execute , then return
quit
format> ver
Primary label contents:
Volume name =
ascii name =
pcyl = 2558
ncyl = 2556
acyl = 2
bcyl = 0
nhead = 128
nsect = 32
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
format> ver
Primary label contents:
Volume name =
ascii name =
pcyl = 2558
ncyl = 2556
acyl = 2
bcyl = 0
nhead = 128
nsect = 32
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
format> h
Expecting one of the following: (abbreviations ok):
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
! - execute , then return
quit
format> p
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> 3
Part Tag Flag Cylinders Size Blocks
3 unassigned wm 0 0 (0/0/0) 0
Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]:
Enter partition size[0b, 0c, 0e, 0.00mb, 0.00gb]: 1gb
partition> ver
`ver' is not expected.
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
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]:
Enter partition size[0b, 0c, 0e, 0.00mb, 0.00gb]: 1gb
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> h
Expecting one of the following: (abbreviations ok):
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> label
Ready to label disk, continue? y
partition> ver
`ver' is not expected.
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> h
Expecting one of the following: (abbreviations ok):
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> 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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
! - execute , then return
quit
format> q
-bash-3.00# chown ora10g:oinstall /dev/rdsk/c1d1s3
-bash-3.00# chown ora10g:oinstall /dev/rdsk/c1d1s3 /dev/rdsk/c1d1s4
-bash-3.00# chmod 775 /dev/rdsk/c1d1s[34]
-bash-3.00# ls -l /dev/rdsk/c1d1s3
lrwxrwxrwx 1 root root 54 8月 23 06:07 /dev/rdsk/c1d1s3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0:d,raw
-bash-3.00# ls -l /devices/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0:d,raw
crwxrwxr-x 1 ora10g oinstall 102, 131 11月 26 09:49 /devices/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0:d,raw
-bash-3.00# exit
logout
-bash-3.00$ echo ID
ID
-bash-3.00$ env|grep SID
ORACLE_SID=+ASM
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 26 09:52:01 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create diskgroup dg_1 failgroup fg1
2 disk '/dev/rdsk/c1d1s3' name fg1_d1 size 100m
3 failgroup fg2
4 disk '/dev/rdsk/c1d1s4' name fg2_d1 size 100m;
create diskgroup dg_1 failgroup fg1
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rdsk/c1d1s4' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s4'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
ORA-15031: disk specification '/dev/rdsk/c1d1s3' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA, ARCH, DG8
asm_diskstring string
asm_power_limit integer 1
SQL> create diskgroup dg_1 failgroup fg1
2 disk '/dev/rdsk/c1d1s3' name fg1_d1
3 failgroup fg2
4 disk '/dev/rdsk/c1d1s4' name fg2_d1;
create diskgroup dg_1 failgroup fg1
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rdsk/c1d1s4' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s4'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
ORA-15031: disk specification '/dev/rdsk/c1d1s3' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
SQL> alter system set asm_diskstring='/dev/rdsk/c1d1s[34]';
alter system set asm_diskstring='/dev/rdsk/c1d1s[34]'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-15014: location '/dev/rdsk/c0d1s1' is not in the discovery set
ORA-15025: could not open disk '/dev/rdsk/c1d1s4'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497556: Unknown system error
Additional information: 134497504
Additional information: -792500864
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497556: Unknown system error
Additional information: 134497504
Additional information: -792500864
SQL> alter system set asm_diskstring='/dev/rdsk/c1d1s3';----這個分割槽直接從sector0開始,不能用於儲存資料檔案(因為儲存raw device的vtoc資訊)
alter system set asm_diskstring='/dev/rdsk/c1d1s3'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-15014: location '/dev/rdsk/c0d1s1' is not in the discovery set
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497556: Unknown system error
Additional information: 134497504
Additional information: -792500864
-bash-3.00$ oerr ora 27094
27094, 00000, "raw volume used can damage partition table"
// *Cause: A raw device with VTOC information was provided as a database file.
// *Action: Make sure the disk partition that is provided to Oracle
// does not start at sector 0
-bash-3.00$ exit
logout
-bash-3.00# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0d0
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c0d1
/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0
2. c1d1
/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0
3. c2t0d0
/pci@0,0/pci1000,30@10/sd@0,0
Specify disk (enter its number): 2
selecting c1d1
Controller working list found
[disk formatted, defect list found]
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
! - execute , then return
quit
format> p
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> ver
`ver' is not expected.
partition> p
Current partition table (original):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> 3 ----修改指定的分割槽
Part Tag Flag Cylinders Size Blocks
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]: 113 --不從cyl0開始,指定一個大於cyl0的cylinder開始
Enter partition size[2097152b, 512c, 624e, 1024.00mb, 1.00gb]: 1gb
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 113 - 624 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> 4
Part Tag Flag Cylinders Size Blocks
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]: 625
Enter partition size[2097152b, 512c, 1136e, 1024.00mb, 1.00gb]: 1gb
partition> h
Expecting one of the following: (abbreviations ok):
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> label
Ready to label disk, continue? y
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 113 - 624 1024.00MB (512/0/0) 2097152
4 unassigned wm 625 - 1136 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
! - execute , then return
quit
format> q
-bash-3.00# exit
logout
Password:
make love with you
You have mail.
-bash: export: `/usr/bin/bash': not a valid identifier
-bash-3.00# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0d0
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c0d1
/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0
2. c1d1
/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0
3. c2t0d0
/pci@0,0/pci1000,30@10/sd@0,0
Specify disk (enter its number): 2
selecting c1d1
Controller working list found
[disk formatted, defect list found]
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
!
quit
format> ver
Primary label contents:
Volume name =
ascii name =
pcyl = 2558
ncyl = 2556
acyl = 2
bcyl = 0
nhead = 128
nsect = 32
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
format> ver
Primary label contents:
Volume name =
ascii name =
pcyl = 2558
ncyl = 2556
acyl = 2
bcyl = 0
nhead = 128
nsect = 32
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
format> h
Expecting one of the following: (abbreviations ok):
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
!
quit
format> p
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
!
quit
partition> 3
Part Tag Flag Cylinders Size Blocks
3 unassigned wm 0 0 (0/0/0) 0
Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]:
Enter partition size[0b, 0c, 0e, 0.00mb, 0.00gb]: 1gb
partition> ver
`ver' is not expected.
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
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]:
Enter partition size[0b, 0c, 0e, 0.00mb, 0.00gb]: 1gb
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> h
Expecting one of the following: (abbreviations ok):
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
!
quit
partition> label
Ready to label disk, continue? y
partition> ver
`ver' is not expected.
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> h
Expecting one of the following: (abbreviations ok):
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
!
quit
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
!
quit
format> q
-bash-3.00# chown ora10g:oinstall /dev/rdsk/c1d1s3
-bash-3.00# chown ora10g:oinstall /dev/rdsk/c1d1s3 /dev/rdsk/c1d1s4
-bash-3.00# chmod 775 /dev/rdsk/c1d1s[34]
-bash-3.00# ls -l /dev/rdsk/c1d1s3
lrwxrwxrwx 1 root root 54 8月 23 06:07 /dev/rdsk/c1d1s3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0:d,raw
-bash-3.00# ls -l /devices/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0:d,raw
crwxrwxr-x 1 ora10g oinstall 102, 131 11月 26 09:49 /devices/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0:d,raw
-bash-3.00# exit
logout
-bash-3.00$ echo ID
ID
-bash-3.00$ env|grep SID
ORACLE_SID=+ASM
-bash-3.00$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 26 09:52:01 2009
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> create diskgroup dg_1 failgroup fg1
2 disk '/dev/rdsk/c1d1s3' name fg1_d1 size 100m
3 failgroup fg2
4 disk '/dev/rdsk/c1d1s4' name fg2_d1 size 100m;
create diskgroup dg_1 failgroup fg1
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rdsk/c1d1s4' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s4'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
ORA-15031: disk specification '/dev/rdsk/c1d1s3' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string DATA, ARCH, DG8
asm_diskstring string
asm_power_limit integer 1
SQL> create diskgroup dg_1 failgroup fg1
2 disk '/dev/rdsk/c1d1s3' name fg1_d1
3 failgroup fg2
4 disk '/dev/rdsk/c1d1s4' name fg2_d1;
create diskgroup dg_1 failgroup fg1
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/rdsk/c1d1s4' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s4'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
ORA-15031: disk specification '/dev/rdsk/c1d1s3' matches no disks
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497940: Unknown system error
Additional information: 134497888
Additional information: -792500864
SQL> alter system set asm_diskstring='/dev/rdsk/c1d1s[34]';
alter system set asm_diskstring='/dev/rdsk/c1d1s[34]'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-15014: location '/dev/rdsk/c0d1s1' is not in the discovery set
ORA-15025: could not open disk '/dev/rdsk/c1d1s4'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497556: Unknown system error
Additional information: 134497504
Additional information: -792500864
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497556: Unknown system error
Additional information: 134497504
Additional information: -792500864
SQL> alter system set asm_diskstring='/dev/rdsk/c1d1s3';----這個分割槽直接從sector0開始,不能用於儲存資料檔案(因為儲存raw device的vtoc資訊)
alter system set asm_diskstring='/dev/rdsk/c1d1s3'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-15014: location '/dev/rdsk/c0d1s1' is not in the discovery set
ORA-15025: could not open disk '/dev/rdsk/c1d1s3'
ORA-27094: raw volume used can damage partition table
Intel SVR4 UNIX Error: 134497556: Unknown system error
Additional information: 134497504
Additional information: -792500864
-bash-3.00$ oerr ora 27094
27094, 00000, "raw volume used can damage partition table"
// *Cause: A raw device with VTOC information was provided as a database file.
// *Action: Make sure the disk partition that is provided to Oracle
// does not start at sector 0
-bash-3.00$ exit
logout
-bash-3.00# format
Searching for disks...done
AVAILABLE DISK SELECTIONS:
0. c0d0
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c0d1
/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0
2. c1d1
/pci@0,0/pci-ide@7,1/ide@1/cmdk@1,0
3. c2t0d0
/pci@0,0/pci1000,30@10/sd@0,0
Specify disk (enter its number): 2
selecting c1d1
Controller working list found
[disk formatted, defect list found]
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
!
quit
format> p
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
!
quit
partition> ver
`ver' is not expected.
partition> p
Current partition table (original):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> 3 ----修改指定的分割槽
Part Tag Flag Cylinders Size Blocks
3 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]: 113 --不從cyl0開始,指定一個大於cyl0的cylinder開始
Enter partition size[2097152b, 512c, 624e, 1024.00mb, 1.00gb]: 1gb
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 113 - 624 1024.00MB (512/0/0) 2097152
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
partition> 4
Part Tag Flag Cylinders Size Blocks
4 unassigned wm 0 - 511 1024.00MB (512/0/0) 2097152
Enter partition id tag[unassigned]:
Enter partition permission flags[wm]:
Enter new starting cyl[0]: 625
Enter partition size[2097152b, 512c, 1136e, 1024.00mb, 1.00gb]: 1gb
partition> h
Expecting one of the following: (abbreviations ok):
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
!
quit
partition> label
Ready to label disk, continue? y
partition> p
Current partition table (unnamed):
Total disk cylinders available: 2556 + 2 (reserved cylinders)
Part Tag Flag Cylinders Size Blocks
0 unassigned wm 3 - 57 110.00MB (55/0/0) 225280
1 unassigned wm 58 - 112 110.00MB (55/0/0) 225280
2 backup wu 0 - 2555 4.99GB (2556/0/0) 10469376
3 unassigned wm 113 - 624 1024.00MB (512/0/0) 2097152
4 unassigned wm 625 - 1136 1024.00MB (512/0/0) 2097152
5 unassigned wm 0 0 (0/0/0) 0
6 unassigned wm 0 0 (0/0/0) 0
7 unassigned wm 0 0 (0/0/0) 0
8 boot wu 0 - 0 2.00MB (1/0/0) 4096
9 alternates wm 1 - 2 4.00MB (2/0/0) 8192
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
fdisk - run the fdisk program
repair - repair a defective sector
show - translate a disk address
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
volname - set 8-character volume name
!
quit
format> q
-bash-3.00# exit
logout
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9240380/viewspace-620580/，如需轉載，請註明出處，否則將追究法律責任。