今天报表数据库的备库出现了问题，由于监控脚本出现了问题，主机空间耗尽 而没有及时发出邮件，导致归档无法进行，DB停滞在一个时间点,同时在主库 由于只保留了2天的归档 导致这部分归档没有传输至备库，等我们发现问题时，主库已经删除了归档，备库接近8天gap无法恢复。由于主库超过3个T ，重新用备份恢复一个standby 时间上是不允许的，并且主库上也没有空间存放这么大的备份集，于是采取了增量备份的方法，跳过了这个GAP。下面记录这次恢复过程
查看备库日志发现：
Tue Mar 13 02:45:00 2012
ARC1: Closing local archive d[……]
前几天刚处理了 logic standby故障，还没缓过神来 , logical standby 又出问题了。 还是那张表，那个错误 不得不让我怀疑 是不是那张表出现了问题。记录一下解决的过程：
2012-03-16 11:45:00 update “PROD_DATA2″.”PM_SUPPLIER” ORA-01403: no data found
set
“PRODUCT_CODE” = ‘0021244213’,
2012-03-16 11:44:29 update “PROD_DATA2”.”PM_SUPPLIER”[……]
昨天的logic standby 事故处理：
夜里12点左右 2台logic standby 全部停止日志apply 查看logic standby 相关进程发现:
1.select spid, type, status from v$logstdby_process no rows returns
2.2012-03-12 23:36:16 update “PROD_DATA2″.”PM_SUPPLIER” set xxx…..
ORA-01403: no data found
报出如下错误，这种错误一般是由于standby 端的表数据与[……]
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 (finally) in 11.2 this syntax is supported:
SQL> CREATE DATABASE LINK demo_x2
2 CONNECT TO tanel IDENTIFIED BY password
3 USING ‘exadb03:1521/DEM[……]
昨天看了roger的一篇文章，如何在创建index 之前估算它的大小，这里有一种更简单的方法实现：
主要思路就是采用了dbms_space.create_index_cost这个包
–create a testing table named t
SQL> create table t as select * from dba_objects;
Table created.
SQL> declare
begin
for i in 1..10 loop
insert /*+ APPEND */ into t select * from t;
commit;[……]
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 server(s) without waiting for ongoing I/O operations or synchronization of the file systems. This mechanism has been changed in version 11.2.0.2 (fi[……]
This script is monitoring sessions that are not commited :
— |—————————————————————————-|
— | Copyright (c) 1998-2012 Jeffrey M. Hunter. All rights reserved. |
— |————————————————————–[……]
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 you are performing multiple Oracle Database installations, then you may want to use this method to create each Oracle home, because copying files fro[……]
从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致，tablespace有剩余空间 报错如下：
[oracle@localhost ~]$ impdp \’\/ as sysdba \’ directory=pump dumpfile=so.dmp TABLE_EXISTS_ACTION=append
Import: Release 11.2.0.3.0 – Production on Thu Feb 23 09:44:49 2012
Copyright (c) 1982, 2011, Oracle and[……]
系统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/oracle/diag/rdbms/yhdstd/yhddb1/trace/yhddb1_ora_11327.trc
Corrupt block relative dba: 0x02489110 (file 9, block 561424)
Fractured block found durin[……]