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 |
EXP-00091: Exporting questionable statistics.
QSM-02148: many to many subquery joins require 9.0 compatibility or higher
PLS-00588: unqualified instance attribute references allowed only in member methods
ORA-13287: can't transform unknown gtype
ORA-14515: only one aubpartition name can be specified
ORA-07569: slspool: $CLOSE failure
ORA-00259: log string of open instance string (thread string) is the current log, cannot archive
TNS-12561: TNS:unknown error
ORA-31666: Master process string had an unhandled exception.
PCB-00300: Datatype for host variable not supported by ANSI "string"
ORA-07265: sppst: semop error, unable to increment semaphore.
ORA-26701: STREAMS process string does not exist