We are querying v$logfile on one of our server and found that there total 9 log groups listed but when we are checking from v$log, it is showing only 4 log groups, why these two results differs?
Are you using dataguard?
What is the type of the group# from v$logfile?
You missed few thing to provide - What your database version..? - Is your database setup with dataguard..? - Post the result of the both v$logfile,v$log
Version is Oracle 11g Release 2, it is a 3 node data guard environment. Result is consistent in all the three nodes. I am not in the same environment now, will post it later ie outputs from v$logfile and v$log.