SQL> select Name,
2 Value
3 from V$PARAMETER
4 where Name like "log_archive%";
NAME
--------------------------------------------------------------------------------
VALUE
------------------------------------------------------------------------------------------------------------------------
log_archive_config
log_archive_start
FALSE
log_archive_dest
log_archive_duplex_dest
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_6
log_archive_dest_7
log_archive_dest_8
log_archive_dest_9
log_archive_dest_10
log_archive_dest_state_1
enable
log_archive_dest_state_2
enable
log_archive_dest_state_3
enable
log_archive_dest_state_4
enable
log_archive_dest_state_5
enable
log_archive_dest_state_6
enable
log_archive_dest_state_7
enable
log_archive_dest_state_8
enable
log_archive_dest_state_9
enable
log_archive_dest_state_10
enable
log_archive_max_processes
2
log_archive_min_succeed_dest
1
log_archive_trace
0
log_archive_local_first
TRUE
log_archive_format
ARC%S_%R.%T
SQL>
SQL>
SQL>