Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center