ORA-03113 end-of-file on communication channel

Aus PPwiki
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