OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » REDO LOG status

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

REDO LOG status [message #214169]

Mon, 15 January 2007 04:30

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Hi , ihad come across following scenario.

SQL> select GROUP#,MEMBER from v$logfile;

    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
         1
/oradata1/u03/prod/prod_redo1a.log

         1
/oradata1/u04/prod/prod_redo1b.log

         2
/oradata1/u03/prod/prod_redo2a.log


    GROUP#
----------
MEMBER
--------------------------------------------------------------------------------
         2
/oradata1/u04/prod/prod_redo2b.log

         3
/oradata1/u03/prod/prod_redo3a.log

         3
/oradata1/u04/prod/prod_redo3b.log


and i issued 

SQL> select distinct status from v$logfile;

STATUS
-------

status it is showing NOTHING.my database is running fine and there are lot of transactions happening.but my qusetion is why it is showing no status for log file?

Thannks
RK

[Updated on: Mon, 15 January 2007 06:26] by Moderator

Report message to a moderator