上周数据库服务器异常,重启机器后,数据库可以mount,但alter database open;后就提示ORA-01092: ORACLE 例程终止 强行断开连接。google了很久,多是相同的东西帖来帖去,没有找到问题。我是一oracle入门者,请大家帮忙。不胜感激!!!
解决方案 »
- 这个sql要怎么写啊
- 请高手帮忙!!!删除树型结构的问题
- 如何查询某字段值在那个表
- 不管高手,还是菜鸟,能帮忙就帮我看看
- sql 查找某列连续的几个值是否相同
- oracle的D:\oracle\ora81\sqlplus\demo目录下的例子执行为什么会出错,怎么解决
- 急问:如何求得存放在数据库的时间和SUSDATE之间的差值?(在线等待)!
- 查询当前user下表的记录数
- 如何在ORACLE数据库中建立异构数据库链接,如(SQL SEVER2000,FOXPRO)
- 监听程序当前无法识别连接描述符中请求服务
- OracleOraHome92ClientCache 1067错误
- 关于oracle数据库创建函数问题在线等
Cause: The instance this process was connected to was terminated abnormally, probably via a shutdown abort. This process was forced to disconnect from the instance.
Action: Examine the alert log for more details. When the instance has been restarted, retry action
看下alert.log 日志..
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
这个不好办... 没见过这么大的alert log, 不看log 就不清楚问题..------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
Tue Dec 15 15:35:25 2009
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Tue Dec 15 15:42:02 2009
alter database open
Tue Dec 15 15:42:02 2009
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Tue Dec 15 15:42:02 2009
Started redo scan
Tue Dec 15 15:42:02 2009
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Tue Dec 15 15:42:02 2009
Started redo application at
Thread 1: logseq 4885, block 2, scn 121660276
Tue Dec 15 15:42:02 2009
Recovery of Online Redo Log: Thread 1 Group 3 Seq 4885 Reading mem 0
Mem# 0 errs 0: /opt/oracle/oradata/orcl/redo03.log
Tue Dec 15 15:42:02 2009
Completed redo application
Tue Dec 15 15:42:02 2009
Completed crash recovery at
Thread 1: logseq 4885, block 3, scn 121680278
0 data blocks read, 0 data blocks written, 1 redo blocks read
Tue Dec 15 15:42:03 2009
Thread 1 advanced to log sequence 4886
Thread 1 opened at log sequence 4886
Current log# 1 seq# 4886 mem# 0: /opt/oracle/oradata/orcl/redo01.log
Successful open of redo thread 1
Tue Dec 15 15:42:03 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Dec 15 15:42:03 2009
SMON: enabling cache recovery
Tue Dec 15 15:42:03 2009
Errors in file /opt/oracle/admin/orcl/udump/orcl_ora_6805.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-01502: 索引 'SYS.I_DEPENDENCY1' 或这类索引的分区处于不可用状态
Tue Dec 15 15:42:03 2009
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 6805
ORA-1092 signalled during: alter database open...
Cause: Failure in processing bootstrap data - see accompanying error.
Action: Contact your customer support representative.
V$INSTANCE_RECOVERY.TARGET_MTTR 表明在短时间内MTTR的目标。
V$MTTR_TARGET_ADVICE 显示这个当前MTTR设置的工作量产生的I/O数量和其他I/O。这个视图帮助用户评定这个在优化和恢复之前的平衡。楼主设置下这个参数看看可行? 这个参数就是设置checkpoint 频率的。我的这篇blog 有提到这个参数,不知是不是楼主修改这个参数导致的,不过可以检查下个参数看看.Redo Log 和Checkpoint not complete
http://blog.csdn.net/tianlesoftware/archive/2009/11/30/4908066.aspx------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716