Oracle Exam 1Z0-063 Topic 7 Question 45 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 45
Topic #: 7

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. (Choose two.)

ADrop the TEMP tablespace, and then re-create it with new temp files.

BRestart the database instance to create the temp file automatically.

CTake the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.

DAdd a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Show Suggested Answer

Suggested Answer: B, C

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 My at May 04, 2022, 05:13 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!