ORA-16038: log string sequence# string cannot be archived
Answers were Sorted based on User's Feedback
Answer / geraldo viana
Verify in the LOG_ARCHIVE_DEST the variable FILE SYSTEM.
In almost cases the size of the file system is full.
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sandeep joel dmello
increase db_recovery_file_dest_size.
alter system set db_recovery_file_dest_size=4096M
scope=both;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / kirankumar.upadhyayula
ORA-16038: log 2 string sequence# 48string cannot be
archived?
Ans:-alter system set db_recovery_file_dest_size=4096M
scope=both;
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / guest
Cause: An attempt was made to archive the named file, but
the file could not be archived. Examine the secondary error
messages to determine the cause of the error.
Action: No action is required.
Please add more information about this Error
Is This Answer Correct ? | 0 Yes | 3 No |
ORA-01159: file is not from same database as previous files - wrong database id
ORA-02805: Unable to set handler for SIGTPA
DRG-11811: Multiple Choices
ORA-38485: invalid object type for the user-defined function
ORA-00346: log member marked as STALE
QSM-02183: Expression to enable PCT not in PARTITION BY of analytic function or SPREADSHEET
ORA-16092: dependent archive log destination is not active
RMAN-03009: failure of string command on string channel at string
NNL-00562: unregister <name> [-d<address>] [-l<listener_name>] : unregister an object with Oracle Names
IMG-00834: merged area queue is full
ORA-00332: archived log is too small - may be incompletely archived
ORA-25217: enqueue failed, visibility must be IMMEDIATE for queue string.string