标签云
asm恢复 bbed bootstrap$ dul kcbzib_kcrsds_1 kccpb_sanity_check_2 kcratr_nab_less_than_odr MySQL恢复 obet ORA-00312 ORA-00704 ORA-00742 ORA-01110 ORA-01200 ORA-01555 ORA-01578 ORA-01595 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-600 kcratr_nab_less_than_odr ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 ORACLE恢复 Oracle 恢复 ORACLE数据库恢复 oracle碎片 OSD-04016 YOUR FILES ARE ENCRYPTED 比特币加密文章分类
- MongoDB (1)
- MongoDB恢复 (1)
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (112)
- 数据库 (1,885)
- DB2 (22)
- MySQL (82)
- Oracle (1,710)
- Data Guard (53)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (168)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (73)
- Oracle Bug (8)
- Oracle RAC (56)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (29)
- Oracle备份恢复 (663)
- Oracle安装升级 (108)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (91)
- PostgreSQL (37)
- pdu工具 (7)
- PostgreSQL恢复 (13)
- SQL Server (34)
- SQL Server恢复 (14)
- TimesTen (7)
- 达梦数据库 (5)
- 达梦恢复 (3)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (51)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (34)
- MongoDB (1)
-
最近发表
- 恢复案例分享:win丢失数据文件恢复
- 记录19c ASM磁盘掉线触发ORA-59048故障处理
- aix平台Oracle数据库由于断电无法启动故障处理
- 断电引起ORA-600 3005故障处理
- 记录一次云存储资源到期之后引起的数据库恢复
- Firebird 损坏数据库数据抢救工具—firebirdext
- Oracle 19c 202610补丁(RUs+OJVM)-19.33
- 由于con$.con#值达到极限,触发数据库增加约束报ORA-600 12807错误
- MongoDB 离线提取工具—mongoext
- .bres勒索病毒加密数据库dmp文件可恢复
- ORA-600 krsm_mrp_rebuild_lf_list.lno_mismatch
- 记录一次0丢失的ORA-00354: 损坏重做日志块标头故障恢复
- 不当数据库恢复操作导致一个月数据丢失
- obet快速修复oracle 位图损坏块
- 不太常见的10.2.0.1的oracle redo损坏恢复
- obet forcecopy功能抢救硬件故障中的数据文件
- kcratr_nab_less_than_odr和system坏块故障处理
- 通过obet 恢复system坏块,打开数据库
- obet dbv功能完整说明
- 分享一例运行在aix上的sap系统数据库恢复过程
分类目录归档:ORA-xxxxx
ORA-30013导致RAC 节点down掉
今天一朋友让我帮忙分析他们的9.2.0.2 rac 节点2异常down掉原因,相关信息如下:
前提信息
OS:HP-UX B.11.31 DB:9.2.0.2.0 RAC
节点2alert日志信息
Fri Sep 7 13:13:49 2012 ARC0: Completed archiving log 11 thread 2 sequence 11651 Fri Sep 7 13:31:56 2012 Errors in file /oracle/admin/agent/udump/agent2_ora_797.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00028: your session has been killed Fri Sep 7 13:31:58 2012 Errors in file /oracle/admin/agent/bdump/agent2_pmon_5938.trc: ORA-30013: undo tablespace 'UNDOTBS1' is currently in use Fri Sep 7 13:31:58 2012 PMON: terminating instance due to error 30013 Fri Sep 7 13:31:58 2012 Errors in file /oracle/admin/agent/bdump/agent2_lms7_6033.trc: ORA-30013: undo tablespace '' is currently in use Fri Sep 7 13:31:58 2012 ………… Errors in file /oracle/admin/agent/bdump/agent2_lms0_6027.trc: ORA-30013: undo tablespace '' is currently in use Fri Sep 7 13:31:58 2012 System state dump is made for local instance Fri Sep 7 13:32:03 2012 Instance terminated by PMON, pid = 5938 Fri Sep 7 14:34:35 2012
这里可以看到因为ORA-30013的错误使得pmon进程异常,从而使得该rac的节点2 down掉.同时这里还发现了ORA-00600[kgavsd_3]错误,是否是因为该ORA-600导致了数据库异常down还是一个偶然机会,我们继续分析
查看ORA-600[kgavsd_3]相关trace文件
*********START PLSQL RUNTIME DUMP************
***Got ORA-28 while running PLSQL***
***********END PLSQL RUNTIME DUMP************
*** 2012-09-07 13:31:56.740
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], []
ORA-00028: your session has been killed
Current SQL statement for this session:
--用户补档
DECLARE
OUT_ERR_CODE NUMBER;
OUT_ERR_MSG VARCHAR2(1000);
V_COUNT NUMBER;
BEGIN
WHILE TRUE LOOP
SELECT COUNT(*) INTO V_COUNT FROM amc_stat_log where proc_name in('pRunOdsChannelWareData')
and run_param=201208 AND STATE='A';
IF V_COUNT>0 THEN
dbms_output.put_line('exit loop '|| sysdate);
EXIT;
END IF;
sys.Dbms_Lock.sleep(600);
dbms_output.put_line('wake up '|| sysdate);
END LOOP;
PKG_AME_ODS_DATA.P_Add_TO_AgentServ(201208,OUT_ERR_CODE,OUT_ERR_MSG);
PKG_AME_ODS_DATA.P_Update_Serv_Ware_ID(201208, OUT_ERR_CODE, OUT_ERR_MSG);
PKG_AMS_SETTLE.P_COMMISION_51PRE_FLAG(201208,OUT_ERR_CODE, OUT_ERR_MSG);
END;
----- PL/SQL Call Stack -----
object line object
handle number name
c000000e84ec59d0 14 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
Cannot find symbol in .
Cannot find symbol in .
Cannot find symbol in .
ksedmp()+512 call 9fffffffffff3940 000000000 ?
C000000000000A17 ?
40000000025B6540 ?
ksfdmp()+64 call 9fffffffffff3940 000000003 ?
kgerinv()+352 call 9fffffffffff3940 60000000000466B0 ?
000000003 ?
C000000000000714 ?
4000000004EBA6A0 ?
00001821B ?
6000000000468EA8 ?
kgesinv()+48 call 9fffffffffff3940 60000000000466B0 ?
600000000059BD98 ?
600000000046B070 ?
60000000000179C0 ?
6000000000017950 ?
kgesin()+112 call 9fffffffffff3940 60000000000466B0 ?
600000000059BD98 ?
4000000000B44C10 ?
000000001 ?
9FFFFFFFFFFF4310 ?
$cold_kgavsd_stackl call 9fffffffffff3940 60000000000466B0 ?
et_done()+1184 600000000059BD98 ?
4000000000B44C10 ?
000000001 ? 000000000 ?
000000000 ? 000000000 ?
00001FE19 ?
pbesd_stacklet_done call 9fffffffffff3940 60000000000466B0 ?
()+96 000000002 ? 000000000 ?
9FFFFFFFBEC6AE68 ?
pfrrun()+3328 call 9fffffffffff3940 9FFFFFFFBEC6AE68 ?
C000000000001D42 ?
4000000001ABBDA0 ?
9FFFFFFFBEC6B06C ?
9FFFFFFFFFFF64F0 ?
6000000000468EA8 ?
000000000 ? 000000000 ?
peicnt()+480 call 0000000000000000 9FFFFFFFBEC6AEE8 ?
C000000000000996 ?
40000000019F3680 ?
kkxexe()+816 call 0000000000000000 9FFFFFFFFFFF64F0 ?
9FFFFFFFBEC6AE68 ?
C00000000000099B ?
4000000001DD90F0 ?
00000FE4F ?
9FFFFFFFFFFF5F00 ?
60000000000467F0 ?
4000000000B603F0 ?
opiexe()+11168 call 0000000000000000 000000000 ?
C000000000002C60 ?
4000000001BEF980 ?
00000800F ?
9FFFFFFFFFFF6470 ?
9FFFFFFFBEC6AEB2 ?
6000000000040900 ?
9FFFFFFFBEC6B534 ?
opiall0()+3184 call _etext_f()+23058430 000000004 ? 0000000C4 ?
09110686928 9FFFFFFFFFFF7B40 ?
C000000000002BDF ?
4000000001B26CD0 ?
000000000 ? 00000C893 ?
9FFFFFFFFFFF6690 ?
Cannot find symbol in .
kpoal8()+2064 call 9fffffffffff7ad0 000000001 ?
9FFFFFFFFFFF8304 ?
FFFFFFFFBFFFFFFF ?
9FFFFFFFFFFF83E4 ?
FFFFFFFFFFE7FBDF ?
9FFFFFFFFFFF7B88 ?
000000000 ?
6000000000474528 ?
opiodr()+3584 call 9fffffffffff81fc 6000000000040950 ?
000000000 ? 000000000 ?
C000000000002C60 ?
4000000001C09FE0 ?
00000C50B ?
9FFFFFFFFFFF81F0 ?
9FFFFFFFFFFF81D8 ?
ttcpip()+3776 call _etext_f()+23058430 00000005E ? 000000014 ?
09114957288 9FFFFFFFFFFFA5F0 ?
6000000000040918 ?
C000000000001ABD ?
4000000001AB3BA0 ?
000000000 ? 00000C59B ?
opitsk()+1872 call 9fffffffffffa200 6000000000049FC0 ?
000000001 ?
9FFFFFFFFFFFA5F0 ?
000000001 ?
9FFFFFFFFFFFA740 ?
9FFFFFFFFFFFA564 ?
9FFFFFFFBF780058 ?
000000000 ?
opiino()+3184 call 000000000000057b 000000000 ? 000000000 ?
C00000000000132B ?
4000000001F78730 ?
000008001 ?
opiodr()+3584 call 0000000000000000 6000000000548A38 ?
4000000000B606F0 ?
6000000000548A38 ?
C000000000002C60 ?
4000000001C09FE0 ?
00000A201 ?
9FFFFFFFFFFFBC90 ?
4000000000B606F0 ?
opidrv()+976 call _etext_f()+23058430 00000003C ? 000000004 ?
09114957288 9FFFFFFFFFFFEFB0 ?
6000000000040918 ?
sou2o()+80 call _etext_f()+23058430 000000004 ? 000000004 ?
09114957288 9FFFFFFFFFFFEFB0 ?
main()+352 call _etext_f()+23058430 9FFFFFFFFFFFEFD0 ?
09114957288 9FFFFFFFFFFFEFD4 ?
60000000004744F0 ?
9FFFFFFFFFFFEFB0 ?
main_opd_entry()+80 call _etext_f()+23058430 000000000 ?
09114957288 9FFFFFFFFFFFF498 ?
C000000000000004 ?
C00000000002BE30 ?
--------------------- Binary Stack Dump ---------------------
Process global information:
process: c000000d6428c0c0, call: c000000e46e772a8, xact: 0000000000000000,
curses: c000000d6437d020, usrses: c000000d6437d020
----------------------------------------
SO: c000000d6428c0c0, type: 2, owner: 0000000000000000, flag: INIT/-/-/0x00
(process) Oracle pid=282, calls cur/top: c000000e46e772a8/c000000e46e772a8, flag: (0) -
int error: 28, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: c000000d64234f18 1 6
last post sent: 0 0 104
last post sent-location: kglpsl: in loop
last process posted by me: c000000d6428e900 23 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: c000000d62234ee0
O/S info: user: oracle, term: UNKNOWN, ospid: 797
OSD pid info: Unix process pid: 797, image: oracle@gzagent2 (TNS V1-V3)
----------------------------------------
SO: c000000d6437d020, type: 4, owner: c000000d6428c0c0, flag: INIT/-/-/0x00
(session) trans: 0000000000000000, creator: c000000d6428c0c0, flag: (41) USR/- BSY/-/-/-/KIL/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0000000000000000
oct: 0, prv: 0, sql: c000000e76b03f10, psql: 0000000000000000, user: 31/CUSTOM
O/S info: user: huangqianhai_lc, term: SVCTAG-D1MLV2X, ospid: 11124:11796, machine: WORKGROUP\SVCTAG-D1MLV2X
program: plsqldev.exe
application name: PL/SQL Developer, hash value=1190136663
action name: 测试窗口 - 新建, hash value=3604520210
last wait for 'null event' blocking sess=0x0 seq=142 wait_time=567341620
=ea60, =0, =0
temporary object counter: 0
----------------------------------------
通过这里可以看出来是因为pl/sql dev进行一个plsql的操作导致该错误发生,查询MOS[ID 403575.1]发现
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.7 and later [Release: 9.2 and later ] Information in this document applies to any platform. ***Checked for relevance on 27-Oct-2010*** Symptoms The following errors appears in the alert log file : Probe:read_pipe: receive failed, status 3 Probe:S:debug_loop: timeout. Action 1 *********START PLSQL RUNTIME DUMP************ ***Got ORA-604 while running PLSQL*** ***********END PLSQL RUNTIME DUMP************ ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 2 Current SQL statement for this session: begin :id := sys.dbms_transaction.local_transaction_id; end; . Cause The ora-600 kgavsd_3 appears when calling kgavsd_stacklet_done function which is related to PLSQL DEBUG. From traces, dbms_debug package is being used during trace generation. The return code of 3 further indicates that the dbms_pipe message was interrupted. Probably user cancelled a plsql program, so the appeared while trying to dump the stack Solution There is no data corruption over here. The error appears to be due to abnormal termination of aPL/SQL Developer application while executing a PL/SQL block. Changing the PL/SQL and/or the procedure code could help in avoiding this error message. Hence, this error can be safely ignored.
查找trace文件确实发现有name=SYS.DBMS_DEBUG,进一步表明该错误是由于plsql dev工具使用debug模式运行上面的plsql而引起该错误的发生,但是因为mos中记录和错误不是完全的一致,所以不能十分确定是该错误导致数据库down掉
继续分析ORA-30013
Error: ORA-30013 (ORA-30013) Text: undo tablespace '%s' is currently in use --------------------------------------------------------------------------- Cause: the specified undo tablespace is currently used by another instance. Action: Wait for the undo tablespace to become available or change to another name and reissue the statement.
这个说明是没有疑问的:因为2节点配置的当前undo是UNDOTBS2,而UNDOTBS1是1节点使用的,证明这里的undo确实发生了错误,继续查询mos发现Bug 3368552
Hdr: 3368552 9.2.0.3 RDBMS 9.2.0.3 RAC PRODID-5 PORTID-23 Abstract: RAC: ORA-30013 WHEN INSTANCE 2 ATTEMPTS TO ACCESS UNDO TABLESPACE OF INSTANCE 1 *** 01/12/04 06:21 am *** TAR: ---- 3554549.995 PROBLEM: -------- The RAC database has been stable, but experienced an instance termination due to ORA-30031 error in the alert log (instance 2): ... Tue Dec 23 03:01:46 2003 ARC1: Evaluating archive log 4 thread 2 sequence 1116 ARC1: Beginning to archive log 4 thread 2 sequence 1116 Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/oradata/VLDB/logs/archives/VLDBN2/VLDB_0000001116_0002.arc' ARC1: Completed archiving log 4 thread 2 sequence 1116 Tue Dec 23 08:14:09 2003 Errors in file /oracle/admin/VLDB/bdump/vldbn2_pmon_22860.trc: ORA-30013: undo tablespace 'UNDOTBS1' is currently in use Tue Dec 23 08:14:09 2003 PMON: terminating instance due to error 30013 Tue Dec 23 08:14:10 2003 System state dump is made for local instance Tue Dec 23 08:14:12 2003 Trace dumping is performing id=[cdmp_20031223081410] Tue Dec 23 08:14:14 2003 Instance terminated by PMON, pid = 22860 <eof> Instance 1 alert log shows only the reconfiguration and the cdump info: .. Tue Dec 23 03:54:13 2003 Errors in file /oracle/admin/VLDB/udump/vldbn1_ora_13564.trc: ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 4 Tue Dec 23 08:14:10 2003 Trace dumping is performing id=[cdmp_20031223081410] Tue Dec 23 08:14:12 2003 Reconfiguration started List of nodes: 0, Global Resource Directory frozen one node partition Communication channels reestablished ...
因为在9.2.0.3的RAC中有着该bug,那么我们可以大胆猜测在9.2.0.2中应该存在该bug,那么结合上面的ORA-00600[kgavsd_3]错误,我们大概还原该事故的全部:
1.节点1 dml操作了程序中报错的plsql中要范围的部分表对象,但是未提交(或者正在执行)
2.节点2 有用户使用pl/sql dev去执行程序中的plsql,因为是debug模式执行,需要UNDOTBS1的块来构建cr,从而使得节点2去访问UNDOTBS1,引发了Bug 3368552 从而使得数据库直接kill掉该plsql dev会话,进而出现ORA-00600[kgavsd_3]错误和pmon进程异常使得节点2 down掉
dbca创建数据库报ORA-00443
今天早上一个朋友和我说他们RAC dbca创建库不成功提示ORA-00443错误,让我帮他们分析下是什么原因导致
提示错误如图

