SMON: Restarting fast_start para…

最新推荐文章于 2023-03-25 21:17:58 发布

babymouse1212

最新推荐文章于 2023-03-25 21:17:58 发布

阅读量914

点赞数

CC 4.0 BY-SA版权

分类专栏：故障处理

本文链接：https://blog.youkuaiyun.com/babymouse1212/article/details/71078830

故障处理专栏收录该内容

103 篇文章

订阅专栏

本文记录了在取消删除操作并物理终止OS进程后进行表截断时遇到的Oracle数据库SMON进程频繁尝试快速启动并行回滚及并行事务恢复的问题。详细描述了错误现象、原因及解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Sat Jul 07 08:50:41 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:55:05 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:55:53 2012
SMON: Parallel transaction recovery tried
Sat Jul 07 08:56:29 2012
SMON: Parallel transaction recovery tried
Sat Jul 07 08:56:44 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:57:04 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:57:35 2012
SMON: Parallel transaction recovery tried
Sat Jul 07 08:57:50 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:58:06 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:59:14 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 08:59:54 2012
SMON: Parallel transaction recovery tried
Sat Jul 07 09:00:29 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:00:45 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:01:23 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:01:59 2012
SMON: Parallel transaction recovery tried
Sat Jul 07 09:02:49 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:04:39 2012
Incremental checkpoint up to RBA [0xbab7.18e666.0], current log tail at RBA [0xbab7.1a22b7.0]
Sat Jul 07 09:04:47 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:05:05 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:05:23 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:05:40 2012
ORA-28 : opiodr aborting process unknown ospid (9665_1)
Sat Jul 07 09:05:41 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:05:54 2012
Beginning log switch checkpoint up to RBA [0xbab8.2.10], SCN: 10153434806103
Thread 1 advanced to log sequence 47800 (LGWR switch)
Current log# 1 seq# 47800 mem# 0: /oracle_ebs/prod/db/apps_st/data/log01a.dbf
Current log# 1 seq# 47800 mem# 1: /oracle_ebs/prod/db/apps_st/data/log01b.dbf
Sat Jul 07 09:05:54 2012
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
LNS: Standby redo logfile selected for thread 1 sequence 47800 for destination LOG_ARCHIVE_DEST_2
Sat Jul 07 09:06:01 2012
Completed checkpoint up to RBA [0xbab8.2.10], SCN: 10153434806103
Sat Jul 07 09:06:23 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:07:15 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:07:35 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:08:10 2012
SMON: Parallel transaction recovery tried
Sat Jul 07 09:08:25 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:08:40 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:08:57 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:10:05 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried
Sat Jul 07 09:10:37 2012
SMON: Restarting fast_start parallel rollback
SMON: Parallel transaction recovery tried

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.2 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 24-Apr-2012***

Symptoms

After canceling a delete operation, then, physically killing the OS process and performing a truncate on the same table, the following is reported in the alert.log and trace file:

ALERT LOG

"SMON: Restarting
fast_start parallel rollback"

TRACE

Parallel transaction
recovery caught exception 12801

Parallel transaction recovery caught exception 30317

NOTE: Trace files are SMON traces found in bdump directory.

Cause

Parallel UNDO operation cannot find record previously deleted.

The error indicates that Oracle is trying to apply some parallel undo and checks to see if the object or record exists, if not, this error is raised.
This generally occurs when a truncate or a delete has taken place and the transaction is canceled.
If another delete or truncate then is issued, if the record is no longer in the UNDO, then you will receive this error.