A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file ‘/u0l/app/oracle/oradata/ORCL/temp01.dbf’
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?
A.
Drop the tenpOi.dbf file, and then re-create the temp file.
B.
Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.
C.
Shut down the database instance, start up the database instance in mount state, create a
new temporary tablespace, and then open the database.
D.
Take the temporary tablespace offline, recover the missing temp file, and then bring the
temporary tablespace online.
E.
Create a new temporary tablespace and assign it as the default to the user.
b AND E
In my opinion it could also be D.. Can you explain why you choose for E <–
“Take the temporary tablespace offline, recover the missing temp file, and then bring the
temporary tablespace online.”
As we don’t take backup for temp tablespace, there is no scenario where we can recover it.
SO I guess D option is wrong.
BE
B, E tested
B & E – anyday
This looks ambigious for me. However from the exam sake
A&B for me. as
E is wrong as per me Because; dropping the default and adding an new one is fine but some users who were using the old name(when it was default TBS) as in HARDCODED application will have some disturbance.
BTW, A & B do the job as required.
Correct answers B and E.
A (Incorrect): Very last Temp file can not be dropped.
B (Correct): First create Temp file in TEMP tablespace and then remove entry from controlfile for physically dropped Tempfile.
C (Incorrect): This scenario does not require to bounce database. Anyway merely bouncing database would automatically create lost Temp file.
D (Incorrect): Temporary tablespace can not be made offline. In try to do this one will receive below error,
‘ORA-03217: invalid option for alter of TEMPORARY TABLESPACE’.
E (Correct): Specific to this scenario this option suits it, since other users of database are mentioned here.
Small correction,
E (Correct): Specific to this scenario this option suits it, since other users of database are not mentioned here.
BE
BE
C is not correct – C and E do the same (creating NEW tablespace). But database restart is not needed, so I choose E. DBA_Contributer explanation is very good.
BE