Home > TroubleShooting > ORA-00471: DBWR process terminated with error

ORA-00471: DBWR process terminated with error

December 22, 2009 Leave a comment Go to comments

Symptoms

1. Recently, we enable direct io option (i.e.  convosync=direct) of the database filesystem (vxfs) and restart database

2. After that, create a test table with about 1 million, suddenly the database crashed

3. Try to restart the database, we got the messages below.

ORA-00471: DBWR process terminated with error

Cause

1. Can mount the database in mount, can’t open the database

2. When try to open the database, we find that high IO read/writes is monitored on system by the command iostat -cmnzx 5

Fixed

1. Fallback the database filesystem setting ( i.e. remove the convosync=direct)

2. Can start and open the database

3. The high IO read/writes are not monitored when opening the database

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: