Sybase資料庫日誌過大導致不能啟動(轉)
Sybase資料庫日誌過大導致不能啟動(轉)[@more@] 問：有個問題問一下，關於SYBASE的：我開啟資料庫總是提醒：cannot open transaction log file-----cannot use log file "hms2000.log" since it is shorter than experted。我直接刪除了日誌，也不能正常啟動，說找不到檔案。
請問這是怎麼回事啊？附上出錯的日誌記錄：
請問這是怎麼回事啊？附上出錯的日誌記錄：
|
CODE:
I. 10/09 09:58:38. Sybase Adaptive Server Anywhere Network Server Version 7.0.2.1402
I. 10/09 09:58:38. This software contains confidential and trade secret information of I. 10/09 09:58:38. Sybase, Inc. Use, duplication or disclosure of the software and I. 10/09 09:58:38. documentation by the U.S. Government is subject to restrictions set forth I. 10/09 09:58:38. in a license agreement between the Government and Sybase, Inc. or other I. 10/09 09:58:38. written agreement specifying the Government's rights to use the software I. 10/09 09:58:38. and any applicable FAR provisions, for example, FAR 52.227-19. I. 10/09 09:58:38. I. 10/09 09:58:38. Copyright 1989-2000 Sybase, Inc. All rights reserved. I. 10/09 09:58:38. All unpublished rights reserved. I. 10/09 09:58:38. I. 10/09 09:58:38. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA I. 10/09 09:58:38. Networked Seat (per-seat) model. Access to the server is limited to 99 seat(s). I. 10/09 09:58:38. This server is licensed to: I. 10/09 09:58:38. lb I. 10/09 09:58:38. I. 10/09 09:58:38. 10240K of memory used for caching I. 10/09 09:58:38. Minimum cache size: 10240K, maximum cache size: 230848K I. 10/09 09:58:38. Using a maximum page size of 1024 bytes I. 10/09 09:58:38. Starting database "XXXXXXX" (C:Program Filessybase資料伺服器XXXXXXX.db) at Sun Oct 09 2005 09:58 I. 10/09 09:58:38. Database recovery in progress I. 10/09 09:58:38. Last checkpoint at Sat Oct 08 2005 19:15 I. 10/09 09:58:38. Checkpoint log... I. 10/09 09:59:03. Transaction log: XXXXXXX.LOG... E. 10/09 09:59:03. Error: Cannot open transaction log file -- Can't use log file "XXXXXXX.LOG" since it is shorter than expected I. 10/09 09:59:03. Error: Cannot open transaction log file -- Can't use log file "XXXXXXX.LOG" since it is shorter than expected E. 10/09 09:59:03. Cannot open transaction log file -- Can't use log file "XXXXXXX.LOG" since it is shorter than expected I. 10/09 09:59:04. Database server stopped at Sun Oct 09 2005 09:59 I. 10/09 10:58:33. Sybase Adaptive Server Anywhere Network Server Version 7.0.2.1402 I. 10/09 10:58:33. This software contains confidential and trade secret information of I. 10/09 10:58:33. Sybase, Inc. Use, duplication or disclosure of the software and I. 10/09 10:58:33. documentation by the U.S. Government is subject to restrictions set forth I. 10/09 10:58:33. in a license agreement between the Government and Sybase, Inc. or other I. 10/09 10:58:33. written agreement specifying the Government's rights to use the software I. 10/09 10:58:33. and any applicable FAR provisions, for example, FAR 52.227-19. I. 10/09 10:58:33. I. 10/09 10:58:33. Copyright 1989-2000 Sybase, Inc. All rights reserved. I. 10/09 10:58:33. All unpublished rights reserved. I. 10/09 10:58:33. I. 10/09 10:58:33. Sybase, Inc. 6475 Christie Avenue, Emeryville, CA 94608, USA I. 10/09 10:58:33. Networked Seat (per-seat) model. Access to the server is limited to 99 seat(s). I. 10/09 10:58:33. This server is licensed to: I. 10/09 10:58:33. lb I. 10/09 10:58:33. I. 10/09 10:58:33. 10240K of memory used for caching I. 10/09 10:58:33. Minimum cache size: 10240K, maximum cache size: 230848K I. 10/09 10:58:33. Using a maximum page size of 1024 bytes I. 10/09 10:58:33. Starting database "XXXXXXX" (C:Program Filessybase資料伺服器XXXXXXX.db) at Sun Oct 09 2005 10:58 I. 10/09 10:58:33. Database recovery in progress I. 10/09 10:58:33. Last checkpoint at Sat Oct 08 2005 19:15 I. 10/09 10:58:33. Checkpoint log... I. 10/09 10:58:55. Transaction log: XXXXXXX.LOG... E. 10/09 10:58:55. Error: Cannot open transaction log file -- Can't use log file "XXXXXXX.LOG" since it is shorter than expected I. 10/09 10:58:55. Error: Cannot open transaction log file -- Can't use log file "XXXXXXX.LOG" since it is shorter than expected E. 10/09 10:58:55. Cannot open transaction log file -- Can't use log file "XXXXXXX.LOG" since it is shorter than expected I. 10/09 10:58:57. Database server stopped at Sun Oct 09 2005 10:58 來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10617542/viewspace-962187/，如需轉載，請註明出處，否則將追究法律責任。
上一篇：
開源軟體公司護客戶 免法律糾紛擾(轉)
下一篇：
Debian Linux的小提示(轉)
請登入後發表評論
登入
全部評論
北京盛拓優訊資訊科技有限公司. 版權所有 京ICP備16024965號-8 北京市公安局海淀分局網監中心備案編號：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人舉報專區 廣播電視節目製作經營許可證(京) 字第1234號 中國網際網路協會會員 |
相關文章
- oracle SGA設定過大導致資料庫無法啟動Oracle資料庫
- 解決memory_target設定過小導致不能啟動資料庫的問題資料庫
- 一次快速閃回區滿導致資料庫不能啟動的解決過程資料庫
- Oracle監聽日誌過大導致的問題Oracle
- 誤刪重做日誌檔案組導致啟動資料庫報錯ORA-03113資料庫
- 歸檔日誌滿導致的資料庫掛起故障處理【轉載】資料庫
- 歸檔日誌無法歸檔導致資料庫hang住資料庫
- 歸檔日誌滿導致的資料庫掛起故障處理資料庫
- HA異常導致oracle資料庫無法啟動Oracle資料庫
- Flash Recovery Area空間不足導致資料庫不能開啟或hang住資料庫
- ASM磁碟組故障導致資料庫不能起來ASM資料庫
- openGauss資料庫日誌管理指導資料庫
- 刪除redo所有日誌,資料庫無法啟動資料庫
- Oracle sysman.mgmt_jobs導致資料庫自動重啟Oracle資料庫
- 歸檔問題導致的資料庫無法啟動資料庫
- 修改SQLNET.ORA導致資料庫無法啟動SQL資料庫
- Sybase 資料庫啟停指令碼資料庫指令碼
- oracle資料庫啟動過程大揭祕Oracle資料庫
- compatible相容引數不正確導致DG物理備庫不能應用日誌應用日誌
- 突然停電，資料庫不能啟動資料庫
- 5.9 TSM的客戶端（ORACLE資料庫）排程程式不能啟動導致備份不正常客戶端Oracle資料庫
- Sybase資料庫簡介 (轉載)資料庫
- 資料庫日誌減肥。自己試過可以資料庫
- 10.2.0.1監聽子程式導致資料庫不能響應資料庫
- 資料庫啟動過程資料庫
- 開啟關閉oracle資料庫附加日誌Oracle資料庫
- MySQL 5.6因為OOM導致資料庫重啟MySqlOOM資料庫
- memlock過低導致的資料庫效能問題資料庫
- mongoDB因root啟動關閉資料庫導致mongo普通使用者無法啟動MongoDB資料庫
- oracle歸檔日誌滿了，導致無法啟動 ORA-03113Oracle
- 什麼原因造成資料庫不能自動啟動！資料庫
- Win10系統怎麼啟動引導日誌_win10引導日誌啟用教程Win10
- 根據Alert日誌查詢資料庫啟動、關閉時間資料庫
- 資料庫日誌中出現啟動JOB程式的TIMED OUT資訊資料庫
- SPFILE 錯誤導致資料庫無法啟動(ORA-01565)資料庫
- 歸檔日誌滿導致ORA-13516錯誤，awr報表不能自動收集
- Oracle資料庫啟動過程Oracle資料庫
- Sybase資料庫安全資料庫