How to recover SYSAUX tablespace?
I'm using Oracle 10g and have just found out that the SYSAUX tablespace has RECOVER status. When I check the datafile I can see that it hasn't been updated since May 2012. I understand that the core functionality in the database still is ok but have found some disturbances that I think is connected to this problem. Looking on the web i found that you can recover this tablespace: e.g. using RMAN:
connect target /
RUN {
sql "alter tablespace sysaux offline";
RESTORE TABLESPACE sysaux;;
RECOVER TABLESPACE sysaux;
SQL "alter tablespace sysaux online";
}
but since we are doing daily RMAN backups an this error has existed since May, is there anything in the backup that the tablespace can be recovered from?
1