VMCD.ORG

Focus on database mail:ylouis83#gmail.com

DGHA,Dataguard自动切换方案

Posted by admin on 15th August 2013

发布对autoswitch over dg脚本DGHA测试,此脚本针对oracle dataguard设计使用共享存储存放redo以及controlfile从而达到了切换数据0丢失。
同时切换以后,original primary database可以无缝加入整个dg集群,从而形成了datagua[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

Physical standby Failover

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:
Posted in Oracle Experience | No Comments »

Recover physical standby database after loss of archive log(2)

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:
Posted in Oracle Experience | No Comments »

Recover physical standby database after loss of archive log

Posted by admin on 20th March 2012

今天报表数据库的备库出现了问题,由于监控脚本出现了问题,主机空间耗尽 而没有及时发出邮件,导致归档无法进行,DB停滞在一个时间点,同时在主库 由于只保留了2天的归档 导致这部分归档没有传输至备库,等我们发现问题时,主库已经删除了归档,备库接近8天gap无法恢复。由于主库超过3个T ,重新用备份恢复一[......]

Read more

Tags:
Posted in Oracle Experience | 2 Comments »

logic standby ORA-01403 故障处理一例 (2)

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:
Posted in Oracle Experience | 3 Comments »

logic standby ORA-01403 故障处理一例

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:
Posted in Oracle Experience | 2 Comments »

记录一次database upgrade 导致physical standby故障

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:
Posted in Oracle Experience | No Comments »

Logic standby delay when query with for update clause

Posted by admin on 11th January 2012

今天遇到一个奇怪的问题,3个logic standby 中有一个delay 查看任何日志都没有发现错误,有一个transaction在apply一个SQL,这条SQL没有任何问题,SQL所涉及到的表也没有任何问题
当时的apply情况如下:

SID USERNAME MACHINE[......]

Read more

Tags:
Posted in Oracle Experience | No Comments »

主表缺少主键导致logic standby delay 一例

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, OracleAll 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;
END3    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:
Posted in Oracle Experience | No Comments »

Physical-standby standbylogfile checksum error

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:
Posted in Oracle Experience | No Comments »