經典錯誤ora-03113數據庫無法開啟 ORA-00470 ORA-07445 ORA-12560

LXM995

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
==============
alert_TJTEST.log

Thu Sep  8 19:32:44 2011
alter database open
Thu Sep  8 19:32:44 2011
Beginning crash recovery of 1 threads
Thu Sep  8 19:32:44 2011
Started redo scan
Thu Sep  8 19:32:44 2011
Completed redo scan
0 redo blocks read, 0 data blocks need recovery
Thu Sep  8 19:32:44 2011
Started recovery at
Thread 1: logseq 2, block 2, scn 1390.3402237586
Thu Sep  8 19:32:44 2011
Recovery of Online Redo Log: Thread 1 Group 6 Seq 2 Reading mem 0
  Mem# 0 errs 0: /u1/TEST/testora/testdata/log06a.dbf
Thu Sep  8 19:32:44 2011
Completed redo application
Thu Sep  8 19:32:44 2011
Ended recovery at
Thread 1: logseq 2, block 2, scn 1390.3402257587
0 data blocks read, 0 data blocks written, 0 redo blocks read
Crash recovery completed successfully
Thu Sep  8 19:32:44 2011
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thu Sep  8 19:32:44 2011
ARCH: Evaluating archive   log 7 thread 1 sequence 1
ARCH: Beginning to archive log 7 thread 1 sequence 1
Creating archive destination LOG_ARCHIVE_DEST_2: 'standy'
ARCH: Error 12560 Creating archive log file to 'standy'
Thu Sep  8 19:32:47 2011
Errors in file

/u1/TEST/testora/testdb/9.2.0/admin/TJTEST_tjdb/udump/tjtest_ora_15355.trc:
ORA-12560: TNS:protocol adapter error
Creating archive destination LOG_ARCHIVE_DEST_1: '/u2/archive/arch_1.arc'
ARCH: Completed archiving  log 7 thread 1 sequence 1
Thu Sep  8 19:32:48 2011
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
  Current log# 7 seq# 3 mem# 0: /u1/TEST/testora/log7a.dbf
Successful open of redo thread 1
Thu Sep  8 19:32:48 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Sep  8 19:32:48 2011
ARC2: Evaluating archive   log 6 thread 1 sequence 2
ARC2: Beginning to archive log 6 thread 1 sequence 2
Creating archive destination LOG_ARCHIVE_DEST_2: 'standy'
Thu Sep  8 19:32:48 2011
Errors in file

/u1/TEST/testora/testdb/9.2.0/admin/TJTEST_tjdb/bdump/tjtest_lgwr_15323.trc:
ORA-07445: exception encountered: core dump [kcrfwcint()+1625] [SIGFPE] [Integer divide

by zero] [0x8288171
] [] []
Thu Sep  8 19:32:48 2011
Errors in file

/u1/TEST/testora/testdb/9.2.0/admin/TJTEST_tjdb/bdump/tjtest_pmon_15319.trc:
ORA-00470: LGWR process terminated with error
Thu Sep  8 19:32:48 2011
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 15319
===================================
tjtest_lgwr_15323.trc
*** SESSION ID3.1) 2011-09-08 19:32:48.018
System archive destination LOG_ARCHIVE_DEST_2 made active; Reopen criteria met
Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero), addr: 0x8288171, PC:

[0x8288171, kcrfwcint(
)+1625]
Registers:
%eax: 0x00000000 %ebx: 0x0aefe854 %ecx: 0x00000000
%edx: 0x00000000 %edi: 0x00000000 %esi: 0x00000000
%esp: 0xbfffe274 %ebp: 0xbfffe4f0 %eip: 0x08288171
%efl: 0x00010246
  kcrfwcint()+1614 (0x8288166) xor %eax,%eax
  kcrfwcint()+1616 (0x828816 jmp 0x8287c02
  kcrfwcint()+1621 (0x828816d) mov %edi,%eax
  kcrfwcint()+1623 (0x828816f) xor %edx,%edx
> kcrfwcint()+1625 (0x8288171) div %ecx,%eax
  kcrfwcint()+1627 (0x8288173) mov %eax,%edi
  kcrfwcint()+1629 (0x8288175) jmp 0x8287b50
  kcrfwcint()+1634 (0x828817a) mov %esi,%esi
  kcrfwcint()+1636 (0x828817c) push %ebp
*** 2011-09-08 19:32:48.139
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kcrfwcint()+1625] [SIGFPE] [Integer divide

by zero] [0x8288171
] [] []
============================
Dump file /u1/TEST/testora/testdb/9.2.0/admin/TJTEST_tjdb/bdump/tjtest_pmon_15319.trc

Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /u1/TEST/testora/testdb/9.2.0
System name:    Linux
Node name:      tjdb.tjpcb.com
Release:        2.6.9-34.ELsmp
Version:        #1 SMP Fri Feb 24 16:54:53 EST 2006
Machine:        i686
Instance name: TJTEST
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 15319, image: oracle@tjdb.tjpcb.com (PMON)

*** 2011-09-08 19:32:48.786
*** SESSION ID1.1) 2011-09-08 19:32:48.785
error 470 detected in background process
ORA-00470: LGWR process terminated with error
=============================
udump/tjtest_ora_15355.trc
*** 2011-09-08 19:32:33.251
Recovery of Online Redo Log: Thread 1 Group 6 Seq 2 Reading mem 0
File 407 (stop scn 5973406779027) completed recovery at checkpoint scn 5973406779027
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2011-09-08 19:32:44.926
KCRA: start recovery claims for 0 data blocks
*** 2011-09-08 19:32:44.926
KCRA: buffers claimed = 0/0, eliminated = 0
*** 2011-09-08 19:32:44.928
Recovery of Online Redo Log: Thread 1 Group 6 Seq 2 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
Error 12560 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'standy'
Error 12560 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'standy'
*** 2011-09-08 19:32:47.979
ARCH: Error 12560 Creating archive log file to 'standy'
*** 2011-09-08 19:32:47.979
kcrrfail: dest:2 err:12560 force:0
ORA-12560: TNS:protocol adapter error