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