(分享)ASE 12.5恢复遇到 3240错误

njzh24

公司迁移数据库,在源上做dump,在目标上做load.
在load时遇到如下错误

Backup Server session id is:  17.  Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Msg 3240, Level 18, State 2:
Server 's1', Line 1:
Unable to obtain the SQL Server's current working directory.  The SQL Server must have search permission on its current working directory and the name must be shorter than 255 bytes.
Msg 3240, Level 18, State 1:
Server 's1', Line 1:
Unable to obtain the SQL Server's current working directory.  The SQL Server must have search permission on its current working directory and the name must be shorter than 255 bytes.
Msg 103, Level 15, State 13:
Server 's1', Line 1:
The parameter that starts with '' is too long. Maximum length is 255.


日志中错误如下:
06:00000:00553:2013/07/09 03:17:29.58 kernel  Could not get the server current working directory. Possible NFS problem. Future dump/load operations may fail.
06:00000:00553:2013/07/09 03:17:29.58 kernel  getwd: can't open ..
06:00000:00553:2013/07/09 03:17:29.59 kernel  Could not get the server current working directory. Possible NFS problem. Future dump/load operations may fail.
06:00000:00553:2013/07/09 03:17:29.59 kernel  getwd: can't open ..



查阅官方说明,Msg 3240 用户权限有问题.
检查相关权限属主,貌似没问题.
最后umount 文件系统后,发现挂载点 /sybase 目录的属主是root,改成sybase:sybase后重新mount,并再次赋为sybase:sybase  问题解决.