Whenever sysaux goes to recovery state, you won’t be able to do the exp or expdp. You will get error like ‘not able to read/write sysaux’ datafiles. If you don’t have the archivelog to recover the sysaux, then you can follow below steps to atleast get the exp work. expdp doesn’t work still.
Shutdown immediate;
startup upgrade
@?/rdbms/admin/catnoqm.sql
shutdown immediate
startup
There you go, your export will work. Pls note, you may have to rebuild to have perfect system.
