1Z0-032 · Question #113
You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is running in ARCHIVELOG mode. On Monday morning, you find that users are unable to access the USERS…
The correct answer is B. restore and recover the corrupted data files by using the RESTORE DATAFILE and RECOVER DATAFILE D. restore and recover the tablespace by using the RESTORE TABLESPACE and RECOVER TABLESPACE. See the full explanation below for the reasoning.
Question
You are using Recovery Manager (RMAN) to back up your database at regular intervals. The database is running in ARCHIVELOG mode. On Monday morning, you find that users are unable to access the USERS tablespace. On investigation, you find that all the data files that belong to the USERS tablespace are corrupted and you do not have any logical back up of the database. Which two options could you use to recover the tablespace along with the data, without affecting other data files? (Choose two.)
Options
- Adrop and re-create the USERS tablespace
- Brestore and recover the corrupted data files by using the RESTORE DATAFILE and RECOVER DATAFILE
- Crestore and recover the data files by using the RESTORE DATABASE and RECOVER DATABASE commands
- Drestore and recover the tablespace by using the RESTORE TABLESPACE and RECOVER TABLESPACE
How the community answered
(58 responses)- A16% (9)
- B76% (44)
- C9% (5)
Community Discussion
No community discussion yet for this question.