Which statement is true about the loss or damage of a temp file that belongs to the
temporary tablespace of a pluggable database (PDB)?
A.
The PDB is closed and the temp file is re-created automatically when the PDB is opened.
B.
The PDB is closed and requires media recovery at the PDB level.
C.
The PDB does not close and the temp file is re-created automatically whenever the
container database (CDB) is opened.
D.
The PDB does not close and starts by using the default temporary tablespace defined for
the CD
A.
SQL> select * from DBA_TEMP_FILES;
select * from DBA_TEMP_FILES
*
ERROR at line 1:
ORA-01116: error in opening database file 203
ORA-01110: data file 203:
‘/opt/oracle/oradata/orcl/pdbmax/pdbmax_temp012015-04-11_03-03-38-AM.dbf’
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> alter pluggable database open;
Pluggable database altered.
SQL> select * from DBA_TEMP_FILES;
FILE_NAME
——————————————————————————–
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
———- —————————— ———- ———- ——-
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
———— — ———- ———- ———— ———- ———–
/opt/oracle/oradata/orcl/pdbmax/pdbmax_temp012015-04-11_03-03-38-AM.dbf
3 TEMP 20971520 2560 ONLINE
1 YES 3.4360E+10 4194302 80 19922944 2432
I think anser A does mean losing temporary file in PDB, cause to close PDB. this is not correct answer. PDB does not close automatically in the absence of temp file. it may start use CDB’s temp file because PDB does not necessarily to have temp file it can still share CDB’S temp file.
However reopening PDB will create temp file again for PDB.
I think its answer C, it would not be logical for a PDB to close after loss of a temp file
I agree.
C is the correct answer.
C:
If a temp file belonging to a PDB temporary tablespace is lost or damaged, and the user issuing the statement uses it, an error during the execution of SQL statements that require that temporary space for sorting occurs.
…
The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are automatically re-created. They are also automatically recreated at CDB startup.
Student Guide
Thanks Steve!
C is correct. from 11g temp datafile will be create automatically when db open. We can create new temp tablespace when db is open and assign it to db.
Student Guide:
“The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are NOT created automatically. They are automatically recreated at CDB startup.”
The correct answer is “C”.
C
C
C
D
Temporary Tablespaces
Management of the temporary tablespace in a CDB is unchanged from that of a non-CDB database.
A PDB can either have its owner temporary tablespace, or if it is created without a temporary tablespace, it can share the temporary tablespace with the CBD.
https://oracle-base.com/articles/12c/multitenant-manage-tablespaces-in-a-cdb-and-pdb-12cr1#temporary-tablespaces
Please crosscheck
D
C
Not D because the tablespace still exists just the tempfile is missing.
C
This article is truly a nice one it helps new web people, who are wishing for blogging.|
A & B are wrong, because the PDB will not close.
C is wrong.
If you start only the CDB the file will not be created,
you have to open the PDB for this purpose.
If the PDB starts automatically you will not see the difference.
D is correct.
The CDB-TEMP will be used until the PDB is reopened.
D
I’d stick to amezedan’s explanation.
I made large table x and removed the temp file and tried to select from it, I see the below error
SQL> select * from x order by 3 ;
select * from x order by 3
*
ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/temp.dbf’
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 7
So PDB did not user TEMP for CDB. and also see http://oracleinaction.com/share-cdb-temp/
then D is wrong.
after restart of PDB the file created again.
C is not accurate also because file is created when open PDB not CDB .
I do not know why oracle put strange answers , a lot of question do not have good answers. always we find errors in questions and answers.
Best Answer is C
[email protected]
C