归档日志路径为LOG_ARCHIVE_DEST指定的路径:
SQL> show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string
好吧。我承认。事实上最靠谱的查看方法是:
SQL> archive log list Database log mode Archive Mode Automatic archival Enabled <span style="color:#FF0000;">Archive destination USE_DB_RECOVERY_FILE_DEST</span> Oldest online log sequence 173 Next log sequence to archive 175 Current log sequence 175