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

Exam 1z0-060 All Questions

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

Exam 1z0-060 topic 1 question 1 discussion

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

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file /u01/app/oracle/oradata/CDB1/temp01.tmp
ORA-27037: unable to obtain file status
Identify two ways to rectify the error. (Choose two.)

  • A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
  • B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
  • C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
  • D. Shut down the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
  • E. Shut down the database instance and then restart the CDB and PDBs.
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️
* Because temp files cannot be backed up and because no redo is ever generated for them, RMAN never restores or recovers temp files. RMAN does track the names of temp files, but only so that it can automatically re-create them when needed.
* If you use RMAN in a Data Guard environment, then RMAN transparently converts primary control files to standby control files and vice versa. RMAN automatically updates file names for data files, online redo logs, standby redo logs, and temp files when you issue RESTORE and RECOVER.
by xeyeta at May 16, 2024, 7:47 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
MunirDBA
1 month, 2 weeks ago
Selected Answer: AE
Answer A It's a safe and no restart required and generally restart are is not good practice or it is un bearable. Answer E It is also an option if restart is bearable, moreover it is the easy way for lazy DBAs.
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