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?
The correct answer is E--> because the datafile is corrupt. An is not B because only apply when the datafile is lost or delete and mention for that command is deprecated it's better use transportable tablespaces. https://docs.oracle.com/database/121/SQLRF/statements_3002.htm#i2154551
Correct answer is E.
Specify TEMPORARY only when you cannot take the tablespace offline normally. In this case, only the files taken offline because of errors need to be recovered before the tablespace can be brought online. Specify IMMEDIATE only after trying both the normal and temporary settings.
(https://docs.oracle.com/cd/E18283_01/server.112/e17120/tspaces005.htm)
B is correct
https://docs.oracle.com/database/121/BRADV/glossary.htm#GUID-ABDE7EEF-D4B3-4867-A69C-3B24614AF430
Media failure - Damage to the disks containing any of the files used by Oracle, such as the data files, archived redo log files, or control file. When Oracle detects media failure, it takes the affected files offline.
Media recovery is only possible when the database is in ARCHIVELOG mode
https://docs.oracle.com/database/121/ADMIN/tspaces.htm#ADMIN11388
A tablespace can be taken offline immediately, without the database taking a checkpoint on any of the data files.
When you specify OFFLINE IMMEDIATE, media recovery for the tablespace is required before the tablespace can be brought online.
You cannot take a tablespace offline immediately if the database is running in NOARCHIVELOG mode.
Sorry C after I read this
If you must take a tablespace offline, use the NORMAL clause (the default) if possible. This setting guarantees that the tablespace will not require recovery to come back online, even if after incomplete recovery you reset the redo log sequence using an ALTER DATABASE OPEN RESETLOGS statement.
Specify TEMPORARY only when you cannot take the tablespace offline normally. In this case, only the files taken offline because of errors need to be recovered before the tablespace can be brought online. Specify IMMEDIATE only after trying both the normal and temporary settings.
I agree
https://docs.oracle.com/database/121/SQLRF/statements_3002.htm#SQLRF01002
OFFLINE TEMPORARY If you specify TEMPORARY, then Oracle Database performs a checkpoint for all online data files in the tablespace but does not ensure that all files can be written. Files that are offline when you issue this statement may require media recovery before you bring the tablespace back online.
B in my opinion.
Because you will use Media recovery.
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces005.htm#ADMIN11376
upvoted 3 times
...
...
...
This section is not available anymore. Please use the main Exam Page.1z0-062 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
TuxBingo
Highly Voted 4 years, 10 months agodfabac
Most Recent 2 years, 12 months agojackymak
3 years, 2 months agodancymonkey
4 years, 9 months agodancymonkey
4 years, 9 months agohggz
4 years, 9 months agoSKY_ming
5 years, 2 months agotaiyang
5 years, 2 months agohggz
5 years, 2 months agoexampro46
3 years, 12 months agoSKY_ming
5 years, 2 months agoPhoenix22
5 years, 2 months ago