Tag Archives: data guard

ORA-600(kssadd: null parent)错误

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)错误

这是一个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 600 导致这个错误的原因很简单,在主库执行了ALTER TABLESPACE DROP DATAFILE后,并不会导致DATAFILE的被删除,后随后在增加新的数据文件时,就可能导致备库出现ORA-600[3689]的错误。详细描述可参考文档Bug … Continue reading

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

STANDBY数据库出ORA-1009错误

在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)错误的重现

前两天,客户的数据库在执行CATALOG方式的备份时出现了RMAN-600(8201)错误。由于比较了解客户的环境,在加上客户本身对于系统的了解,使得成功的模拟出这个错误。 RMAN-600(8201)错误:http://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)错误

告警日志中出现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住

客户在进行DATA GUARD的SWITCHOVER时,操作长时间没有反应。 操作如下: 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 TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN Fri Oct 14 … Continue reading

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

DATA GUARD出现ORA-16032错误

客户在配置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错误

客户在搭建好的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)错误

客户的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