![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle Troubleshooting
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
ORA-01578 ORA-01110 坏块解决方法
一个案例,查看跟踪文件发现如下错误信息d:\oracle\product\10.2.0\admin\dbserver\udump\orcl_ora_5888.trcCorrupt block relative dba: 0x09848269 (file 38, block 295529)Bad header found during buffer readData in bad原创 2014-01-03 22:18:55 · 7351 阅读 · 1 评论 -
Oracle11g ORA-609 TNS 12537 TNS 12560
alert_sid.logWed Dec 18 08:25:58 2013***********************************************************************Fatal NI connect error 12537, connecting to: (LOCAL=NO) VERSION INFORMATION: TNS原创 2013-12-20 20:20:02 · 9904 阅读 · 0 评论 -
Extracting Datafile Blocks From ASM
查看数据存放的file#和block#[oracle@db11g ~]$ sqlplus zwcSQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 16 14:02:27 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter password: Conn原创 2014-01-16 13:57:35 · 142 阅读 · 0 评论 -
Oracle Physical DataGuard使用RMAN增量备份修复GAP
当Physical DataGuard主库归档日志丢失,使用RMAN或者OS命令删除了归档日志,并且归档日志未传输到Standby端,这样Standby端会产生GAP,可以将Primary端的归档拷贝到Standby端然后使用register命令注册,例如ALTER DATABASE REGISTER LOGFILE '/arch/ARC0000000068_0839199018.0001',原创 2014-02-17 01:04:57 · 2895 阅读 · 1 评论