Suppose SYSAUX tablespace related datafiles are deleted or corrupted and no backup is available.
=====================================================================================
As we know sysaux tablespsace is newly introduced in 10g to reduce load on system tablespace. SYSAUX tablespace is contine information like AWR repositrory , streams long/lob data, RMAN repositry, OLAP , Datamining etc.
Moment sysaux tablespace is offline or datafile not accessible , Above modules will not work for database but database will be availble for users.
If database is having valid backup , restore backup then recover database to fix the issue.
If Database is not having any valid backup then , try to take export of user defined schemas once export is completed successfully , recreate database
and import. Even expdp/impdp will also fix the issue.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment