Which view or views would you use to determine this information?

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so,
you need to know the names of the online redo logs so you can apply them during recovery.
Which view or views would you use to determine this information? (Choose all that apply.)

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so,
you need to know the names of the online redo logs so you can apply them during recovery.
Which view or views would you use to determine this information? (Choose all that apply.)

A.
V$LOGFILE

B.
V$RECOVER_LOG

C.
V$RECOVER_DATABASE

D.
V$LOG_RECOVER

E.
V$LOG

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

dcdba

dcdba

How I can get the filename from V$LOG ?

Reply

Eamon

Eamon

You dont get the filename from V$LOG you get it from

SELECT group#,status,member
FROM V$LOGFILE
ORDER BY 1,3;

GROUP# STATUS MEMBER
———- ——- —————————————-
1 /u01/app/oracle/oradata/orcl/redo01a.log
1 /u01/app/oracle/oradata/orcl/redo01b.log
2 /u01/app/oracle/oradata/orcl/redo02a.log
2 /u01/app/oracle/oradata/orcl/redo02b.log
3 /u01/app/oracle/oradata/orcl/redo03a.log
3 /u01/app/oracle/oradata/orcl/redo03b.log

V$LOG contains the sequence information.

SELECT group#, sequence#, members, archived, status FROM V$LOG;

GROUP# SEQUENCE# MEMBERS ARC STATUS
———- ———- ———- — ——-
1 1 1 NO CURRENT
2 0 1 YES INACTIVE
3 0 1 YES ACTIVE

You can join these using GROUP#

Reply

e

e

According to the book where this questio appears, it gives the following answer…..รง

A, E. The V$LOGFILE view will give you the name of the online redo logs associated with each group. The V$LOG view will provide the current sequence number assigned to each group.

Reply