ORA-03113: Unterschied zwischen den Versionen
Aus PPwiki
Schild (Diskussion | Beiträge) |
Schild (Diskussion | Beiträge) |
||
| (Eine dazwischenliegende Version desselben Benutzers wird nicht angezeigt) | |||
| Zeile 4: | Zeile 4: | ||
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. | 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] | [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]] | [[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';
