Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › 数据库宕机，在线急救
发新帖
ALLSTARS_ORACLE

999

积分

1

好友

942

主题

[物理/逻辑坏块] 数据库宕机，在线急救

1#
发表于 2017-4-14 17:25:36 | 查看: 2347| 回复: 2
数据库实例突然宕掉，然后startup mount
SQL> startup  
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2085320 bytes
Variable Size            1275072056 bytes
Database Buffers          855638016 bytes
Redo Buffers               14688256 bytes
Database mounted.
一直不会动

看alert_sid.log
Sun Oct  5 17:23:24 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p011_7695.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Starting background process QMNC
QMNC started with pid=32, OS id=7705
Sun Oct  5 17:29:22 2008
Restarting dead background process QMNC
QMNC started with pid=32, OS id=7739


Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:36 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:37 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [4519], [6], [21072487], [204], [], [], [], []
Sun Oct  5 16:17:38 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928052], [3866], [74217479], [46203647], [], []
Sun Oct  5 16:17:40 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928052], [3866], [74217479], [46203647], [], []
Sun Oct  5 16:17:41 2008
Doing block recovery for file 6 block 95506
Block recovery from logseq 3490, block 144200 to scn 5305895325
Sun Oct  5 16:17:41 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3490 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo01.log
Block recovery completed at rba 3490.172038.16, scn 1.1010928030
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18597.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928085], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18599.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928086], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:42 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18593.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928089], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:43 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18601.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928093], [17922], [3271876784], [892220165], [], []
Sun Oct  5 16:17:44 2008
CKPT: terminating instance due to error 472
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18599.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928086], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928096], [45279], [3334780325], [3372071386], [], []
ORA-00472: PMON  process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:47 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18593.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928089], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:47 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18601.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928093], [17922], [3271876784], [892220165], [], []
Sun Oct  5 16:17:48 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928097], [45279], [3334780325], [3372071386], [], []
ORA-00600: internal error code, arguments: [2662], [1], [1010928096], [45279], [3334780325], [3372071386], [], []
ORA-00472: PMON  process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []

这是宕机之前的信息

刚open了，不过立刻就宕掉了
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_7657.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2A975D5
000] [] []

刚open了，不过立刻就宕掉了
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_7657.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgscDump()+438] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [_intel_fast_memcpy.A()+10] [SIGSEGV] [Invalid permissions for mapped object] [0x2A975D5
000] [] []

没有归档，也没有做任何热备份，无奈之下把数据库控制文件、日志文件、数据文件拷贝备份，再测试吧！此库采用导入导出备份，因为考虑数据量小，不太重要，把前天凌晨的数据导进去了，丢了整整一天的数据！我把全部错误等会整理发一下，忘高人指点下
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638  QQ: 47079569     邮箱：service@parnassusdata.com
3#
发表于 2017-4-14 17:26:20
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p011_18322.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p002_18270.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=32, OS id=18354
Sun Oct  5 16:31:49 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p008_18316.trc:
ORA-00600: internal error code, arguments: [2032], [25261327], [25261327], [8192], [6], [1], [1010928025], [908343747]
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p010_18320.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p009_18318.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p006_18280.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p005_18278.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p004_18276.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p007_18314.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p003_18272.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:41:49 2008
Process 0x0xdf3b7020 appears to be hung while dumping
Current time = 914482846, process death time = 914422733 interval = 60000
Attempting to kill process 0x0xdf3b7020 with OS pid = 18322
OSD kill succeeded for process 0xdf3b7020
Doing block recovery for file 6 block 95506
Doing block recovery for file 6 block 95506
Doing block recovery for file 6 block 95506
Block recovery from logseq 3491, block 63 to scn 5305915460
Sun Oct  5 16:41:52 2008
Recovery of Online Redo Log: Thread 1 Group 4 Seq 3491 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo04.log
Sun Oct  5 16:41:52 2008
db_recovery_file_dest_size of 4096 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun Oct  5 16:41:52 2008
Block recovery completed at rba 3491.141.16, scn 1.1010948165
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sun Oct  5 16:41:52 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
Completed: ALTER DATABASE OPEN
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
WARNING: inbound connection timed out (ORA-3136)
Sun Oct  5 16:41:52 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_j000_18536.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010948169], [708], [85471531], [3271834959], [], []
Sun Oct  5 16:41:52 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_mmon_18092.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010948174], [708], [85471531], [3271834959], [], []
Sun Oct  5 16:41:53 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:41:53 2008
DEBUG: Replaying xcb 0xdce3a968, pmd 0xdbf3e0c8 for failed op 8
Reconstructing  Uhdr 0x800029 for xcb 0xdce3a968, pmd 0xdbf3e0c8
Doing block recovery for file 2 block 41
No block recovery was needed
DEBUG: Restoring block headers for xcb 0xdce3a968, pmd 0xdbf3e0c8
Sun Oct  5 16:41:53 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_j000_18536.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010948200], [708], [85471531], [3271834959], [], []
ORA-00600: internal error code, arguments: [2662], [1], [1010948169], [708], [85471531], [3271834959], [], []
Sun Oct  5 16:41:54 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_mmon_18092.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010948210], [708], [85471531], [3271834959], [], []
ORA-00600: internal error code, arguments: [2662], [1], [1010948174], [708], [85471531], [3271834959], [], []
Sun Oct  5 16:41:55 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:41:56 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_smon_18086.trc:
ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghstack_err()+119] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:41:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_pmon_18068.trc:
ORA-00474: SMON process terminated with error
Sun Oct  5 16:41:58 2008
PMON: terminating instance due to error 474
Sun Oct  5 16:41:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_lgwr_18080.trc:
ORA-00474: SMON process terminated with error
Sun Oct  5 16:41:58 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_ckpt_18084.trc:
ORA-00474: SMON process terminated with error
Sun Oct  5 16:42:29 2008
Instance terminated by PMON, pid = 18068

