nerdexam
Oracle

1Z0-062 · Question #357

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting…

The correct answer is E. ALTER TABLESPACE users OFFLINE TEMPORARY. To initiate the recovery of a corrupt tablespace, it must first be taken offline to prevent access and facilitate the restoration and application of redo logs.

Performing Backup and Recovery

Question

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace?

Options

  • ASTARTUP FORCE
  • BALTER TABLESPACE users OFFLINE IMMEDIATE;
  • CSWITCH DATAFILE ALL;
  • DALTER TABLESPACE users OFFLINE NORMAL;
  • EALTER TABLESPACE users OFFLINE TEMPORARY;

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    13% (5)
  • D
    5% (2)
  • E
    76% (29)

Why each option

To initiate the recovery of a corrupt tablespace, it must first be taken offline to prevent access and facilitate the restoration and application of redo logs.

ASTARTUP FORCE

`STARTUP FORCE` is used to shut down and restart the entire database instance immediately, which is not the specific command needed to prepare a single tablespace for recovery.

BALTER TABLESPACE users OFFLINE IMMEDIATE;

`ALTER TABLESPACE users OFFLINE IMMEDIATE;` takes the tablespace offline without a checkpoint, which is generally not recommended for media recovery as it might require instance recovery if the database crashes before recovery completes.

CSWITCH DATAFILE ALL;

`SWITCH DATAFILE ALL;` is an RMAN command used to switch a data file to a different copy, typically after restoring a backup or performing a point-in-time recovery, not for taking a tablespace offline for initial preparation.

DALTER TABLESPACE users OFFLINE NORMAL;

`ALTER TABLESPACE users OFFLINE NORMAL;` attempts to perform a checkpoint on the tablespace, which can fail or hang if the data files are corrupt, making it unsuitable for initiating recovery of a corrupt tablespace.

EALTER TABLESPACE users OFFLINE TEMPORARY;Correct

When a tablespace's data file is corrupt and requires recovery, the `ALTER TABLESPACE users OFFLINE TEMPORARY;` command must be executed, as it takes the tablespace offline without performing a checkpoint, allowing RMAN to restore data files and apply redo logs for recovery while the database typically remains open.

Concept tested: Oracle tablespace recovery preparation

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/performing-user-managed-media-recovery.html#GUID-E1E79383-176A-4A59-BB68-BE67F33C623C

Topics

#tablespace recovery#datafile corruption#ARCHIVELOG mode

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice