在linux下sybase15.7匯入資料，執行load database、online database后在window下用PB連接庫能看到資料已經匯入。但是當把sybase服務重啟后再次連接進去發現匯入進去的資料就沒有了，這個什么問題呢？
下邊是匯入資料
1> load database frame from '/tmp/frame20170214.dmp'
2> go
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 'frame170450E7B8 ' section number 1
mounted on disk file '/tmp/frame20170214.dmp'
The dump header contains unknown token 10 within the DBDEVINFO field. The LOAD
command will ignore the token and proceed.
The dump header contains unknown token 10 within the DBDEVINFO field. The LOAD
command will ignore the token and proceed.
Backup Server: 4.188.1.1: Database frame: 87690 kilobytes (1%) LOADED.
此處省略....................................................
Backup Server: 4.188.1.1: Database frame: 6291792 kilobytes (100%) LOADED.
Backup Server: 3.42.1.1: LOAD is complete (database frame).
Started estimating recovery log boundaries for database 'frame'.
Database 'frame', checkpoint=(2808534, 2), first=(2808534, 2), last=(2808541,
2).
Completed estimating recovery log boundaries for database 'frame'.
Started ANALYSIS pass for database 'frame'.
Completed ANALYSIS pass for database 'frame'.
Started REDO pass for database 'frame'. The total number of log records to
process is 102.
Redo pass of recovery has processed 15 committed and 0 aborted transactions.
Completed REDO pass for database 'frame'.
Use the ONLINE DATABASE command to bring this database online; ASE will not
bring it online automatically.
1> online database frame
2> go
Started estimating recovery log boundaries for database 'frame'.
Database 'frame', checkpoint=(2808534, 2), first=(2808534, 2), last=(2808541,
2).
Completed estimating recovery log boundaries for database 'frame'.
Started ANALYSIS pass for database 'frame'.
Completed ANALYSIS pass for database 'frame'.
Recovery of database 'frame' will undo incomplete nested top actions.
Database 'frame' appears to be at an older version '15700' than the present
installation at version '15700'; ASE will assess it, and upgrade it as required.
Database 'frame': beginning upgrade step [ID 2]: validate basic system type data
Database 'frame': beginning upgrade step [ID 75]: executing SQL statement
("update syscolumns set type=66, user...")
(0 rows affected)
Database 'frame': beginning upgrade step [ID 9]: executing SQL statement
("if exists (select 1 from syscolumns...")
Database 'frame': beginning upgrade step [ID 69]: executing SQL statement
("if 2 = (select count(name) from sys...")
(0 rows affected)
Database 'frame': beginning upgrade step [ID 74]: executing SQL statement
("update syscolumns set type=66, user...")
(0 rows affected)
(1 row affected)
(0 rows affected)
Database 'frame': beginning upgrade step [ID 91]: executing SQL statement
("update systypes set length=@@maxpag...")
(0 rows affected)
Database 'frame': beginning upgrade step [ID 245]: Update system roles in
system tables.
(0 rows affected)
Database 'frame': beginning upgrade step [ID 246]: clear unused columns (table sysindexes)
Database 'frame': beginning upgrade step [ID 248]: update system catalog protection data
Database 'frame': beginning upgrade step [ID 1105]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1132]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1299]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1400]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1502]: executing SQL statement
("if exists (select 1 from sysobjects...")
Database 'frame': beginning upgrade step [ID 1503]: executing SQL statement
("create view sysquerymetrics (uid, g...")
Database 'frame': beginning upgrade step [ID 73]: executing SQL statement
("update sysobjects set sysstat = sys...")
(0 rows affected)
Database 'frame': beginning upgrade step [ID 1550]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1702]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1719]: executing SQL statement
("update sysattributes set object_inf...")
(0 rows affected)
Database 'frame': beginning upgrade step [ID 1720]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1730]: noting the present database
upgrade level
Database 'frame': beginning upgrade step [ID 1740]: noting the present database
upgrade level
Upgrade has finished in database 'frame'. ASE is now updating table level
statistics for its system tables. Please be patient.
Database 'frame' is now online.
1>
uj5u.com熱心網友回復：
有沒有大神來幫幫啊uj5u.com熱心網友回復：
把你的linux平臺上sybase的錯誤日志檔案最近啟動的日志帖上來。我懷疑資料庫被設定成啟動時自動恢復了。
uj5u.com熱心網友回復：
1、是不是執行完sql沒有commit，然后系統給rollback了？2、會不會系統給自動恢復了？
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/22999.html
標籤：數據庫相關
上一篇：求PB 列印預覽模塊