- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 23:03:24
|
查看: 1940 |
回复: 0
XP系统,oracle11g,在导大数据量过程中人为中断后,重启机器,oracleservice启动不了,期间硬盘一直在狂转,根据oracle日志估计是由于中断后需要回滚事务导致IO操作,经过10小时硬盘依然在狂转,想请教如何快速恢复之前正常运行时的数据库,谢谢:)
Mon Jun 11 22:39:26 2012
ARC1 started with pid=24, OS id=5532
Mon Jun 11 22:39:26 2012
ARC2 started with pid=25, OS id=5600
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thread 1 advanced to log sequence 2 (thread open)
Mon Jun 11 22:39:26 2012
ARC3 started with pid=26, OS id=4148
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 2
Current log# 2 seq# 2 mem# 0: G:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 11 22:39:28 2012
SMON: enabling cache recovery
|
|