Topic: 1z0-083 topic 1 question 128

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

A.
Online Redo Log backups can be created while connected to the root container.
B.
Control file backups can be created while connected to the root container.
C.
The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
D.
Archived Redo Log backups can be created while connected to an application root CDB.
E.
Control file backups can be created while connected to a nonroot container.

Re: 1z0-083 topic 1 question 128

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.

Re: 1z0-083 topic 1 question 128

B and C no doubt

Re: 1z0-083 topic 1 question 128

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

Re: 1z0-083 topic 1 question 128

BC i agree

  • _gio_
  • New member
  • Offline

Re: 1z0-083 topic 1 question 128

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

Re: 1z0-083 topic 1 question 128

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

  • vkra
  • New member
  • Offline

Re: 1z0-083 topic 1 question 128

B and C is correct

Re: 1z0-083 topic 1 question 128

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;

Re: 1z0-083 topic 1 question 128

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>

Re: 1z0-083 topic 1 question 128

B and C

Re: 1z0-083 topic 1 question 128

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.

Re: 1z0-083 topic 1 question 128

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

Re: 1z0-083 topic 1 question 128

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

Re: 1z0-083 topic 1 question 128

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

Re: 1z0-083 topic 1 question 128

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;

  • RinD
  • New member
  • Offline

Re: 1z0-083 topic 1 question 128

BC correct

Re: 1z0-083 topic 1 question 128

I think BD

Re: 1z0-083 topic 1 question 128

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

Re: 1z0-083 topic 1 question 128

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