Month: August 2013

Sql Server 2008 简单搭建主从复制

by

通过将主服务器上备份出来的transaction log 传送到辅助服务器上并进行恢复,实现主从库的同步，有些类似mysql 的主从和oracle 的OGG，不过sqlserver 的日志传输当主服务器宕机的时候，日志传送功能并不能实现从主服务器到辅助服务器的自动故障转移功能，需要手动将辅助服务器切换到联机状态，使得辅助服务器上数据库来提供服务，从而实现数据库的高可用性。 Parimary DB ——————– IP: 192.168.217.240 OS: windows 2003 x64 DB: Sql server 2008 ——————– Secondly DB ——————– IP: 192.168.217.240 OS: windows 2003 x32 DB: Sql server 2008 ——————– Transaction Log data flow ————————- primary db –>backup e:\db_backup –> shared e:\db_backup as \\192.168.217.240\db_bacup | |secondly copy \\192.168.217.240\db_bacup to local e:\db_restore … Read more

ORA-07445 [kggchk()+77] [SIGSEGV] [Address not mapped to object]

by

今天有个项目系统负载突然变大，查到top sql是一个存储过程,执行计划缺少合理的索引，SQL是个update操作，于是kill 调用的几个session 建立一个索引，结果发现kill几个用户进程后实例挂了.下面是alert日志，可见instance crash前出现过死锁,就是那个update sql Thu Aug 15 11:08:04 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_24011.trc. Thu Aug 15 11:27:00 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_26527.trc. Thu Aug 15 11:27:03 2013 ORA-00060: Deadlock detected. More info in file /oracle/admin/icme/udump/icme_ora_26912.trc. Thu Aug 15 11:32:46 2013 ORA-00060: Deadlock detected. More info … Read more

Enabling Listener Trace ,TNS-01251

by

Enabling Listener Trace ,TNS-01251 Oracle version 11g introduced the ADR or Automatic Diagnostic Repository feature,Trying to change the log file using the Lsnrctl utility fails with: TNS-01251: Cannot set trace/log directory under ADR. oracle@db231 trace]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 – Production on 15-AUG-2013 14:15:59 Copyright (c) 1991, 2011, Oracle. All rights reserved. … Read more