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.)
A.
Data file 24 can be recovered while PDB2 is opened.
B.
Data file 24 must be recovered while the CDB is opened.
C.
Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.
D.
Data file 24 cannot be recovered while the CDB is opened.
E.
Data file 24 must be recovered while PDB2 is closed.
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.
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.
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
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
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.
danito
Highly Voted 4 years, 3 months agosmartvan
Highly Voted 3 years, 3 months agoauwia
Most Recent 7 months, 3 weeks agoacesonly
8 months, 3 weeks agodancymonkey
1 year agoYennism
1 year, 1 month agoEmperor11
1 year, 1 month agoLEOC71
1 year, 2 months agomusafir
1 year, 4 months ago_gio_
1 year, 9 months agojareach
1 year, 12 months agoManojx
2 years, 1 month agohilaire
2 years, 5 months agoHalewar
2 years, 9 months agoYennism
3 years agochefdba
3 years, 3 months agorashedptdba
3 years, 4 months ago