Examine these queries and their output:
After a system crash, an instance restart and an attempted opening of the PDBs result in:
Which two are true? (Choose two.)
Exam 1z0-083 All QuestionsBrowse all questions from this exam
Question 27
Correct Answer: A, C
Data file 24 belongs to PDB1, not PDB2, so the recovery of data file 24 can be performed while PDB2 is open since PDB2 is unrelated to PDB1. Additionally, the data file can be recovered while the CDB$ROOT and PDB$SEED are opened, indicating that the CDB does not need to be closed for the recovery process.
Discussion
danitoOptions: DE
D E. Becareful the tablespace afected is system
smartvanOptions: AC
A and C. Datafile 24 belongs to PDB1. A. It can be recovered while CDB while PDB2 is opened, as it belongs to PDB1. C. the datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount state.
YennismOptions: AC
A, C. Remember that datafile belongs to PDB1. And CDB can be in OPEN or MOUNT state to restore de datafile of PDB2.
rashedptdbaOptions: AC
Ans: is A,C. Tested on my LAB.
HalewarOptions: AC
AC for me
chefdbaOptions: AC
AC = correct answers Take note: DATA FILE 24 is for PB1
acesonlyOptions: AC
TL;DR: I've just tested, the correct answers are A and C. The explanations are below: A: Since PDB1 is the one missing the data file 24, the recovery is possible while PDB2 is opened, i.e. PDB1 is unrelated to PDB2. C: The data file 24 can be recovered while the CDB$ROOT and PDB$SEED are opened (or while both are MOUNTED). (Not B): The data file 24 recovery can also be done while CDB is MOUNTED; option B is too restrictive and, therefore incorrect. (Not D): For the data file 24 recovery, the CDB should be OPENED or at least MOUNTED, otherwise, the recovery is not possible (when shut down). (Not E): Since PDB1 is the one missing the data file 24, the recovery is possible regardless of the PDB2; PDB2 may be open or closed, it's all the same, so the option E is too restrictive and, therefore incorrect.
Emperor11Options: AC
ERROR en linea 1: ORA-01157: no se puede identificar/bloquear el archivo de datos 70 - consulte el archivo de rastreo del DBWR ORA-01110: archivo de datos 70: '/u02/app/oracle/oradata/ORCL/pdb1/ORCL/0B35DE71576F30A2E063F038A8C0 6E99/datafile/o1_mf_system_lpcnc7r6_.dbf' SQL> select name, open_mode from v$containers; NAME OPEN_MODE --------------- ---------- CDB$ROOT READ WRITE PDB$SEED READ ONLY NEWPDB READ WRITE PDB1 MOUNTED restore datafile 70; recover datafile 70; SQL> alter pluggable database all open; Base de datos de conexion modificada. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 NEWPDB READ WRITE NO 5 PDB1 READ WRITE NO
auwiaOptions: DE
Yes: D and E because the tablespace is SYSTEM.
dancymonkeyOptions: AC
A and C for me. DE > Think simple, Is there necessary to close PDB2 and CDB just to recover PDB1?
YennismOptions: AC
Datafile 24 belongs to odb PDB1 the datafile belongs to PDB1 and CAN be recovered while CDB is opened or in mount
LEOC71Options: AC
Tested: 19c RU 19.20 SQL > startup SQL> alter pluggable database all open; ERROR at line 1: ORA-01157: cannot identify/lock data file 9 - see DBWR trace file ORA-01110: data file 9: '/u02/oradata/CDB2/PDB10/system01.dbf' RMAN > restore datafile 9; RMAN> recover datafile 9; SQL> ALTER PLUGGABLE DATABASE pdb10 OPEN;
musafirOptions: DE
D E Since it's SYSTEM tablespace, otherwise it would be A C
_gio_Options: DE
SYSTEM tablespace so CDB must be in mount state
jareachOptions: AC
Suggested BD are mutually exclusive.
ManojxOptions: AC
A and C are correct. It doesn't matter if tablespace to be recovered in SYSTEM. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-35D290AC-CC01-4984-93D6-AE41A3D0D3B6
hilaireOptions: AC
AC is the correct answer i test it