v$archived_log not show entries for LOCATION=USE_DB_RECOVERY_FILE_DEST
Hi,
I have a database in version 12.2.0.1.0, and I configured log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST', the archived logs are successfully saved in the flash recovery area, however, when I query v$archived_log view,
the files information are not shown in the view, due to this reason, the v$flash_recovery_area_usage shows inaccurate information.
I will have to do a "catalog recovery area" rman command before v$flash_recovery_area_usage shows the correct information.
I also found that if I update the system log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST'
i.e. the filename can successfully show in v$archived_log.