oracle启动两分钟就down掉了 474: SMON process terminated with error求解

every888 2018-09-09 10:05:30
如题 oracle启动两分钟就自己挂掉了,607和600错误 按照网上的 查询文件609块6 没有查到数据对象,alert_orcl日志如下,求解
Sun Sep 9 17:10:59 2018
Starting ORACLE instance (normal)
sskgpgetexecname failed to get name
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =61
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes = 500
sessions = 555
event = 10513 trace name context forever,level 2
sga_max_size = 18874368000
__shared_pool_size = 738197504
__large_pool_size = 16777216
__java_pool_size = 33554432
__streams_pool_size = 16777216
nls_language = AMERICAN
sga_target = 18874368000
control_files = /u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/oradata/orcl/control02.ctl, /u01/app/oracle/oradata/orcl/control03.ctl
control_file_record_keep_time= 31
db_block_size = 8192
__db_cache_size = 18052284416
compatible = 10.2.0.3.0
log_archive_dest_1 = location=/u01/app/oracle/oradata/orcl/archive
db_files = 2048
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/oradata/flash_recovery_area
db_recovery_file_dest_size= 94266982400
_allow_resetlogs_corruption= TRUE
undo_management = AUTO
undo_tablespace = UNDOS
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = FALSE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
session_cached_cursors = 1000
job_queue_processes = 10
cursor_sharing = FORCE
background_dump_dest = /u01/app/oracle/admin/orcl/bdump
user_dump_dest = /u01/app/oracle/admin/orcl/udump
core_dump_dest = /u01/app/oracle/admin/orcl/cdump
audit_file_dest = /u01/app/oracle/admin/orcl/adump
audit_trail = NONE
db_name = orcl
open_cursors = 1500
pga_aggregate_target = 4951375872
PMON started with pid=2, OS id=42139748
PSP0 started with pid=3, OS id=22020104
MMAN started with pid=4, OS id=13303998
DBW0 started with pid=5, OS id=58458330
DBW1 started with pid=6, OS id=50593826
DBW2 started with pid=7, OS id=29098136
LGWR started with pid=8, OS id=39714858
CKPT started with pid=9, OS id=30736554
SMON started with pid=10, OS id=25034810
RECO started with pid=11, OS id=11075810
CJQ0 started with pid=12, OS id=56950896
MMON started with pid=13, OS id=27721848
Sun Sep 9 17:11:00 2018
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=14, OS id=54526100
Sun Sep 9 17:11:00 2018
starting up 1 shared server(s) ...
Sun Sep 9 17:11:00 2018
ALTER DATABASE MOUNT
Sun Sep 9 17:11:07 2018
Setting recovery target incarnation to 6
Sun Sep 9 17:11:07 2018
Successful mount of redo thread 1, with mount id 1514171175
Sun Sep 9 17:11:07 2018
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sun Sep 9 17:11:07 2018
ALTER DATABASE OPEN
Sun Sep 9 17:11:07 2018
Thread 1 opened at log sequence 74
Current log# 5 seq# 74 mem# 0: /u01/app/oracle/oradata/orcl/redo05.dbf
Successful open of redo thread 1
Sun Sep 9 17:11:07 2018
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun Sep 9 17:11:07 2018
SMON: enabling cache recovery
Sun Sep 9 17:11:09 2018
Successfully onlined Undo Tablespace 17.
Sun Sep 9 17:11:09 2018
SMON: enabling tx recovery
Sun Sep 9 17:11:09 2018
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
where NUMA PG = 1, CPUs = 24
replication_dependency_tracking turned off (no async multimaster replication found)
Sun Sep 9 17:11:09 2018
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_25034810.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], []
Starting background process QMNC
QMNC started with pid=19, OS id=28180686
Sun Sep 9 17:11:10 2018
Completed: ALTER DATABASE OPEN
Sun Sep 9 17:11:10 2018
db_recovery_file_dest_size of 89900 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 Sep 9 17:11:10 2018
Doing block recovery for file 609 block 6
Block recovery from logseq 74, block 34314 to scn 32724092833
Sun Sep 9 17:11:10 2018
Recovery of Online Redo Log: Thread 1 Group 5 Seq 74 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/orcl/redo05.dbf
Block recovery stopped at EOT rba 74.34338.16
Block recovery completed at rba 74.34338.16, scn 7.2659321761
Sun Sep 9 17:11:10 2018
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_25034810.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], []
Sun Sep 9 17:11:11 2018
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_25034810.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], []
Doing block recovery for file 609 block 6
Block recovery from logseq 74, block 34314 to scn 32724092833
Sun Sep 9 17:11:12 2018
Recovery of Online Redo Log: Thread 1 Group 5 Seq 74 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/orcl/redo05.dbf
Block recovery completed at rba 74.34338.16, scn 7.2659321763
Sun Sep 9 17:11:49 2018
Doing block recovery for file 609 block 6
Block recovery from logseq 74, block 34314 to scn 32724092833
Sun Sep 9 17:11:49 2018
Recovery of Online Redo Log: Thread 1 Group 5 Seq 74 Reading mem 0
Mem# 0: /u01/app/oracle/oradata/orcl/redo05.dbf
Block recovery completed at rba 74.34338.16, scn 7.2659321763
Sun Sep 9 17:11:49 2018
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_25034810.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], []
Sun Sep 9 17:11:59 2018
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_smon_25034810.trc:
ORA-00600: internal error code, arguments: [kddummy_blkchk], [609], [6], [18018], [], [], [], []
Sun Sep 9 17:12:03 2018
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_pmon_42139748.trc:
ORA-00474: SMON process terminated with error
Sun Sep 9 17:12:03 2018
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 42139748
...全文
1117 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
Rotel-刘志东 2018-09-25
  • 打赏
  • 举报
回复
引用 2 楼 tianlesoftware 的回复:
引用 1 楼 xifenfei 的回复:
你通过blog link:http://www.xifenfei.com/oracle_recovery_check收集下数据库相关信息,发我html文件,我给你们评估下情况
惜总还有时间泡论坛啊

还在做培训呢
Dave 2018-09-21
  • 打赏
  • 举报
回复
引用 1 楼 xifenfei 的回复:
你通过blog link:http://www.xifenfei.com/oracle_recovery_check收集下数据库相关信息,发我html文件,我给你们评估下情况
惜总还有时间泡论坛啊
惜分飞 2018-09-10
  • 打赏
  • 举报
回复
你通过blog link:http://www.xifenfei.com/oracle_recovery_check收集下数据库相关信息,发我html文件,我给你们评估下情况

3,490

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