DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: SMON Parallel Transaction Recovery Slave Got Internal Error

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Ludhiana (Punjab) India
    Posts
    36

    SMON Parallel Transaction Recovery Slave Got Internal Error

    Respected Friends

    I am getting this particular in my database and after that my database use to struck :

    This error comes in SMON Trace File.

    SMON Parallel Transaction Recovery Slave Got Internal Error
    Downgrading Transaction Recovery To Serial.
    Ora-00600, Internal Error Code , Arguments {4142},{268435459)

    After this database got struck. This error comes after every Second.

    Please help me out in this regard.

    Regards

    Gurpreet Singh Sethi

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Reduce parallelism. And try again.

    Tamil

  3. #3
    Join Date
    Apr 2001
    Location
    Ludhiana (Punjab) India
    Posts
    36

    SMON ERROR

    Dear Friend


    Earlier recovery_parallisum was set to 0 it is after getting this error we hqave changed it to 2 earlier it was serial.


    * any other parameter which is to be set in this regard


    gurpreet singh sethi

  4. #4
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    The error indicates that SMON noticed an error in parallel recovery and so aborts parallel recovery and does it serially. Despite the error in parallel recovery, recovery is done successfully (serially).

    As for the ora-600 error, Are you doing any truncates here? You can have a look at Metalink, there are some docs there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width