前几天刚处理了 logic standby故障，还没缓过神来 , logical standby 又出问题了。 还是那张表，那个错误 不得不让我怀疑 是不是那张表出现了问题。记录一下解决的过程：
2012-03-16 11:45:00 update “PROD_DATA2″[……]
Author: admin
logic standby ORA-01403 故障处理一例
昨天的logic standby 事故处理：
夜里12点左右 2台logic standby 全部停止日志apply 查看logic standby 相关进程发现:
1.select spid, type, status from v$logstdby_process no rows[……]
Create a database link with the new host:port/service syntax
Create a database link with the new host:port/service syntax
Submitted by tanelpoder on Mon, 2012-03-05 15:57
Share
I just noticed that (finall[……]
创建index之前如何确定其大小
昨天看了roger的一篇文章，如何在创建index 之前估算它的大小，这里有一种更简单的方法实现：
主要思路就是采用了dbms_space.create_index_cost这个包
–create a testing table named t
SQL> create tabl[……]
11gR2 RAC Rebootless Node Fencing
Rebootless Node Fencing
In versions before 11.2.0.2 Oracle Clusterware tried to prevent a split-brain with a fast reboot (better: reset) of the[……]
Scripts:sess_uncommited_transactions.sql
This script is monitoring sessions that are not commited :
— |—————————————————————————-|[……]
Cloning an Oracle Home
Cloning an Oracle Home
Cloning an Oracle home involves creating a copy of the Oracle home and then configuring it for a new environment. If[……]
11.2.0.3 datapump got ORA-38500
从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致，tablespace有剩余空间 报错如下：
[oracle@localhost ~]$ impdp \’\/ as sysdba \’ directory=pump dum[……]
Fractured blocks when Rman backup is running
系统alert在主库出现下面错误 OS为linux 5.5
Stopping background process CJQ0
Sat Feb 11 03:41:07 2012
Hex dump of (file 9, block 561424) in trace file /data/[……]
招聘：1号店招聘ORACLE DBA
新的一年到了,DBA TEAM准备扩充一下,主要环境是ORACLE(RAC+单实例+DG)+ MYSQL 后面还要涉及到MYSQL的高可用架构实施,ORACLE方面今年也会有一些架构变更,总体而言今年是很有挑战的一年,希望挑战与激情的同学可以来试一试,同时也欢迎大牛的加入
Location[……]