Database Administration (MOSC)

MOSC Banner

SYSAUX tablespace is offline after getting some IO errors

edited Aug 22, 2013 8:27PM in Database Administration (MOSC) 9 commentsAnswered
Hi,

In one of our database SYSAUX tablespace has gone offline due to some IO errors.

The following error was reported on 15-AUG-2013 in our alert log:


FILE_ID FILE_NAME TABLESPACE_NAME ONLINE_STATUS STATUS
---------- ------------------------------------------------------------ ------------------------------ -------------------- ---------
3 +LDTDOCSDATA1/ldtdocs/datafile/sysaux.272.619699241 SYSAUX RECOVER AVAILABLE



While reviewing the alert log we found some IO error on disk :/dev/oracle_devs/dat_0004_raw:

Thu Aug 15 22:00:07 BST 2013
WARNING: failed to write mirror side 0 of virtual extent 581 of file 272 in group 1
WARNING: IO Failed. au:1221 diskname:/dev/oracle_devs/dat_0004_raw
rq:ffffffff79b50500 buffer:389a92000 au_offset(bytes):360448 iosz:8192 operation:1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center