ORA-00376 on SYSAUX-Tablespace
Hello!
In one of our databases (Oracle10gR2) the datafile of the SYSAUX-tablespace is unavailable (offline, needs recovery), e.g.
Errors in file /opt/oracle/product/10gR2/db/rdbms/log/okf87p_j000_5899.trc:
ORA-12012: Fehler beim autom Ausführen von Job 5353
ORA-00376: Datei ORA-00376: Datei 3 kann zur Zeit nicht gelesen werden
ORA-01110: Datendatei 3: '/db/okf87p/sysauxokf87p.dbf'
ORA-06512: in "SYS.DBMS_ISCHED", Zeile 492
ORA-06512: in "SYS.DBMS_SCHEDULER", Zeile 2390
I'm afraid a database recovery is not an option, since we'd have too much data loss.
Do you have any experience with recreation of the SYSAUX-Tablespace? Is the following an option?
In one of our databases (Oracle10gR2) the datafile of the SYSAUX-tablespace is unavailable (offline, needs recovery), e.g.
Errors in file /opt/oracle/product/10gR2/db/rdbms/log/okf87p_j000_5899.trc:
ORA-12012: Fehler beim autom Ausführen von Job 5353
ORA-00376: Datei ORA-00376: Datei 3 kann zur Zeit nicht gelesen werden
ORA-01110: Datendatei 3: '/db/okf87p/sysauxokf87p.dbf'
ORA-06512: in "SYS.DBMS_ISCHED", Zeile 492
ORA-06512: in "SYS.DBMS_SCHEDULER", Zeile 2390
I'm afraid a database recovery is not an option, since we'd have too much data loss.
Do you have any experience with recreation of the SYSAUX-Tablespace? Is the following an option?
0