环境状况
OS:LINUX REDHAT x86_64 5.7 kernel:2.6.18-194.el5 memory:100G CPU:ntel(R) Xeon(R) CPU E7- 8837 @ 2.67GHz * 64 ORACLE:10.2.0.4
查看alert日志错误
Wed Sep 5 01:32:33 2012 cluster interconnect IPC version:Oracle UDP/IP (generic) IPC Vendor 1 proto 2 PMON started with pid=2, OS id=17859 DIAG started with pid=7, OS id=17861 PSP0 started with pid=12, OS id=17863 LMON started with pid=17, OS id=17865 LMD0 started with pid=22, OS id=17867 MMAN started with pid=27, OS id=17869 DBW0 started with pid=32, OS id=17871 Wed Sep 5 01:32:33 2012 Errors in file /u01/app/oracle/admin/dtjcdb/bdump/dtjcdb1_ora_17873.trc: ORA-00600: internal error code, arguments: [ksbmoveme4], [], [], [], [], [], [], [] ORA-27300: OS system dependent operation:run on node failed with status: 2 ORA-27301: OS failure message: No such file or directory ORA-27302: failure occurred at: skgpmoveme:1 Wed Sep 5 01:32:34 2012 Trace dumping is performing id=[cdmp_20120905013234] Wed Sep 5 01:32:34 2012 Process DBW1 died, see its trace file USER: terminating instance due to error 443 Instance terminated by USER, pid = 17857
trace文件中内容
*** 2012-09-05 01:32:33.996
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ksbmoveme4], [], [], [], [], [], [], []
ORA-27300: OS system dependent operation:run on node failed with status: 2
ORA-27301: OS failure message: No such file or directory
ORA-27302: failure occurred at: skgpmoveme:1
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+31 call ksedst1() 000000000 ? 000000001 ?
7FFFC4ABA4C0 ? 7FFFC4ABA520 ?
7FFFC4ABA460 ? 000000000 ?
ksedmp()+610 call ksedst() 000000000 ? 000000001 ?
7FFFC4ABA4C0 ? 7FFFC4ABA520 ?
7FFFC4ABA460 ? 000000000 ?
ksfdmp()+21 call ksedmp() 000000003 ? 000000001 ?
7FFFC4ABA4C0 ? 7FFFC4ABA520 ?
7FFFC4ABA460 ? 000000000 ?
kgerinv()+161 call ksfdmp() 000000003 ? 000000001 ?
7FFFC4ABA4C0 ? 7FFFC4ABA520 ?
7FFFC4ABA460 ? 000000000 ?
kgesinv()+33 call kgerinv() 0068966E0 ? 000000000 ?
7FFFC4ABA520 ? 7FFFC4ABA460 ?
000000000 ? 000000000 ?
ksesin()+211 call kgesinv() 0068966E0 ? 000000000 ?
7FFFC4ABA520 ? 7FFFC4ABA460 ?
000000000 ? 000000000 ?
ksbmoveme()+350 call ksesin() 00533D5C8 ? 000000000 ?
006896FA3 ? 000000001 ?
000000001 ? 000000000 ?
ksosp_set_current() call ksbmoveme() 000000001 ? 000000000 ?
+117 006896FA3 ? 000000001 ?
000000001 ? 000000000 ?
kso_init()+161 call ksosp_set_current() 151056D10 ? 000000000 ?
006896FA3 ? 000000001 ?
000000001 ? 000000000 ?
opirip()+523 call kso_init() 151056D10 ? 000000000 ?
006896FA3 ? 000000001 ?
000000001 ? 000000000 ?
opidrv()+582 call opirip() 000000032 ? 000000004 ?
7FFFC4ABC128 ? 000000001 ?
000000001 ? 000000000 ?
sou2o()+114 call opidrv() 000000032 ? 000000004 ?
7FFFC4ABC128 ? 000000001 ?
000000001 ? 000000000 ?
opimai_real()+317 call sou2o() 7FFFC4ABC100 ? 000000032 ?
000000004 ? 7FFFC4ABC128 ?
000000001 ? 000000000 ?
main()+116 call opimai_real() 000000003 ? 7FFFC4ABC190 ?
000000004 ? 7FFFC4ABC128 ?
000000001 ? 000000000 ?
__libc_start_main() call main() 000000003 ? 7FFFC4ABC190 ?
+244 000000004 ? 7FFFC4ABC128 ?
000000001 ? 000000000 ?
_start()+41 call __libc_start_main() 000723088 ? 000000001 ?
7FFFC4ABC2E8 ? 000000000 ?
000000001 ? 000000003 ?
--------------------- Binary Stack Dump ---------------------
通过查询MOS发现[ID 422908.1]有类此的错误提示,但是该提示说是因为系统重新增加了过多CPU导致数据库crashed掉并且出现 ORA-27300 ORA-27301 ORA-27302 错误.在该案例中,起始就是64c,根据经验在win的10.2.0.4中如果cpu超过32c也是在dbcd创建数据库2%的地方hang住,所以怀疑该错误也是由于cpu太多导致.
处理方法
To solve the problem: 1) apply patch:6471079 - or - 2) apply the 10.2.0.5 (when available) - or - 3) upgrade to 11g
朋友打上patch:6471079,dbca正常建库
双机mount数据库出现ORA-00600[kccsbck_first]
一朋友的数据库在做数据库恢复的时候,数据库不能启动到mount状态,检查发现
alert日志错误如下
Mon Aug 27 10:00:18 2012 ALTER DATABASE MOUNT Mon Aug 27 10:00:23 2012 Errors in file /oracle/admin/wf2009/udump/orcl_ora_7042.trc: ORA-00600: internal error code, arguments: [kccsbck_first], [1], [1208656276], [], [], [], [], [] Mon Aug 27 10:00:23 2012 ORA-600 signalled during: ALTER DATABASE MOUNT...
查询mos发现解释
The ORA-600 [kccsbck_first] error occurs when Oracle detects that another instance has this database already mounted. For some reason, Oracle already sees a thread with a heartbeat. This could be the expected behaviour if running OPS. In such a case the parallel_server parameter needs to be set. In cases where Parallel Server is not linked in, this is not the expected behaviour.
在非集群环境中,当该数据库已经在一个节点启动,然后另外一个节点再尝试启动数据库可能出现该错误.
检查环境发现是使用roseha的双机环境,当关闭当前节点的数据库时候,另外一个节点认为oracle down掉了,然后自动在该节点去尝试启动数据库,而当前操作节点去尝试mount数据库的时候发生该错误,因为该数据库的另外一个节点已经mount了.出现这样的情况,和朋友的存储资源的配置也有不合理之处,在接管资源之前,应该先分析和处理存储的挂载情况,而不是不卸载这边,另外一遍直接挂载(也就是存储两边都挂载)
解决办法
这个问题的本质就是因为ha的两边都启动了数据库导致,关闭一边的roseha或者关闭主机就可以了
在做数据库恢复的时候,尽量排查掉其他因素的影响,比如:rac在一个节点上操作,ha关闭双机软件等

加我微信(17813235971)
加我QQ(107644445)

