Oracle
1Z0-062 · Question #357
1Z0-062 Question #357: Real Exam Question with Answer & Explanation
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;
Explanation
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.
Common mistakes.
- A.
STARTUP FORCEis 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. - B.
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. - C.
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. - D.
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.
Concept tested. Oracle tablespace recovery preparation
Topics
#tablespace recovery#datafile corruption#ARCHIVELOG mode
Community Discussion
No community discussion yet for this question.