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.
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)- A81% (25)
- B3% (1)
- C10% (3)
- D6% (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.
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.
`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.
`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.
`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
Community Discussion
No community discussion yet for this question.