Home » RDBMS Server » Server Administration » REDO LOG status
REDO LOG status [message #214169] Mon, 15 January 2007 04:30 Go to next message
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

Re: REDO LOG status [message #214190 is a reply to message #214169] Mon, 15 January 2007 06:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/onlineredo.htm#862
Quote:

If STATUS is blank for a member, then the file is in use
Re: REDO LOG status [message #214257 is a reply to message #214169] Mon, 15 January 2007 10:01 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thank you very much
Previous Topic: Resize datafile - Problem
Next Topic: ora-01681
Goto Forum:
  


Current Time: Tue Dec 06 08:38:23 CST 2016

Total time taken to generate the page: 0.12631 seconds