nerdexam
Oracle

1Z0-062 · Question #353

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery…

The correct answer is A. ALTER TABELSPACE users OFFLINE. Before initiating recovery for a damaged data file within a specific tablespace, the entire affected tablespace must be taken offline to ensure data consistency and prevent further writes.

Performing Backup and Recovery

Question

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace?

Options

  • AALTER TABELSPACE users OFFLINE
  • BSTARTUP FORCE NOMOUNT
  • CSTARTUP FORCE
  • DSWITCH DATAFILE ALL

How the community answered

(31 responses)
  • A
    81% (25)
  • B
    3% (1)
  • C
    10% (3)
  • D
    6% (2)

Why each option

Before initiating recovery for a damaged data file within a specific tablespace, the entire affected tablespace must be taken offline to ensure data consistency and prevent further writes.

AALTER TABELSPACE users OFFLINECorrect

When a data file in a tablespace is damaged and recovery is necessary, the `ALTER TABLESPACE users OFFLINE` command must be executed. Taking the tablespace offline ensures that no new transactions can access or modify the tablespace, which is crucial for maintaining data consistency during the restoration and recovery process.

BSTARTUP FORCE NOMOUNT

`STARTUP FORCE NOMOUNT` is used to start an instance without mounting a database, typically for database creation or specific RMAN operations, not for recovering an existing tablespace.

CSTARTUP FORCE

`STARTUP FORCE` is used to shut down and restart the instance, but it does not specifically prepare a tablespace for recovery; the tablespace still needs to be taken offline.

DSWITCH DATAFILE ALL

`SWITCH DATAFILE ALL` is an RMAN command used to change the location of data files during operations like switchover or copy, not as a prerequisite for initiating a tablespace recovery after damage.

Concept tested: Oracle tablespace offline for recovery

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tablespaces.html#GUID-E37D35E4-91E3-4015-844C-C349C168393F

Topics

#tablespace recovery#datafile damage#ARCHIVELOG mode

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice