没有合适的资源?快使用搜索试试~ 我知道了~
SYBASE ASE 故障排除指南
4星 · 超过85%的资源 需积分: 10 10 下载量 29 浏览量
2009-08-03
21:03:18
上传
评论 2
收藏 19.62MB PDF 举报
温馨提示
试读
1290页
sybase常见错误分解,及排除方法,对各个级别的报错信息都有详细的描述,并且有DBCC的使用说明。
资源推荐
资源详情
资源评论
Sybase® Adaptive Server
TM
Enterprise Troubleshooting and
Error Messages Guide
Sybase Adaptive Server Enterprise
11.9.x-12.5
DOCUMENT ID: 39996-01-1250-01
LAST REVISED: May 2002
Copyright © 1989-2002 by Sybase, Inc. All rights reserved.
This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes.
Information in this document is subject to change without notice. The software described herein is furnished under a license agreement,
and it may be used or copied only in accordance with the terms of that agreement.
To order additional documents, U.S. and Canadian customers should call Customer Fulfillment at (800) 685-8225, fax (617) 229-9845.
Customers in other countries with a U.S. license agreement may contact Customer Fulfillment via the above fax number. All other
international customers should contact their Sybase subsidiary or local distributor. Upgrades are provided only at regularly scheduled
software release dates. No part of this publication may be reproduced, transmitted, or translated in any form or by any means, electronic,
mechanical, manual, optical, or otherwise, without the prior written permission of Sybase, Inc.
Sybase, the Sybase logo, AccelaTrade, ADA Workbench, Adaptable Windowing Environment, Adaptive Component Architecture,
Adaptive Server, Adaptive Server Anywhere, Adaptive Server Enterprise, Adaptive Server Enterprise Monitor, Adaptive Server
Enterprise Replication, Adaptive Server Everywhere, Adaptive Server IQ, Adaptive Warehouse, Anywhere Studio, Application
Manager, AppModeler, APT Workbench, APT-Build, APT-Edit, APT-Execute, APT-FORMS, APT-Translator, APT-Library, Backup
Server, BizTracker, ClearConnect, Client-Library, Client Services, Convoy/DM, Copernicus, Data Pipeline, Data Workbench,
DataArchitect, Database Analyzer, DataExpress, DataServer, DataWindow, DB-Library, dbQueue, Developers Workbench, Direct
Connect Anywhere, DirectConnect, Distribution Director, e-ADK, E-Anywhere, e-Biz Integrator, E-Whatever, EC-GATEWAY,
ECMAP, ECRTP, eFulfillment Accelerator, Embedded SQL, EMS, Enterprise Application Studio, Enterprise Client/Server, Enterprise
Connect, Enterprise Data Studio, Enterprise Manager, Enterprise SQL Server Manager, Enterprise Work Architecture, Enterprise Work
Designer, Enterprise Work Modeler, eProcurement Accelerator, EWA, Financial Fusion, Financial Fusion Server, Gateway Manager,
ImpactNow, Industry Warehouse Studio, InfoMaker, Information Anywhere, Information Everywhere, InformationConnect,
InternetBuilder, iScript, JaguarCTS,jConnect for JDBC, MainframeConnect,Maintenance Express, MDI Access Server,MDI Database
Gateway, media.splash, MetaWorks, MySupport, Net-Gateway, Net-Library, New Era of Networks, ObjectConnect, ObjectCycle,
OmniConnect, OmniSQL Access Module, OmniSQL Toolkit, Open Biz, Open Client, Open ClientConnect, Open Client/Server, Open
Client/Server Interfaces, Open Gateway, Open Server, Open ServerConnect, Open Solutions, Optima++, PB-Gen, PC APT Execute, PC
Net Library, Power++, power.stop, PowerAMC, PowerBuilder, PowerBuilder Foundation Class Library, PowerDesigner,
PowerDimensions, PowerDynamo, PowerJ, PowerScript, PowerSite, PowerSocket, Powersoft, PowerStage, PowerStudio, PowerTips,
Powersoft Portfolio, Powersoft Professional, PowerWare Desktop, PowerWare Enterprise, ProcessAnalyst, Rapport, Report Workbench,
Report-Execute, Replication Agent, Replication Driver, Replication Server, Replication Server Manager, Replication Toolkit, Resource
Manager, RW-DisplayLib, S-Designor, SDF, Secure SQL Server, Secure SQL Toolset, Security Guardian, SKILS, smart.partners,
smart.parts, smart.script, SQL Advantage, SQL Anywhere, SQL Anywhere Studio, SQL Code Checker, SQL Debug, SQL Edit, SQL
Edit/TPU, SQL Everywhere, SQL Modeler, SQL Remote, SQL Server, SQL Server Manager, SQL SMART, SQL Toolset, SQL Server/
CFT, SQL Server/DBM, SQL Server SNMP SubAgent, SQL Station, SQLJ, STEP, SupportNow, S.W.I.F.T. Message Format Libraries,
Sybase Central, Sybase Client/Server Interfaces, Sybase Financial Server, Sybase Gateways, Sybase MPP, SybaseSQL Desktop, Sybase
SQL Lifecycle, Sybase SQL Workgroup, Sybase User Workbench, SybaseWare, Syber Financial, SyberAssist, SyBooks, System 10,
System 11, System XI (logo), SystemTools, Tabular Data Stream, TradeForce, Transact-SQL, Translation Toolkit, UNIBOM, Unilib,
Uninull, Unisep, Unistring, URK Runtime Kit for UniCode, Viewer, Visual Components, VisualSpeller, VisualWriter, VQL,
WarehouseArchitect, Warehouse Control Center, Warehouse Studio, Warehouse WORKS, Watcom, Watcom SQL, Watcom SQL Server,
Web Deployment Kit, Web.PB, Web.SQL, WebSights, WebViewer, WorkGroup SQL Server, XA-Library, XA-Server and XP Server are
trademarks of Sybase, Inc. 04/02
Unicode and the Unicode Logo are registered trademarks of Unicode, Inc.
All other company and product names used herein may be trademarks or registered trademarks of their respective companies.
Use, duplication, or disclosure by the government is subject to the restrictions set forth in subparagraph (c)(1)(ii) of DFARS 52.227-
7013 for the DOD and as set forth in FAR 52.227-19(a)-(d) for civilian agencies.
Sybase, Inc., 5000 Hacienda Drive, Dublin, CA 94568.
Contents
iii
About This Book......................................................................................................................... xxi
CHAPTER 1 System Database Recovery ........................................................... 1
Ensuring Recoverability ................................................................... 1
Finding the Appropriate Recovery Scenario..................................... 3
master Database Is Corrupt and Adaptive Server Does Not Start... 4
Valid Dump of the master Database Exists............................... 4
Valid Dump of the master Database Does Not Exist................. 6
master Database Is Corrupt and Adaptive Server Starts ................. 7
Valid Dump of the master Database Exists............................... 7
Valid Dump of the master Database Does Not Exist................. 7
Master Device Is Lost and Valid Dump Exists.................................. 8
Valid Dump with Default Sort Order .......................................... 8
Valid Dump with Non-Default Sort Order ................................ 11
Master Device Is Lost and Valid Dump Does Not Exist ................. 12
The model Database Is Lost or Corrupted ..................................... 13
ASE 12.5.x and Later .............................................................. 13
ASE 12.0.x and Earlier ............................................................ 14
Non-Master Device Containing Pieces of tempdb Is Lost.............. 14
Master Device Is Going Bad .......................................................... 16
Adaptive Server Does Not Start After Altering Configuration......... 17
Manually Rebuilding Adaptive Server with bcp .............................. 17
Checklist.................................................................................. 18
Considerations ........................................................................ 18
Steps for Rebuilding Adaptive Server ..................................... 19
If You Cannot Use bcp or a Dump .......................................... 24
CHAPTER 2 Encyclopedia of Tasks ................................................................. 25
Disaster Recovery Tasks ............................................................... 25
How to Build a New Master Device ......................................... 25
How to Rebuild master Database and Leave Master Device Intact
27
How to Start Adaptive Server in Single-User Mode ................ 33
Contents
iv
How to Run the installmaster and installmodel Scripts ........... 35
How to Load the master Database from Backup..................... 36
How to Restore System Table Information in master Database 36
How to Alter the number of devices Parameter Manually ....... 38
How to Alter tempdb................................................................ 39
How to Alter the model Database............................................ 39
How to Reset Adaptive Server to Its Default Configuration..... 39
How to Set A Default Backup Server Manually in Adaptive Server
40
How to Fix Problems Encountered by Disk Refit..................... 40
Problem 1: Duplicate Keys...................................................... 41
Problem 2: Deleted Database dbid ......................................... 42
Problem 3: Allocation Pages from Deleted Database ............. 42
Problem 4: Incomplete sysusages Entries .............................. 43
Queries to Find Suspect sysusages Entries............................ 43
Avoiding Disaster through Good DBA Practices............................ 44
Online Recovery and Recovery Fault Isolation.............................. 49
Background ............................................................................. 49
Online Recovery Concepts...................................................... 49
Recovery With RFI .................................................................. 51
What To Do When Online Recovery Fails............................... 53
RFI Example............................................................................ 56
How to Manually Change Sort Order or Default Character Set ..... 58
Manual Process....................................................................... 59
How to Load a Sort Order or Additional Character Set ........... 61
How to Change the Sort Order................................................ 62
How to Change the Default Character Set.............................. 62
How to Find a Sort Order File Name....................................... 63
How to Find a Sort Order ID.................................................... 64
How to Find a Character Set ID .............................................. 65
How to View Your Existing Sort Order and Character Sets .... 65
Useful dbcc Commands ................................................................. 66
Standard dbcc Commands...................................................... 66
Other dbcc Commands ........................................................... 66
How to Analyze dbcc checkstorage Faults .................................... 69
Fault Analysis.......................................................................... 70
dbcc checkstorage startup and drop table ............................. 73
Faults Due to sp_placeobject.................................................. 73
Troubleshooting XP Server Issues................................................. 73
Background ............................................................................. 73
Correcting Common XP Server Problems............................... 73
Information to Collect Before Calling Technical Support......... 74
Other Useful Tasks ........................................................................ 75
How to Fix a Corrupted Index on System Tables.................... 75
Contents
v
How to Rescue Data from a Corrupted Table ......................... 78
How to Start Adaptive Server with Trace Flags....................... 80
How to Reload a Suspect User Database............................... 84
How to Drop a Database When drop database Fails.............. 84
How to Fix and Prevent Allocation Errors................................ 85
How to Find an Object Name from a Page Number................ 93
How to Interpret sp_who Output.............................................. 95
Device Administration Issues .................................................. 96
How to Choose Between Raw Partitions and UNIX Files ....... 96
How to Move a Sybase Device or Database With Disk Mirroring
100
How to Gather Information About Read/Write Errors ............ 101
How to Mark a Database “suspect'” ...................................... 103
How to Reset a Database's “suspect” Status........................ 105
How to Find a Device's Virtual Device Number..................... 108
How to Detect and Clear Long-Running Transactions.......... 109
How to Reduce the Size of tempdb....................................... 111
How to Remap All Objects in a Database ............................. 114
How to Prepare for Analyzing an Optimizer Problem............ 116
How to Determine Which Physical Devices a Database is On 125
How to Identify and Fix a Corrupted Table............................ 126
How to Monitor the Error Log ................................................ 127
Checking the Operating System Error Log............................ 131
How to Obtain a CSMD Dump ............................................. 132
CHAPTER 3 Error Message Writeups............................................................. 135
Error Message Severity Levels .................................................... 135
Variables in Error Message Text.................................................. 135
Finding Object Names from Error Message Text......................... 136
How to Determine Your Adaptive Server Version ........................ 136
Field Order in Version String ................................................. 137
Creating Error Messages ............................................................. 138
Reporting Errors........................................................................... 138
Faxing Error Log Fragments ................................................. 140
Reproducing Problems.......................................................... 141
Error Message Writeups .............................................................. 141
Parser Errors................................................................................ 142
Error 102 ............................................................................... 142
Error 107 ............................................................................... 143
Error 195 ............................................................................... 145
Sequencer Errors ......................................................................... 147
Error 207 ............................................................................... 147
Error 208 ............................................................................... 148
Error 213 ............................................................................... 150
剩余1289页未读,继续阅读
资源评论
- haopy882014-06-16不可多得的资料,比较有实战参考!
javalj
- 粉丝: 0
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功