Database - RAC/Scalability (MOSC)

MOSC Banner

redo log files and archive log files count shows as 0 in v$FLASH_RECOVERY_AREA_USAGE view on RAC env

edited Feb 19, 2013 6:18AM in Database - RAC/Scalability (MOSC) 10 commentsAnswered
Hi Gurus,

I observed that no of redo logs count is showing as 0 in v$FLASH_RECOVERY_AREA_USAGE. But i have added 16 log file members to my flash recovery area (+FLASHITHP). But this view is not showing the no of redo log file members as well as no of archive log files count. The details are as follows

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +FLASHITHP
Oldest online log sequence     29440
Next log sequence to archive   29443
Current log sequence           29443

SQL> select * from gv$log;

   INST_ID     GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM

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