Performing Oracle User-Managed Backups - OCP: Oracle Database 12c Administrator Certified Professional - page 35

exeRCiSe 1.2 (continued)
C:\ORACLE\ARCH\ORCL\ORCL_658485967_1_3.ARC 1 3
C:\ORACLE\ARCH\ORCL\ORCL_658485967_1_4.ARC 1 4
C:\ORACLE\ARCH\ORCL\ORCL_658485967_1_5.ARC 1 5
In the output, you will find the name of the archived redo log. You also see the thread
number (in case you are running RAC) and the log sequence number. Note that since
you have put the database in ARCHIVELOG mode, you have generated four archived
redo logs.
2. You can see where your online redo logs are by using the V$LOGFILE view, as shown
in this example:
SQL> select group#, status, member from v$logfile;
GROUP# STATUS MEMBER
---------- ------- ----------------------------------
3 C:\ORACLE\ORADATA\ORCL\REDO03A.LOG
2 C:\ORACLE\ORADATA\ORCL\REDO02.LOG
1 C:\ORACLE\ORADATA\ORCL\REDO01.LOG
3 C:\ORACLE\ORADATA\ORCL\REDO03B.LOG
In this output, you can see you have three online redo log groups. It is interesting to
note that group 3 actually has two members, whereas groups 1 and 2 have one mem-
ber each.
3. You can see which is the current online redo log group by querying the V$LOG view,
as shown here:
SQL> select group#, sequence#, status from v$log;
GROUP# SEQUENCE# STATUS
---------- ---------- ----------------
1 13 CURRENT
2 11 ACTIVE
3 12 ACTIVE
In this example, log group 1 (marked with a CURRENT status) is the group that Oracle is
currently writing to. Note that sequences 11 and 12 are marked active. This implies that
they have not been archived yet or that they are being archived. They will be marked
inactive once ARCH has finished archiving them.