首页
技术基础
备份恢复
SQL优化
诊断案例
BLOG
留言板
服务
生活
网摘
阅读
下载
墨天轮
English
eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com
返回留言簿
回 复 留 言
留言ID:
留言原文:
To
:
老大,请帮忙:
Wed Jun 15 17:32:18 2005
Thread 1 advanced to log sequence 425239
Current log# 1 seq# 425239 mem# 0: /home/oracle/app/oracle/oradata/oracle/redo03.log
Wed Jun 15 17:33:02 2005
Thread 1 advanced to log sequence 425240
Current log# 2 seq# 425240 mem# 0: /home/oracle/app/oracle/oradata/oracle/redo02.log
Wed Jun 15 17:33:58 2005
Thread 1 advanced to log sequence 425241
Current log# 3 seq# 425241 mem# 0: /home/oracle/app/oracle/oradata/oracle/redo01.log
Wed Jun 15 17:42:48 2005
Errors in file /home/oracle/app/oracle/admin/oracle/bdump/snp1_21872.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00472: PMONprocess terminated with error
Wed Jun 15 17:43:54 2005
Errors in file /home/oracle/app/oracle/admin/oracle/bdump/snp0_21870.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00472: PMONprocess terminated with error
Wed Jun 15 17:46:02 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12288.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:05 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12327.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:06 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12328.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:06 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12329.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:07 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12330.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:07 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12331.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:08 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12332.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:08 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12333.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:08 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12334.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:09 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12335.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:09 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12336.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:10 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12337.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:11 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12338.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:46:11 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12339.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:48:45 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12491.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:49:04 2005
Starting ORACLE instance (normal)
Wed Jun 15 17:49:07 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12526.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:49:26 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12625.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:49:35 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12659.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:49:39 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12664.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:49:59 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12698.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:01 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12700.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:02 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12701.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:02 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12702.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:03 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12704.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:03 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12705.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:04 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12708.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:04 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12709.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:05 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12710.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:06 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12711.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:36 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12752.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:41 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12753.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:42 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12754.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:44 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12755.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:44 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12756.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:50:45 2005
Errors in file /home/oracle/app/oracle/admin/oracle/udump/ora_12757.trc:
ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
Wed Jun 15 17:51:00 2005
SNP3: terminating instance due to error 1092
Instance terminated by SNP3, pid = 21876
Wed Jun 15 17:56:38 2005
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.1.
System parameters with non-default values:
processes= 300
sessions = 335
shared_pool_size = 209715200
large_pool_size= 16777216
java_pool_size = 10485760
control_files= /home/oracle/app/oracle/oradata/oracle/control01.ctl, /home/oracle/app/oracle/oradata/oracle/control02.ctl
db_block_buffers = 32000
db_block_size= 8192
compatible = 8.1.0
log_buffer = 10485760
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
rollback_segments= hlr1, hlr2, hlr3, hlr4, hlr5, hlr6, hlr7, hlr8, hlr9, hlr10, hlr11, hlr12, hlr13, hlr14, hlr15
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
distributed_transactions = 10
instance_name= ora8
service_names= oracle
mts_dispatchers= (PROTOCOL=TCP)(SER=MODOSE), (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 131072
sort_area_retained_size= 65536
db_name= oracle
open_cursors = 500
os_authent_prefix=
utl_file_dir = /home2/xf/down, /home2/xf/up
job_queue_processes= 4
job_queue_interval = 60
background_dump_dest = /home/oracle/app/oracle/admin/oracle/bdump
user_dump_dest = /home/oracle/app/oracle/admin/oracle/udump
core_dump_dest = /home/oracle/app/oracle/admin/oracle/cdump
PMON started with pid=2
Load Indicator not supported by OS !
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Jun 15 17:56:38 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jun 15 17:56:39 2005
alter databasemount
Wed Jun 15 17:56:43 2005
Successful mount of redo thread 1, with mount id 1434174107.
Wed Jun 15 17:56:43 2005
Database mounted in Exclusive Mode.
Completed: alter databasemount
Wed Jun 15 17:56:43 2005
alter database open
Beginning crash recovery of 1 threads
Wed Jun 15 17:56:44 2005
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 425240 Reading mem 0
Mem# 0 errs 0: /home/oracle/app/oracle/oradata/oracle/redo02.log
Recovery of Online Redo Log: Thread 1 Group 3 Seq 425241 Reading mem 0
Mem# 0 errs 0: /home/oracle/app/oracle/oradata/oracle/redo01.log
Wed Jun 15 17:56:46 2005
Thread recovery: finish rolling forward thread 1
Thread recovery: 176 data blocks read, 154 data blocks written, 901 redo blocks read
Crash recovery completed successfully
Wed Jun 15 17:56:47 2005
Thread 1 advanced to log sequence 425242
Thread 1 opened at log sequence 425242
Current log# 1 seq# 425242 mem# 0: /home/oracle/app/oracle/oradata/oracle/redo03.log
Successful open of redo thread 1.
Wed Jun 15 17:56:47 2005
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Jun 15 17:56:59 2005
Completed: alter database open
From
:
skytears
2005.06.15 02:38
管理密码:
请输入管理密码, 否则无法回复.
斑竹昵称:
信息图标: ( 随机 )
BB 代码:
字体
宋体
黑体
隶书
楷体
幼圆
Arial
颜色
天蓝
品蓝
蓝色
深蓝
橙色
橙红
深红
红色
砖红
暗红
绿色
灰绿
海绿
粉红
果红
桃红
紫色
紫蓝
棕木
沙褐
土黄
深褐
土绿
灰色
大小
1号
2号
3号
4号
5号
内容:
如果想删除回复, 请点击最下面的删除回复按钮.
[COLOR=blue] 1158不会造成潜在的数据损失,和锁队列有关,你可以检查一下trace文件,看看引发此问题的操作,重新测试看问题是否再次出现?[/COLOR]
删 除 回 复
管理密码:
请输入管理员密码, 只有版主才能删除回复.
Copyright © 2003~2012
eygle.com
All Rights Reserved.
Powered by:
www.eygle.com