ORA-03113: Unterschied zwischen den Versionen
Aus PPwiki
Schild (Diskussion | Beiträge) |
Schild (Diskussion | Beiträge) |
||
| Zeile 7: | Zeile 7: | ||
<pre> | <pre> | ||
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G; | ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G; | ||
| + | |||
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u02/oracle/fra'; | ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u02/oracle/fra'; | ||
</pre> | </pre> | ||
Aktuelle Version vom 18. Februar 2021, 12:43 Uhr
Passiert, wenn die Archive Logs die maximale Größe überschreiten.
If I look in the alert log it states that there are errors in the .trc files with error codes "ORA-19809", "ORA-19804", "ORA-16038", and "ORA-00312". This is proceeded by the error "ORA-19815" which states that the db_recovery_file_dest_size is 100% used and has zero bytes available.
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G; ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u02/oracle/fra';
