ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam
Go to Exam

Exam 1z0-083 topic 1 question 65 discussion

Actual exam question from Oracle's 1z0-083
Question #: 65
Topic #: 1
[All 1z0-083 Questions]

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.)

  • A. Data file 24 can be recovered only while connected to PDB2.
  • B. Data file 24 can be restored and recovered while connected to CDB$ROOT.
  • C. Data file 24 can be restored only while connected to CDB$ROOT.
  • D. Data file 24 can be restored only while connected to PDB2.
  • E. Data file 24 can be recovered while connected to PDB2.
  • F. Data file 24 can be recovered while connected to CDB$ROOT.
Show Suggested Answer Hide Answer
Suggested Answer: BEF 🗳️
by taotsumiau at June 11, 2020, 11:21 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
ald85
Highly Voted 5 years ago
BEF. The 'Only' word makes invalid the similar sentence.
upvoted 19 times
...
_gio_
Most Recent 2 years, 1 month ago
Selected Answer: BEF
I'm sure BEF. Backup database on CDB will backup all PDBs
upvoted 1 times
...
j_tw
2 years, 1 month ago
Selected Answer: BEF
I don't like 'only', 'always', 'must' words at this exam...
upvoted 2 times
Guhborges
2 years ago
Me neither! B,E,F For sure
upvoted 1 times
...
...
ScottL
2 years, 2 months ago
Selected Answer: BEF
BEF correct
upvoted 1 times
...
jareach
2 years, 5 months ago
Selected Answer: BEF
BD are mutually exclusive.
upvoted 1 times
...
Manojx
2 years, 6 months ago
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
upvoted 1 times
7206e44
1 year, 2 months ago
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.
upvoted 1 times
...
yumyummyyum
1 year, 10 months ago
Hi, I share your thinking, but they all said BEF. Any difference for recovering just a data file?
upvoted 1 times
...
...
Bio12345
3 years, 4 months ago
Selected Answer: BEF
BEF is agreed by most
upvoted 2 times
...
Neil107
3 years, 11 months ago
BEF. Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question.
upvoted 2 times
...
Neil107
3 years, 11 months ago
BEF. Restoration AND recovery can be done by CDB$ROOT. Recovery can be done by CDB$ROOT or the PDB in question.
upvoted 1 times
...
janw
4 years, 11 months ago
bef https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#tablespace-and-datafile-backups
upvoted 4 times
jackymak
2 years, 7 months ago
This one is better: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#pdb-recovery
upvoted 1 times
...
...
cerebro2000x
4 years, 11 months ago
BEF for me
upvoted 2 times
...
julica
4 years, 11 months ago
BEF- is the winner
upvoted 4 times
julica
4 years, 11 months ago
-- 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 ....
upvoted 3 times
VinayakChandra
1 year ago
Did you try 'recover datafile 21' as well from PDB ?
upvoted 1 times
...
...
...
taotsumiau
5 years, 1 month ago
I had tested this one on my lab. The answer should be BCF.. Any comment?
upvoted 3 times
flaviogcmelo
3 years, 8 months ago
Watch for the "only" it makes the diference. In my opinion the right answers are B, E and F.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel