一不小心,又中了 oracle 一个 bug :Bug 12610689 - ohasd is rebooted !
Bug 12610689 - ohasd is rebooted when the runlevel changes from 5 to 3 (Doc ID 12610689.8)
Oracle 11.2.0.4.4 ADG 备库数据文件坏块处理
<div>【 alert 日志报错信息】</div><div>Thu Jul 02 01:53:28 2015</div><div>RFS[3]: Assigned to RFS process 37758</div><div>RFS[3]: Selected log 220 for thread 2 sequence 13279 dbid 2048376234...
Oracle ADG 同城异地容灾,专线传输速度可以达到 100MB/s
<div>Oracle ADG 同城异地容灾,专线传输速度可以达到 100MB/s<br />RMAN duplicate ,2 个通道时的情况。(考虑对业务的影响,只起 2 个通道。)<br /><br /><br />irora01:[/root]#date;sar -n DEV 1 5</div><div>Fri Jul 10 07:04:02 CST 2015</div><di...
fusion-io 卡使用率 100% 导致 Oracle RAC instance crash 问题
<div>该问题根因,初步怀疑是 fusion-io 卡 fireware 、驱动层面的问题。<br /><br />【滨江 4.1 业务点数据库 alert 日志】</div><div><br /></div><div>Fri Jul 10 16:52:59 2015</div><div>Timed out trying to start process PZ98.</div><di...
ORA-16025: contains repeated or conflicting
坑人的中文括号 (ORA-16025: contains repeated or conflicting
ORA-16025: contains repeated or conflicting attributes
<div style="text-align:center;"><span style="font-family:Verdana;font-size:x-small;">ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes</span></div>今天在做Downstream测试时,配置主库的spfile参数时出现了如标题所示的错误,<div></div><div>经过百度搜索发现错了错...
rlwrap安装
rlwrap安装
oracle 9i、10g、11g数据库设置listener密码的方法
oracle 9i、10g、11g数据库设置listener密码的方法
snapshot controlfie 在 RAC + DataGuard 环境下的配置
RMAN creates a copy of the control file for read consistency, this is the snapshot controlfile. Due to the changes made to the controlfile backup mechanism in 11gR2 any instances in the cluster may write to the snapshot controlfile. Therefore, the snapshot controlfile file needs to be visible to all instances.The same happens when a backup of the controlfile is created directly from sqlplus any instance in the cluster may write to the backup controfile file.In 11gR2 onwards, the controlf
Oracle快照控制文件(snapshot control file)
Oracle快照控制文件(snapshot control file)
oracle DBA 核心素质
1,扎实的基础知识2,遇事冷静沉着 <<< 这点,我需要加强3,强大的抗压能力4,好身体
Oracle 11.1 逻辑坏块
系统环境:hp-ux 数据库架构:5 nodes RAC --> 4 nodes RAC ( ADG )数据库版本:11.1.0.7 <<< 这个版本真心的不靠谱。请大家慎用第一个版本!数据量:数据文件大小在 14T 左右数据库中一些表中不时会有逻辑坏块产生(坏块都是在索引上),无法分析确定问题根因,每次都要通过 drop / recrea...
Oracle 12C GDS
Oracle Global Data Services (GDS) implements the Oracle Database service model across a set of replicated databases known as a Global Data Services configuration.A Global Data Services configuration looks like a virtual multi-instance database to database clients. It provides client acces...