当前位置：首页 → 问答吧 → 修改sybase数据库物理设备名字的问题

修改sybase数据库物理设备名字的问题

时间：2011-01-28

来源：互联网

在unix下建数据库cwbase16，物理设备的名字写成了“\c:\”

估计是客户在建库的时候把系统默认成了windows，现在在ASE-12_5/install下有“\c:\”开头的文件，导致在dump备份时显示：
Backup Server session id is:  11.  Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 4.30.2.3: Volume validation error: attempt to open
/cwdata/sybase/ASE-12_5/install\c:\cwdata\cwlog16.dat\cwlog16a1.dat returned No
such file or directory.
Backup Server: 4.27.2.1: Volume validation error: attempt to close
/cwdata/sybase/ASE-12_5/install\c:\cwdata\cwlog16.dat\cwlog16a1.dat returned Bad
file number.
Backup Server: 4.27.2.1: Volume validation error: attempt to close
/cwdata/sybase/ASE-12_5/install/c:\cwdata\cwlog16a2.dat returned Bad file
number.
Msg 8009, Level 16, State 1:
Server 'SYBASE', Line 1:
Error encountered by Backup Server.  Please refer to Backup Server messages for
details.

我现在可不可以把这些\c:\开头的物理设备的名字通过命令修改正常了，然后在数据库中通过修改sysdevices文件，重新指向到修改后的物理设备？若可以的话，再做着个操作前需要，数据库还需要做其它设置吗？

求教，谢谢了！

1> sp_helpdb cwbase16
2> go
name                   db_size    owner                   dbid
      created
      status
------------------------ ------------- ------------------------ ------
      --------------
      ------------------------------------------------------------------------------------------------------
cwbase16                   24100.0 MB cwbase16_9999             19
      Jul 09, 2009
      select into/bulkcopy/pllsort, trunc log on chkpt

(1 row affected)
device_fragments             size       usage
      created          free kbytes
------------------------------ ------------- --------------------
      ------------------- ------------------------------
cwdata16                      5000.0 MB    data only
      Jul  9 2009 10:53AM          43354
cwdata16a1                   5000.0 MB    data only
      Nov  2 2009  9:16AM          37370
cwdata16a2                   10000.0 MB data only
      Sep  1 2010  9:02PM       5389420
cwlog16                      2000.0 MB    log only
      Jul  9 2009 10:53AM not applicable
cwlog16a1                   100.0 MB    log only
      Dec 21 2010  3:45PM not applicable
cwlog16a2                   2000.0 MB    log only
      Dec 21 2010  4:01PM not applicable

--------------------------------------------------------------
log only free kbytes = 4181994

1> sp_helpdevice cwlog16a1
2> go
device_name                   physical_name
      description
      status cntrltype device_number
      low
      high
------------------------------ ----------------------------------------------
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      ------ --------- -------------
      --------------------------------------------------------------------------------
      --------------------------------------------------------------------------------
cwlog16a1                   \c:\cwdata\cwlog16.dat\cwlog16a1.dat
      special, dsync off, physical disk, 100.00 MB
            2       0          42
                                                                              704643074
                                                                              704694273

(1 row affected)

$ cd ASE-12_5/install
$ ls
ASE_HA.sh                            c:\cwdata\cwdata10.dat             c:\cwdata\cwlog16.dat
RUN_SYBASE                         c:\cwdata\cwdata15.dat             c:\cwdata\cwlog16a2.dat
RUN_SYBASE_back                      c:\cwdata\cwdata16.dat             c:\cwdata\cwlog16a3.dat
SPR                                  c:\cwdata\cwdata16a1.dat             c:\cwdata\cwlog17.dat
SYBASE.log                         c:\cwdata\cwdata16a2.dat             c:\cwdata\cwlog9.dat
SYBASE_back.log                      c:\cwdata\cwdata17.dat             m_RUN_SYBASE
\c:\cwdata\cwlog16.dat\cwlog16a1.dat  c:\cwdata\cwdata8.dat                setperm_all
\cwdata\cwdata16.dat                c:\cwdata\cwdata9.dat                showserver
\cwdata\cwlog16.dat                c:\cwdata\cwlog10.dat                startserver
auditinit                            c:\cwdata\cwlog15.dat                sybhauser
$

作者: xgene 发布时间: 2011-01-28

是可以这么做的。
需要注意master设备的路径问题，因为修改sysdevices的时候是需要写入到master设备文件中的。

作者: andkylee 发布时间: 2011-01-28

哦
谢谢

作者: xgene 发布时间: 2011-01-28

常规做法还是走disk mirror -> unmirror二波流

作者: Eisen 发布时间: 2011-01-28