Posted by admin on 28th June 2012
db1 –liu
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
db2 –yang
SQL> select * from v$archive_gap;
no rows selected
SQL>
第一种情况 正常的failover
phsic[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
Posted by admin on 20th June 2012
Recover physical standby database after loss of archive log(2)
上次写过一篇DG丢失归档后的处理过程，总体来说就是使用增量备份覆盖gap数据从而跳过gap的archivelog 这里再阐述另一种情况
++CoolCode_BL[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
Posted by admin on 20th March 2012
今天报表数据库的备库出现了问题，由于监控脚本出现了问题，主机空间耗尽 而没有及时发出邮件，导致归档无法进行，DB停滞在一个时间点,同时在主库 由于只保留了2天的归档 导致这部分归档没有传输至备库，等我们发现问题时，主库已经删除了归档，备库接近8天gap无法恢复。由于主库超过3个T ，重新用备份恢复一[......]
Read more
Tags: dataguard
Posted in Oracle Experience | 2 Comments »
Posted by admin on 18th March 2012
前几天刚处理了 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" ORA-01403: no data found
set
"PRODUCT_CODE" = '0021244213',
依然是这个老错误，这张表的同步出[......]
Read more
Tags: dataguard
Posted in Oracle Experience | 3 Comments »
Posted by admin on 14th March 2012
昨天的logic standby 事故处理：
夜里12点左右 2台logic standby 全部停止日志apply 查看logic standby 相关进程发现:
1.select spid, type, status from v$logstdby_process no rows[......]
Read more
Tags: dataguard
Posted in Oracle Experience | 2 Comments »
Posted by admin on 9th February 2012
记录一次database upgrade 导致physical standby故障
upgrade from 10.2.0.5->11.2.0.3
单节点的database升级很容易，严格按照手册，修改compatible=10.2.0
参考文档 Complete Checkli[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
Posted by admin on 11th January 2012
今天遇到一个奇怪的问题，3个logic standby 中有一个delay 查看任何日志都没有发现错误，有一个transaction在apply一个SQL，这条SQL没有任何问题，SQL所涉及到的表也没有任何问题
当时的apply情况如下：
SID USERNAME MACHINE[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
Posted by admin on 28th December 2011
table缺少primary key 导致logic standby delay 一例
早上在主库做如下操作：
[oracle@racdg1 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Dec 28 11:23:14 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> DECLARE
2 row_num NUMBER := 0;
BEGIN
FOR c_test IN (SELECT ROWID rid FROM MC_SITE_PRODUCT_PIC t ) LOOP
UPDATE MC_SITE_PRODUCT_PIC t SET t.UPDATE_FLAG = 0 WHERE ROWID = c_test.rid;
row_num := row_num + 1;
IF MOD(row_num,2000) =0 THEN
COMMIT;
dbms_lock.sleep(2);
END IF;
END LOOP;
COMMIT;
END; 3 4 5 6 7 8 9 10 11 12 13
14 /
PL/SQL procedure successfully completed.
SQL>
该表大约有150万行，选择update 2000条 提交一次，导致逻辑备库出现delay
++CoolCod[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
Posted by admin on 23rd December 2011
总结下今天DG碰到的问题，本来一个很简单的问题，被我们复杂化衍生出很多问题。
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production
With the Partit[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
Posted by admin on 16th December 2011
今天新上线的系统物理备库出现以下错误：
[oracle@db-15 ~]$ sqlplus ‘/as sysdba’
SQL*Plus: Release 10.2.0.5.0 – Production on Fri Dec 16 20:37:38 2011
Copyright[......]
Read more
Tags: dataguard
Posted in Oracle Experience | No Comments »
