A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB.
Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)
To restore and recover data file 24 of PDB2 with RMAN, given that the only backup was created while connected to CDB$ROOT, it is possible to perform the restoration and recovery while connected to CDB$ROOT because the backup was taken at this level. Additionally, recovery operations can be performed from the root container or the specific PDB. Therefore, data file 24 can be restored and recovered while connected to CDB$ROOT, and it can also be recovered while connected to PDB2.
BEF. The 'Only' word makes invalid the similar sentence.
BEF- is the winner
-- connect with RMAN directly to PDB: [oracle@rac1 admin]$ rman target sys/oracle_4YOU@PDB1931 ... Version 19.6.0.0.0 ... RMAN> restore datafile 21; Starting restore at 06-AUG-20 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=259 instance=tst1932 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00021 to /u01/app/oracle/test_pdb1.dbf channel ORA_DISK_1: reading from backup piece +FRA/TST193/A82132332AEF5FE9E0538044AB0AB63C/BACKUPSET/2020_08_06/nnndf0_tag20200806t154747_0.335.1047743269 channel ORA_DISK_1: piece handle=+FRA/TST193/A82132332AEF5FE9E0538044AB0AB63C/BACKUPSET/2020_08_06/nnndf0_tag20200806t154747_0.335.1047743269 tag=TAG20200806T154747 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 Finished restore at 06-AUG-20 ....
Did you try 'recover datafile 21' as well from PDB ?
bef https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#tablespace-and-datafile-backups
This one is better: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#pdb-recovery
I had tested this one on my lab. The answer should be BCF.. Any comment?
Watch for the "only" it makes the diference. In my opinion the right answers are B, E and F.
BEF for me
BEF. Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question.
BEF is agreed by most
I don't like 'only', 'always', 'must' words at this exam...
Me neither! B,E,F For sure
BEF. Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question.
Per this, you must connect to CDB as target, not to PDB. Undo Mode - Shared Connect as TARGET to ... CDB root https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/backing-up-and-recovering-cdbs-and-pdbs.html#GUID-B6EF3A32-18B6-4CDC-B668-4C7B5084F371
Hi, I share your thinking, but they all said BEF. Any difference for recovering just a data file?
But the document is for PITR recovery, not complete, right? As for Restore, I don't think undo is used for restore operation, so undo being shared has nothing to do with DB behavior.
BD are mutually exclusive.
BEF correct
I'm sure BEF. Backup database on CDB will backup all PDBs