nerdexam
Oracle

1Z0-052 · Question #234

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?

The correct answer is B. INVALID. When an Oracle redo log member file is missing or inaccessible, V$LOGFILE reports its STATUS column as INVALID, indicating Oracle cannot access that file.

Managing the Database Instance

Question

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?

Options

  • ALOST
  • BINVALID
  • CEXPIRED
  • DDELETED
  • ECORRUPT
  • FUNKNOWN
  • GOBSOLETE

How the community answered

(64 responses)
  • A
    2% (1)
  • B
    92% (59)
  • E
    5% (3)
  • F
    2% (1)

Why each option

When an Oracle redo log member file is missing or inaccessible, V$LOGFILE reports its STATUS column as INVALID, indicating Oracle cannot access that file.

ALOST

LOST is not a valid status value defined for the V$LOGFILE STATUS column; Oracle does not use this term to describe missing redo log members.

BINVALIDCorrect

The STATUS column in V$LOGFILE displays INVALID for any redo log member that Oracle cannot access or that no longer exists on the filesystem. When a member is lost at the OS level, Oracle marks it INVALID in this dynamic performance view to signal the file is inaccessible, allowing a DBA to identify and add a replacement member.

CEXPIRED

EXPIRED is not a recognized status in V$LOGFILE; this term applies to archived log files within RMAN catalog contexts, not to online redo log members.

DDELETED

DELETED in Oracle contexts refers to backup pieces removed from the RMAN catalog, not the status of a missing online redo log member in V$LOGFILE.

ECORRUPT

CORRUPT is not a status shown in V$LOGFILE for a missing member; Oracle uses INVALID to describe inaccessible files rather than distinguishing between missing and corrupt states at this view level.

FUNKNOWN

UNKNOWN is not a valid status in V$LOGFILE; the recognized status values are null (file in normal use), INVALID, STALE, and DELETED.

GOBSOLETE

OBSOLETE is an RMAN-specific term describing backup pieces no longer needed by the retention policy and is not a status value used in V$LOGFILE.

Concept tested: V$LOGFILE STATUS values for inaccessible redo log members

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-LOGFILE.html

Topics

#V$logfile#redo log member status#INVALID status#log file management

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice