ORA-03113: Unterschied zwischen den Versionen
Aus PPwiki
Schild (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „{{DISPLAYTITLE:ORA-03113 end-of-file on communication channel|noerror}}“) |
Schild (Diskussion | Beiträge) |
||
| (2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
{{DISPLAYTITLE:ORA-03113 end-of-file on communication channel|noerror}} | {{DISPLAYTITLE:ORA-03113 end-of-file on communication channel|noerror}} | ||
| + | |||
| + | 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. | ||
| + | |||
| + | <pre> | ||
| + | ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G; | ||
| + | |||
| + | ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u02/oracle/fra'; | ||
| + | </pre> | ||
| + | |||
| + | [http://www.dba-oracle.com/p_db_recovery_file_dest_size.htm db_recovery_file_dest_size] | ||
| + | |||
| + | [[Plug-Plant_intern#Archivelog|Archivelog kontrollieren und abschalten]] | ||
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';
