Understanding The Oracle Sysaux Tablespace

 

The SYSAUX tablespace stores data for auxiliary applications such as the Log Miner, Work space Manager, Oracle Data Mining, Oracle Streams, and many other Oracle tools.

  • This tablespace is automatically created if you use the DataBase Creation Assistant(DBCA) software to build an Oracle database.
  • Like the SYSTEM tablespace, SYSAUX requires a higher level of security and it cannot be dropped or renamed.
  • Do not allow user objects to be stored in SYSAUX. This tablespace should only store system specific objects.
  • This is a permanent tablespace.
RECOVERY:

If you have backup of sysaux and following all archives then you can recover sysaux tablespace.

RMAN> restore tablespace sysaux;

RMAN> recover tablespace sysaux;

SQL> alter tablespace sysaux online;

If you say you lost sysaux file and you don’t have backup and all archive files, then you don’t have option of recreating sysaux tablespace

Solution for this scenario:

you may have to use CTAS or export backup of this database and rebuild complete database.

you may not be able to deal with physical backup.

 

Catch Me On:- Hariprasath Rajaram 

Telegram:https://t.me/joinchat/I_f4DkeGfZuxgMIoJSpQZg LinkedIn:https://www.linkedin.com/in/hariprasathdba Facebook:https://www.facebook.com/HariPrasathdba 
FB Group:https://www.facebook.com/groups/894402327369506/ 
FB Page: https://www.facebook.com/dbahariprasath/? 
Twitter: https://twitter.com/hariprasathdba

Leave a Reply

Your email address will not be published. Required fields are marked *