ORA-03113 end-of-file on communication channel

Aus PPwiki
Version vom 18. Februar 2021, 12:43 Uhr von Schild (Diskussion | Beiträge)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche


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';

db_recovery_file_dest_size

Archivelog kontrollieren und abschalten