归档日志路径为LOG_ARCHIVE_DEST指定的路径:
SQL> show parameter log_archive_dest; NAME TYPE VALUE------------------------------------ ----------- ------------------------------log_archive_dest string好吧。我承认。事实上最靠谱的查看方法是:
SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 173Next log sequence to archive 175Current log sequence 175