SQL> show parameter archive; NAME TYPE VALUE ---------------------------------- ---------- ----- archive_lag_target integer 0 log_archive_dest string log_archive_dest_1 string log_archive_dest_10 string log_archive_dest_2 string log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string NAME TYPE VALUE ------------------------------------ --------- ------ log_archive_dest_9 string log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable log_archive_dest_state_9 string enable NAME TYPE VALUE ------------------------------------ ------- ------ log_archive_duplex_dest string log_archive_format string ARC%S.%T log_archive_max_processes integer 1 log_archive_min_succeed_dest integer 1 log_archive_start boolean FALSE log_archive_trace integer 0 remote_archive_enable boolean TRUE standby_archive_dest string %ORACLE_HOME%\RDBMS SQL> show parameter standby; NAME TYPE VALUE ------------------------------------ -------- ------ standby_archive_dest string %ORACLE_HOME%\RDBMS standby_file_management string MANUAL standby_preserves_names boolean FALSE