nerdexam
Oracle

1Z0-052 · Question #251

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

The correct answer is D. If the above operation were successful, media recovery would be required to bring the tablespace. Using OFFLINE IMMEDIATE skips checkpointing the tablespace's datafiles, leaving unwritten changes in redo logs, so media recovery is required before the tablespace can be brought back online.

Performing Backup and Recovery

Question

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

Options

  • AThe operation would fail if tbs_1 were a read-only tablespace.
  • BThe operation would fail if tbs_1 were a read/write tablespace.
  • CThe operation would fail if tbs_1 were the default tablespace for the database.
  • DIf the above operation were successful, media recovery would be required to bring the tablespace
  • EIf the above operation were successful, instance recovery would be required to bring the

How the community answered

(24 responses)
  • B
    4% (1)
  • C
    13% (3)
  • D
    79% (19)
  • E
    4% (1)

Why each option

Using OFFLINE IMMEDIATE skips checkpointing the tablespace's datafiles, leaving unwritten changes in redo logs, so media recovery is required before the tablespace can be brought back online.

AThe operation would fail if tbs_1 were a read-only tablespace.

A read-only tablespace cannot be taken offline with IMMEDIATE - the operation does not fail because of the tablespace type; the read-only or read-write status is irrelevant to whether OFFLINE IMMEDIATE succeeds.

BThe operation would fail if tbs_1 were a read/write tablespace.

A read/write tablespace does not cause OFFLINE IMMEDIATE to fail - it succeeds normally on read/write tablespaces, which is the typical use case for this command.

CThe operation would fail if tbs_1 were the default tablespace for the database.

The default tablespace designation does not prevent OFFLINE IMMEDIATE from executing; Oracle allows the command regardless of what role the tablespace plays in the database.

DIf the above operation were successful, media recovery would be required to bring the tablespaceCorrect

OFFLINE IMMEDIATE does not perform a checkpoint, meaning committed data that was still in the buffer cache is never flushed to the datafiles. Because the database is in ARCHIVELOG mode, the archived redo logs contain the missing changes, and media recovery replays those logs against the datafiles to make them consistent before the tablespace can be brought back online.

EIf the above operation were successful, instance recovery would be required to bring the

Instance recovery is an automatic process performed by SMON at startup after a crash or SHUTDOWN ABORT, not the mechanism used after OFFLINE IMMEDIATE, which specifically requires explicit media recovery.

Concept tested: Oracle OFFLINE IMMEDIATE media recovery requirement

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tablespaces.html

Topics

#tablespace offline IMMEDIATE#media recovery#ARCHIVELOG mode#tablespace recovery

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice