Tag Archives: data guard

ORA-600(kssadd: null parent)错误

Posted on 2012/10/29 by yangtingkun

Oracle 11.1.0.6数据库在归档到远端实例时出现这个错误。 详细错误信息为： Wed DEC 26 12:39:20 2012 Error 1017 received logging ON TO the standby ———————————————————— CHECK that the PRIMARY AND standby are USING a password file AND remote_login_passwordfile IS SET TO SHARED OR EXCLUSIVE, AND that the SYS … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

ORA-600(3689)错误

Posted on 2012/10/20 by yangtingkun

这是一个10.2.0.1到10.2.0.4上都存在的bug。 错误发生在DG的STANDBY数据库中： Fri Oct 19 12:01:16 2012 Errors IN file /DATA/oracle/admin/vodapp/bdump/vodapp_mrp0_21304.trc: ORA-00600: internal error code, arguments: [3689], [33], [], [], [], [], [], [] Errors WITH log /baceldba/archive/1_30374_730819916.dbf MRP0: Background Media Recovery TERMINATED WITH error 600Fri Oct 19 12:01:16 2012 … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

STANDBY数据库出ORA-1009错误

Posted on 2012/09/10 by yangtingkun

在10.2.0.4 DATA GUARD的STANDBY数据库中，出现了大量的ORA-1009错误。 错误信息为： Thu May 31 14:11:16 2012 FAL[client, MRP0]: Error 1009 fetching archived redo log FROM orcl Thu May 31 14:11:16 2012 Errors IN file /opt/app/oradir/admin/orcl_st/bdump/orcl_st_mrp0_23866.trc: ORA-01009: missing mandatory parameter Thu May 31 14:11:46 2012 FAL[client, MRP0]: Error … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment

RMAN-600(8201)错误的重现

Posted on 2012/04/04 by yangtingkun

前两天，客户的数据库在执行CATALOG方式的备份时出现了RMAN-600(8201)错误。由于比较了解客户的环境，在加上客户本身对于系统的了解，使得成功的模拟出这个错误。 RMAN-600(8201)错误：https://yangtingkun.net/?p=690 其实重现这个错误并不算太复杂，要求数据库的版本是10.2.0.3以下。 首先搭建一套DATA GUARD环境。然后在备库启用数据库的FLASHBACK功能，创建一个恢复点，然后将备库激活打开。备库打开后就可以关闭，然后重新MOUNT数据库，并利用FLASHBACK将数据库回滚到激活之前的恢复点，然后利用ALTER DATABASE CONVERT命令再次将这个数据库转化为物理备库，DATA GUARD环境恢复后，使备库应用日志一直到和主库保持一致，然后进行一次DATA GUARD的SWITCHOVER的操作，使得备库变成主库，主库变成备库。 这时，对新的主库创建CATALOG，执行REGISTER DATABASE后，执行show all命令，就会重新错误。 [orat1@hpserver2 ~]$ rman target / catalog rcat_user/rcat_password Recovery Manager: Release 10.2.0.3.0 – Production ON Sat Apr 4 20:51:56 2012 Copyright (c) 1982, 2005, Oracle. ALL rights reserved. connected … Continue reading →

Posted in BUG | Tagged , , , , , , , , , , , , | Leave a comment

ORA-7445(krslvna)错误

Posted on 2012/02/16 by yangtingkun

告警日志中出现ORA-7445[krslvna]错误，随后导致数据库的崩溃。 错误信息为： Thu Sep 8 04:12:07 2011 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Interface TYPE 1 lan900 192.168.11.0 configured FROM OCR FOR USE AS a cluster interconnect Interface TYPE 1 lan901 10.142.132.0 configured FROM OCR FOR … Continue reading →

Posted in BUG | Tagged , , , | Leave a comment

FAL_SERVER设置错误导致SWITCHOVER切换HANG住

Posted on 2011/10/25 by yangtingkun

客户在进行DATA GUARD的SWITCHOVER时，操作长时间没有反应。 操作如下： SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN; 这个命令等待很长时间没有结束，虽然数据库的SWITCHOVER_STATUS并非TO STANDBY而是SESSION ACTIVE，但是几乎所有的LOCAL=NO的连接已经在操作系统级kill掉了，而且使用了WITH SESSION SHUTDOWN语法，理论上不应该是连接问题导致SWITCHOVER无法完成。 检查告警日志： Fri Oct 14 23:03:45 2011 ALTER DATABASE COMMIT … Continue reading →

Posted in ORACLE | Tagged , , , | Leave a comment

DATA GUARD出现ORA-16032错误

Posted on 2011/10/24 by yangtingkun

客户在配置DATA GUARD过程中碰到ORA-1031和ORA-16032错误。 其中ORA-1031错误很直观，直接报错在归档时没有权限： Wed Sep 28 15:43:26 2011 ALTER SYSTEM SET log_archive_dest_2=’service=db1st lgwr async valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=db1st’ SCOPE=BOTH; Wed Sep 28 15:43:26 2011 ALTER SYSTEM SET log_archive_dest_state_1=’enable’ SCOPE=BOTH; Wed Sep 28 15:43:26 2011 ALTER SYSTEM SET log_archive_dest_state_2=’enable’ SCOPE=BOTH; Wed Sep 28 … Continue reading →

Posted in ORACLE | Tagged , , , , , | Leave a comment

DATA GUARD出现ORA-26040错误

Posted on 2011/10/23 by yangtingkun

客户在搭建好的DATA GUARD环境出现了ORA-26040错误。 在备库只读打开时，出现了下面的错误： ORA-12801: error signaled IN parallel query server P000 ORA-01578: ORACLE DATA block corrupted (file # 75, block # 1046445) ORA-01110: DATA file 75: ‘/oradata2/accdb/a_txn_data09.dbf’ ORA-26040: DATA block was loaded USING the NOLOGGING OPTION ORA-12801: error signaled IN … Continue reading →

Posted in ORACLE | Tagged , , , , | Leave a comment

ORA-600(4415)错误

Posted on 2011/09/16 by yangtingkun

客户的11.2的DATA GUARD数据库出现了这个错误。 一般DATA GUARD数据库出现错误的可能性不大，而ORA-600错误的可能性就更小了，而且一旦出现，多半意味着DATA GUARD环境损坏，轻则需要恢复，重则需要重建。 不过这个错误并没有那么大危害： Fri Sep 16 17:57:13 2011 Errors IN file /u01/app/oracle/diag/rdbms/ora190/ora190/trace/ora190_ora_18743334.trc (incident=288185): ORA-00600: 内部错误代码, 参数: [4415], [], [], [], [], [], [], [], [], [], [], [] Incident details IN: /u01/app/oracle/diag/rdbms/ora190/ora190/incident/incdir_288185/ora190_ora_18743334_i288185.trc USE ADRCI OR Support Workbench … Continue reading →

Posted in BUG | Tagged , , , , , | Leave a comment