SYBEX ADMIN 1
P-584
15. The STATUS column of the dynamic performance view V$LOGFILE contains what value if the
redo log file group has just been added or the log file group member has just been re-created?
A. INVALID
B. STALE
C. DELETED
D. The column contains a NULL value.
15. B. If the redo log file group member has never been used, either due to a new redo log file group
or a repaired member, the value of STATUS is STALE until the log file member is used to record
redo information.
答案是B 但是我自己做实验时，是INVALID状态?
SQL> show user;
USER is "SYS"
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod
PL/SQL Release 10.1.0.2.0 - Production
CORE10.1.0.2.0Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
SQL> column member format a48
SQL> select * from v$logfile order by group#;
GROUP# STATUSTYPEMEMBER
IS_
---------- ------- ------- ------------------------------------------------ ---
1 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO01.LOGNO
1 ONLINED:ORACLEPRODUCT10.1.0ORADATAORARED101.LOGNO
2 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO02.LOGNO
3 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO03.LOGNO
3 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO32.LOGNO
3 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO52.LOGNO
4 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO04.LOGNO
5 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO05.LOGNO
5 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO55.LOGNO
9 rows selected.
SQL> alter database add logfile member
2'D:ORACLEPRODUCT10.1.0ORADATAORAREDO22.LOG' to group 2;
Database altered.
SQL> select * from v$logfile order by group#;
GROUP# STATUSTYPEMEMBER
IS_
---------- ------- ------- ------------------------------------------------ ---
1 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO01.LOGNO
1 ONLINED:ORACLEPRODUCT10.1.0ORADATAORARED101.LOGNO
2 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO02.LOGNO
2 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO22.LOGNO
3 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO03.LOGNO
3 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO32.LOGNO
3 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO52.LOGNO
4 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO04.LOGNO
5 ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO05.LOGNO
5 INVALID ONLINED:ORACLEPRODUCT10.1.0ORADATAORAREDO55.LOGNO
10 rows selected.
SQL>
