SMON: Restarting fast_start para…

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.

Solution

No action is required. No corruption applies unless the error is followed by other internal errors on the object.

Sat Jul 07 09:10:42 2012