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.
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.
Shutdown 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.
Explanation:
* 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.
C and E
C and E is incorrect.
Correct answer is A and E.
Temporary tablespace is never backed up in RMAN. No need of restoration and recovery.
You can create a new temp file and drop the old one.
or restart the CDB, temp file will be created automatically
Correct ans A and E
A E
I agree A and E are correct
I did a test…
A and E are correct!!!
E is correct: Temp file was created automatically
A is correct: I created a new temp file and droped the old one.
CDB$ROOT@ORCL> select tablespace_name from dba_temp_files;
ERROR at line 1:
ORA-01116: error in opening database file 201
ORA-01110: data file 201:
‘/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_b1gtg6p6_.tmp’
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
CDB$ROOT@ORCL> alter tablespace temp add tempfile;
Tablespace altered.
CDB$ROOT@ORCL> alter tablespace temp drop tempfile ‘/u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_b1gtg6p6_.tmp’;
Tablespace altered.
CDB$ROOT@ORCL> select tablespace_name from dba_temp_files;
TABLESPACE_NAME
——————————
TEMP2
TEMP
A,E
A,E
I did appear exam on Jan 18 and I passed.
are the actual questions VALID?
please in %
A, E
Demonstration:
http://blog.itpub.net/28552278/viewspace-1245581/
I adore this site – its so usefull and helpfull
CSGO http://www.ymn17.com/comment/html/index.php?page=1&id=79307
Total questions in Exam are 85. There are 2 sections.
51 questions for section 1(New Features for DBA).
And 34 questions for section 2(Key DBA Skills).
All questions do not have equal marks.
I passed the exams last week with 73% & 71%.
All questions are from this dump but the answers in the exam are randomized (changed). Study answers carefully, and use comments here to guide your answer choice. Just a few answers here are wrong. Saw additional 4-5 questions in exam. Which you all the best.
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
A , E should be the correct answer
Free dumps and mostly genuine answers
https://drive.google.com/drive/folders/0B-ob6L_QjGLpNjQta2dQSmFJLWs
Good luck
Hi,
Can you please send me the 1Z0-060 12c upgrade dump
It would be a great help.
Thanks,
Sravan
A E
C is wrong because Oracle does not backup temporary datafile.
AE
Hey Guys,
You can contact me at [email protected] for this dumps.