Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Redo Log Groups

Stan - HerrmanOct 1 2003 — edited Oct 3 2003

Call me stupid, but for some reason I've decided to get certified as a DBA even though I have always been a developer. Honestly, its not my fault. The choices in the development track are pretty boring...

Anyway, while pouring through the Backup/Recovery documentation, I run across this:

Every database must have at least two online redo log groups.
Each redo log group contains at least one online redo log member,
which is a physical file containing the redo records.

I decided to check and see if I have "at least two online redo log groups" for my play database. Now, I am very very confused.

I think this query shows my 3 log members, but for some reason the 1st column makes me think I have 3 log groups:

select group#, member from v$logfile
/
    GROUP# MEMBER
---------- ----------------------------------------
         3 /var/opt/oracle/oradata/db92/redo03.log
         2 /var/opt/oracle/oradata/db92/redo02.log
         1 /var/opt/oracle/oradata/db92/redo01.log

I only know of one place where my online redo is located:

ls $ORACLE_BASE/oradata/db92
redo01.log  redo02.log  redo03.log

Can someone help me figure out if I have one-group and three-members??

Any comments are welcome,
Stan

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 31 2003
Added on Oct 1 2003
#general-database-discussions
14 comments
726 views