ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam
Go to Exam

Exam 1z0-063 topic 1 question 194 discussion

Actual exam question from Oracle's 1z0-063
Question #: 194
Topic #: 1
[All 1z0-063 Questions]

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability.

  • A. Drop the TEMP tablespace, and then re-create it with new temp files.
  • B. Restart the database instance to create the temp file automatically.
  • C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
  • D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References:
https://docs.oracle.com/database/121/ADMIN/dfiles.htm
https://docs.oracle.com/database/121/BRADV/rcmcomre.htm
by AVD at March 3, 2019, 7:51 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
hilaire
3 years, 4 months ago
BD is correct
upvoted 1 times
...
Sugar
4 years, 4 months ago
After reading this again, i think the answer is AD. The question ask the “least” disruption. Restarting db instance is not considered as less disruption
upvoted 3 times
...
FelipeK
4 years, 10 months ago
Answer AD
upvoted 2 times
...
Kalinos20
4 years, 10 months ago
Answer BD
upvoted 1 times
...
sherifelia
4 years, 10 months ago
Answer BD
upvoted 1 times
...
AVD
5 years, 9 months ago
answer should be B and D C-> Wrong because Temp tablespace can not be taken offline, instead that we can take temp file offline.
upvoted 2 times
Sugar
4 years, 5 months ago
yeah you are correct. B D
upvoted 1 times
...
...
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.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago