My Oracle Support Banner

Archive Log List command does not display all destinations (Doc ID 461649.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Oracle Database - Enterprise Edition - Version to [Release 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.


The command archive log list doesn't show the first archive destination.

SQL>Archive log list

Database log mode Archive Mode
Automatic archival Enabled
Archive destination /opt/oracle/exp/eqa01p/arch02

SQL>Show parameter archive

NAME                           VALUE
-------------------------  ------------------------------
archive_lag_target              0
log_archive_dest_1         location=/u01/eqa01p/arch01 noreopen max_failure=0 
                            mandatory alternate=log_archive_dest_2

log_archive_dest_2         location=/opt/oracle/exp/eqa01p/arch02

log_archive_dest_state_1     ENABLE
log_archive_dest_state_10    ENABLE
log_archive_dest_state_2     ALTERNATE
log_archive_dest_state_3     ENABLE

Why doesn't it show the log_archive_dest_1 in the archive log list output?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.