- 论坛徽章:
- 0
|
小弟我在裸设备上建了个两个设备,并在上面建了库.但是在重起一次SERVER后,就报错了,数据库没法打开了.使用online也没法.大体上报错就是说设备没有启动.
以下是我的一些命令结果,请大家看一下.操作系统是SOLARIS9,SERVER是SYBASE12.5.1.
/dev/dsk/c1t1d0s2 这是我建的裸设备的路径 c1t1d0s2是逻辑设备名,PA是在设备上的库名
1> sp_helpdevice c1t1d0s2
2> go
device_name physical_name
description
status cntrltype device_number
low
high
------------------------------ ----------------------------------------------
c1t1d0s2 /dev/dsk/c1t1d0s2
special, dsync off, physical disk, 6144.00 MB
2 0 6
Device 'c1t1d0s2'has not been correctly activated at startup time.
1> sp_helpdb PA
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
------------------------------------------------------------------------------------------------------
PA 2600.0 MB sa 5
Jul 06, 2005
offline
(1 row affected)
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ----------------
c1t1d0s2 2000.0 MB data only
Jul 6 2005 10:54AM 2038806
c1t2d0s2 600.0 MB log only
Jul 6 2005 10:54AM not applicable
Msg 840, Level 17, State 2:
Server 'V8804', Procedure 'sp_helpdb', Line 580:
Device 'c1t1d0s2' (with physical name '/dev/dsk/c1t1d0s2', and virtual device
number 6) has not been correctly activated at startup time. Please contact a
user with System Administrator (SA) role.
下面是在/var/adm/messages下找的操作系统的ERRORLOG
Dec 12 21:31:33 v880-4 scsi: [ID 107833 kern.warning] WARNING: /pci@8,600000/SUNW,qlc@2/fp@0,0/ssd@w500000e010737361,0 (ssd0):
Dec 12 21:31:33 v880-4 Corrupt label; wrong magic number
Dec 12 21:31:33 v880-4 scsi: [ID 107833 kern.warning] WARNING: /pci@8,600000/SUNW,qlc@2/fp@0,0/ssd@w500000e010737361,0 (ssd0):
Dec 12 21:31:33 v880-4 Corrupt label; wrong magic number
下面是SYBASE的ERRORLOG
00:00000:00014:2005/12/12 11:52:58.78 kernel basis_dsizecheck: attempt to open device '/dev/dsk/c1t1d0s2' failed, system error is: I/O error
00:00000:00014:2005/12/12 11:52:58.78 kernel dresize: Cannot resize /dev/dsk/c1t1d0s2. I/O error.
以上是我觉得有用的资料,要是大家觉得还需要什么命令的结果,请提出来.不胜感激 |
|