Hello Guys, i am unable to find out the location of my archive logs. The VALUE field is null.
SQL> show parameter log_archive_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2907
Next log sequence to archive 2908
Current log sequence 2909
When I do
SQL>show parameter USE_DB_RECOVERY_FILE_DEST,I am not getting any result.
when I do *SQL>show parameter DB_RECOVERY_FILE_DEST, I am getting the result.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +BKUP_TSD1
db_recovery_file_dest_size big integer 500G
So +BKUP_TSD1, is this where my archive logs are present?