Archive log destination without setting any of Log Archive or recovery parameters
Database - 11.2.0.1.0 I was wondering how 'archive log list' is showing an archive log destination without setting any of relevant archive log destination or db recovery parameters. LOG_ARCHIVE_DEST LOG_ARCHIVE_DEST_n DB_RECOVERY_FILE_DEST SQL> archive log list ; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch Oldest online log sequence 8 Current log sequence 10 SQL> show parameter log_archive_dest; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string SQL> show parameter db_recovery NAME TYPE VALUE