Tag: dataguard

Physical standby Failover

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

Recover physical standby database after loss of archive log

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

Read more

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

前几天刚处理了 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

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

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