Peoplecnc.com - How to query the redo log file information from an Oracle Database

ERP and Technical Documentation

Oracle ERP1
JDEdwards

Topics
Home General News (1/202) ERP White Papers (0/225) JDEdwards - Peoplesoft - Oracle ERP1 White Paper (9/218) Oracle Documentation and White Papers (19/456) Oracle DBA Commands (1/222) Webserver / Apache (2/232)

User Functions
Username: Password: Don't have an account yet? Sign up as a New User Lost your password?

Events
There are no upcoming events

Older Stories

Wednesday 17-May

Thursday 11-May

Wednesday 10-May

Monday 08-May

Welcome to Peoplecnc.com
Wednesday, September 08 2010 @ 07:11 AM CDT

How to query the redo log file information from an Oracle Database

Wednesday, May 17 2006 @ 10:31 AM CDT
Contributed by: sv800
Views: 7,267

Find the status and location of the redo log files

To query the redo logs groups and members information including the status of the redo log file:

SQL> select group#, sequence#, bytes, members, status from v$log;

GROUP# SEQUENCE# BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
5 74704 10485760 1 CURRENT
6 74702 10485760 1 INACTIVE
7 74703 10485760 1 INACTIVE

To query the redo log file member location of files

SQL> select member from V$LOGFILE;

MEMBER
--------------------------------------------------------------------------------
E:ORACLEORADATAJDELOG5.ORA
E:ORACLEORADATAJDELOG6.ORA
E:ORACLEORADATAJDELOG7.ORA

What's Related
More by sv800 More from Oracle Documentation and White Papers

Story Options
Mail Story to a Friend Printable Story Format