头疼sybase

头疼sybase
上班这么几年来,最头疼的只能是处理sybase问题了,sybase12.5版本作为10几年前发布的软件版本,出了问题只能考备份作为恢复的最后手段。 所以备份是否有效,能否正常恢复,在出故障的时候,牵动着我的小心脏,而且在一些情况下,备份并不能完成恢复,头疼。 今天这个问题由于AIX系统异常,HMC里面强制重启后,sybase出现以下问题  Recovering database 'cwbase3'.00:00000:00001:2019/07/03 18:1...

sybase 12.5.0.3 load 的时候timeslice -1501, current process infected

sybase 12.5.0.3 load 的时候timeslice -1501, current process infected
load 恢复数据库时发生问题 Caution: You have set up this database to include space on disk 14 for both data and the transaction log. This can make recovery impossible if that disk fails. Use the ONLINE DATABASE command to bring this database online; SQL Server will not bring it online automatically. The SQL Server is terminating this process.   56:00000:00014:2018/09/2...

遇到oracle bug [kcblasm_1], [103]

遇到oracle bug  [kcblasm_1], [103]
进行到同步余额数据 ACFZJE-> ACFZJE2016 oracle报错ora600 E年结失败!原因:ORA-00600: 内部错误代码, 参数: [kcblasm_1], [103], [], [], [], [], [], [] 查询后发现为oracle bug ,尝试禁用ACFZJE索引,无奈运行到这步时,同步数据是在太慢,决定暂停操作,给数据打补丁。 下载补丁p12419392_10205_AIX64-5L,安装补丁说明进行安装后问题解决。 年结结束的时候发生了一个奇怪的事情,linstener 服...

OS空间根空间满,造成sybase无法启动

OS空间根空间满,造成sybase无法启动
一台运行10多年的sybase服务起不来了,经过分析日志感觉是空间满了,收集空间使用信息后,发现问题正是如此。 00:00000:00000:2016/08/15 14:35:00.93 kernel Use license file /opt/sybase-12.5/SYSAM-1_0/licenses/license.dat. 00:00000:00000:2016/08/15 14:35:00.93 kernel Checked out license ASE_SERVER 00:00000:00000:2016/08/15 14:35:00.93 kernel Adaptive Server Enterprise Edition 00:...

oracle database 11g Snapshot Standby Easier than manual steps in 10.2

oracle database 11g Snapshot Standby Easier than manual steps in 10.2
Snapshot Standby Easier than manual steps in 10.2 inewup-standby-database 10.2 Standby > alter database recover managed standby database cancel; > create restore point before_lt guarantee flashback database; Primary > alter system archive log current; > alter system set log_archive_dest_state_2=defer; Standby > alter database activate standby database; > s...

sybase jconnect SQL Exception and Warning Messages

sybase jconnect SQL Exception and Warning Messages
The following table lists the SQL exception and warning messages that you may encounter when using jConnect. SQL state Message/description/action 010AF SEVERE WARNING: An assertion has failed, please use devclasses todetermine the source of this serious bug. Message = _____. Description: An internal assertion in the jConnect driver has failed. Action: Use the...
Copyright © 2011-2018 零下二十四度Theme By  Ality  京ICP备16007547号   关于本站

用户登录