Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to recover SYSAUX tablespace

Red Hand LukeSep 16 2008 — edited Sep 16 2008

I have noticed that my SYSAUX tablespace is in RECOVER mode as follows :

How do I go about correcting this issue?

SQL> select tablespace_name,ONLINE_STATUS,FILE_ID from dba_data_files;

TABLESPACE_NAME ONLINE_ FILE_ID
------------------------------ ------- ----------
SYSTEM SYSTEM 1
SYSAUX RECOVER 2
UNDOTBS1 ONLINE 3
UNDOTBS2 ONLINE 4
UNDOTBS3 ONLINE 5
USERS ONLINE 6
DATA_TBS ONLINE 7
INDEX_TBS ONLINE 8

Edited by: Red Hand Luke on Sep 16, 2008 10:06 AM

Edited by: Red Hand Luke on Sep 16, 2008 10:07 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 14 2008

Added on Sep 16 2008

#general-database-discussions

7 comments

1,872 views