Exam 1z0-083 All QuestionsBrowse all questions from this exam
Question 128

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

    Correct Answer: B, C

    Control file backups can be created while connected to the root container because control files are database-wide, and this is where you would back them up. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT, allowing for centralized backup management in a multitenant environment.

Discussion
xRodgeOptions: BC

A - FALSE. The ARCH process backs up online redo logs (by creating Arch redo logs), never the DBA. DBAs backup Archive Redo Logs, not online redo logs. B - TRUE. Control files are DB wide - backing them up, from the Container Root, is exactly where you do this. C - TRUE. Part of the point of Multitenant is that you have control of all PDBs from the CDB level. D - FALSE. An application root container is still below the main Container, so you cannot administer control files from here. E - FALSE. For the same reason as above, you can only create control file backups from the Root Container. So, BC is correct.

ObserverPLOptions: BC

B and C no doubt

flaviogcmeloOptions: BE

I believe there are three correct answers to this question; b) obvious answer c) Tested in version 19.3: tablespace backup pdb1:tbs_name; e) Tested on version 19.3 connected to pdb1: backup current controlfile;

mporislavOptions: BC

B, C not D : when connected to application root PDB: RMAN> backup archivelog all; skipping archived logs when connected to a PDB E , also correct, you can create cf backup: backup current controlfile;

RinDOptions: BC

BC correct

_gio_Options: BC

three answers are correct BCE. I tested E in lab and it works, I agree with xRodge for A

vkraOptions: BC

B and C is correct

7206e44Options: BC

E: controlfile can be created in PDB, but can it be created in PDB$SEED?

antonica

E- FALSE, TESTED RMAN> BACKUP CONTROLFILECOPY all; Starting backup at 30-MAR-24 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=505 device type=DISK RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of backup command at 03/30/2024 16:43:06 RMAN-20220: control file copy not found in the repository

antonicaOptions: BC

BC i agree

ScottLOptions: BC

BE and C are correct A. Online Redo Log backups can be created while connected to the root container. FALSE - we don't backup online redo logs, we backup archived logs. ARCH backs up online redo B. Control file backups can be created while connected to the root container. TRUE - backup current controlfile; C. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT. TRUE - backup tablepace pdb1:t1; D. Archived Redo Log backups can be created while connected to an application root CDB. FALSE - "skipping archived logs when connected to a PDB" E. Control file backups can be created while connected to a nonroot container. TRUE - During tests, I am able to backup a controlfile while connected to a nonroot container

mtnetmakerOptions: BC

Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.12.0.0.0 SQL> SHOW PDBS CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PDB1 READ WRITE NO SQL> alter session set container=PDB1; Session altered. SQL> ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/control1.bak'; ALTER DATABASE BACKUP CONTROLFILE TO '/tmp/control1.bak' * ERROR at line 1: ORA-65040: operation not allowed from within a pluggable database SQL>

mtnetmaker

B and C

freemun05

1) RMAN> connect target "backup@pdb1 AS SYSBACKUP" target database Password: connected to target database: ORADB:PDB1 (DBID=1492547052) RMAN> backup current controlfile; Starting backup at 31-MAR-2022 07:51:08 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=279 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 31-MAR-2022 07:51:10 channel ORA_DISK_1: finished piece 1 at 31-MAR-2022 07:51:11 piece handle=+DATADISK/ORADB/A98B865CBFAF359CE0537F01A8C08251/BACKUPSET/2022_03_31/ncnnf0_tag20220331t075109_0.292.1100764271 tag=TAG20220331T075109 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 31-MAR-2022 07:51:11 2) C - wrong, read docs.

jackymak

C is true. Alternatively, you can remove the ambiguity by qualifying the PDB name with the tablespace name when connected to the root container. $ rman target=sys@cdb1 RMAN> BACKUP TABLESPACE pdb1:system, pdb1:sysaux, pdb1:users, pdb2:system; https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1#tablespace-and-datafile-backups

Eric_F

the question need creating RMAN backups, nor by SQL*Plus.

Aldrid

D incorrect: U must be connected to CDB root, not application root.

dunhillOptions: BD

I think BD

dunhill

RinD, mporislav, Aldrid are right. It's BC. I miss the key word "application" root.

navingupta52

BC are perfectly correct but I think even E is correct. I connected to a PDB on my system and backed up controlfile. target database Password: connected to target database: CRYPTODB:PDB2 (DBID=1223325248) RMAN> backup current controlfile; Starting backup at 29-JUN-21 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=402 device type=DISK channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 29-JUN-21 channel ORA_DISK_1: finished piece 1 at 29-JUN-21 piece handle=H:\ORACLE\ORACLE19C\FRA2\CRYPTODB\195AE5877EB842D6AD88571743F1FBA0\BACKUPSET\2021_06_29\O1_MF_NCNNF_TAG20210629T200025_JFPCN4YJ_.BKP tag=TAG20210629T200025 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 29-JUN-21