3、再次启动都是无法打开，错误信息类似

回复 只看该作者 道具 举报

2#
发表于 2017-4-14 17:26:03

操作系统：RHEL4_x86_64
ORACLE RDBMS:Oracle 10.2.0.4 x86_64
数据文件采用文件系统存储。

1、数据库实例宕机，查看alert_[sid].log
Sun Oct  5 16:17:33 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:33 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [4519], [6], [21072487], [204], [], [], [], []
Sun Oct  5 16:17:34 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:34 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_j000_18517.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928032], [25507], [25261417], [7340032], [], []
ORA-08103: object no longer exists
Sun Oct  5 16:17:35 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:36 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18008.trc:
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgidmp()+46] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-07445: exception encountered: core dump [kgitrc()+69] [SIGSEGV] [unknown code] [0x000000000] [] []
ORA-00600: internal error code, arguments: [kghstack_free2], [], [], [], [], [], [], []
Sun Oct  5 16:17:37 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [4519], [6], [21072487], [204], [], [], [], []
Sun Oct  5 16:17:38 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928052], [3866], [74217479], [46203647], [], []
Sun Oct  5 16:17:40 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18123.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928052], [3866], [74217479], [46203647], [], []
Sun Oct  5 16:17:41 2008
Doing block recovery for file 6 block 95506
Block recovery from logseq 3490, block 144200 to scn 5305895325
Sun Oct  5 16:17:41 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3490 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo01.log
Block recovery completed at rba 3490.172038.16, scn 1.1010928030
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18597.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928085], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18599.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928086], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:41 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:42 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18593.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928089], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:43 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18601.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928093], [17922], [3271876784], [892220165], [], []
Sun Oct  5 16:17:44 2008
CKPT: terminating instance due to error 472
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18599.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928086], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:46 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928096], [45279], [3334780325], [3372071386], [], []
ORA-00472: PMON  process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:17:47 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18593.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928089], [48585], [2780216774], [353305099], [], []
Sun Oct  5 16:17:47 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18601.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928093], [17922], [3271876784], [892220165], [], []
Sun Oct  5 16:17:48 2008
Errors in file /usr/oracle/admin/blog/udump/blog_ora_18171.trc:
ORA-00600: internal error code, arguments: [2662], [1], [1010928097], [45279], [3334780325], [3372071386], [], []
ORA-00600: internal error code, arguments: [2662], [1], [1010928096], [45279], [3334780325], [3372071386], [], []
ORA-00472: PMON  process terminated with error
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [1010928087], [45279], [3334780325], [3372071386], [], []
Sun Oct  5 16:18:15 2008
Instance terminated by CKPT, pid = 10437
2、手工startup database，mount无法打开，过一会实例又挂了.
alert_sid.log:
ALTER DATABASE   MOUNT
Sun Oct  5 16:31:44 2008
Setting recovery target incarnation to 2
Sun Oct  5 16:31:44 2008
Successful mount of redo thread 1, with mount id 2789094315
Sun Oct  5 16:31:44 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Sun Oct  5 16:31:44 2008
ALTER DATABASE OPEN
Sun Oct  5 16:31:44 2008
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Sun Oct  5 16:31:44 2008
Started redo scan
Sun Oct  5 16:31:44 2008
Completed redo scan
30492 redo blocks read, 1883 data blocks need recovery
Sun Oct  5 16:31:44 2008
Started redo application at
Thread 1: logseq 3490, block 142497
Sun Oct  5 16:31:44 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 3490 Reading mem 0
  Mem# 0: /usr/oracle/oradata/blog/redo01.log
Sun Oct  5 16:31:44 2008
Completed redo application
Sun Oct  5 16:31:45 2008
Completed crash recovery at
Thread 1: logseq 3490, block 172989, scn 5305915380
1883 data blocks read, 1872 data blocks written, 30492 redo blocks read
Sun Oct  5 16:31:45 2008
Thread 1 advanced to log sequence 3491 (thread open)
Thread 1 opened at log sequence 3491
  Current log# 4 seq# 3491 mem# 0: /usr/oracle/oradata/blog/redo04.log
Successful open of redo thread 1
Sun Oct  5 16:31:45 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Oct  5 16:31:45 2008
SMON: enabling cache recovery
Sun Oct  5 16:31:45 2008
Successfully onlined Undo Tablespace 1.
Sun Oct  5 16:31:45 2008
SMON: enabling tx recovery
Sun Oct  5 16:31:45 2008
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 8
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p013_18330.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p015_18340.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p012_18328.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p014_18334.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Sun Oct  5 16:31:45 2008
Errors in file /usr/oracle/admin/blog/bdump/blog_p001_18268.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 15:26 , Processed in 0.049159 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569