OCP-1Z0-053-V12.02-583题

583.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

Answer: AE

答案解析：

 可以从SEQUENCE# 看出当前所有日志的 SEQUENCE， 根据GROUP#在v$logfile找出member

sys@TEST1107> select * from v$log;                                                                                                                  

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME         NEXT_CHANGE# NEXT_TIME

---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ ------------ ------------------

         1          1         43   52428800        512          2 YES INACTIVE               1691556 09-NOV-13               1712026 09-NOV-13

         2          1         44   52428800        512          2 NO  CURRENT                1712026 09-NOV-13            2.8147E+14

         3          1         42   52428800        512          2 YES INACTIVE               1673515 09-NOV-13               1691556 09-NOV-13

sys@TEST1107> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_

---------- ------- ------- -------------------------------------------------- ---

         3         ONLINE  /u01/app/oracle/oradata/test1107/redo03.log        NO

         2         ONLINE  /u01/app/oracle/oradata/test1107/redo02.log        NO

         1         ONLINE  /u01/app/oracle/oradata/test1107/redo01.log        NO

         1         ONLINE  /u01/app/oracle/oradata/test1107/redo01a.log       NO

         2         ONLINE  /u01/app/oracle/oradata/test1107/redo02a.log       NO

         3         ONLINE  /u01/app/oracle/oradata/test1107/redo03a.log       NO

6 rows selected.