恢复master库报错!!!!!急救!!!!!
-bash-3.00$ isql -Usa -P -Sctlinux1> load database master from "/opt/sybase-12.5/bak/master.bak"
2> go
WARNING: In order to LOAD the master database, the SQL Server must run in
single-user mode.If the master database dump uses multiple volumes, you must
execute sp_volchanged on another SQL Server at LOAD time in order to signal
volume changes.
Backup Server session id is:5.Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'master08058006BF ' section number 1
mounted on disk file '/opt/sybase-12.5/bak/master.bak'
Backup Server: 4.58.1.1: Database master: 7756 kilobytes LOADed.
Backup Server: 4.58.1.1: Database master: 24582 kilobytes LOADed.
Backup Server: 4.58.1.1: Database master: 24596 kilobytes LOADed.
Backup Server: 3.42.1.1: LOAD is complete (database master).
00:00000:00005:2008/02/27 06:19:28.26 serverThe transaction log in the database 'master' will use I/O size of 8 Kb.
00:00000:00005:2008/02/27 06:19:28.27 serverConfiguration file '/opt/sybase-12.5/ASE/ctlinux.cfg' has been written and the previous version has been renamed to '/opt/sybase-12.5/ASE/ctlinux.121'.
00:00000:00005:2008/02/27 06:19:28.27 serverThe configuration option 'default sortorder id' has been changed by 'sa' from '50' to '50'.
00:00000:00005:2008/02/27 06:19:28.27 kernelueshutdown: exiting
CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect 自己顶一下! 正常的 可是我恢复回来的库启动之后,自建的test库不能启动!经查看我的test库的设备没有恢复回来!这种情况我应该怎么处理呢?谢谢! CT-LIBRARY error:
ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect
有这个就要注意是不是网络连接问题引起的,你ping一下试一试 你的MASTER库备份是不是太早了,备份时还没有建test库? 绝对有
我在恢复回来的sysdatabases表里都看到了 看sysdevices表,是不是你后来扩容过该库,而备份的master没有呢
页:
[1]