One of the redo log members in your database is lost. You queried V$logfile for further details. What
would be the member’s status?
A.
LOST
B.
INVALID
C.
EXPIRED
D.
DELETED
E.
CORRUPT
F.
UNKNOWN
G.
OBSOLETE
What would be the member’s status?
One of the redo log members in your database is lost. You queried V$logfile for further details. What
would be the member’s status?
V$LOGFILE
This view contains information about redo log files.
Status of the log member:
INVALID – File is inaccessible
STALE – File’s contents are incomplete
DELETED – File is no longer used
null – File is in use
https://docs.oracle.com/cd/B12037_01/server.101/b10755/dynviews_1128.htm