exam questions

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam

Exam 1z0-063 topic 1 question 87 discussion

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

Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

  • A. It fails because archive log files cannot be backed up using a connection to a PDB.
  • B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
  • C. It succeeds and all data files belonging to PD32_i are backed up along with the archive log files.
  • D. It fails because the pluggable clause is missing.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
chitter
3 years ago
https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1 Archived Redo Log Backups Redo is managed at the root container level. There is no concept of redo from the PDB perspective, but of course any changes in tablespaces owned by the root container or a user-defined PDB are protected by redo in the normal manner. As a result, you will never perform a PDB-level archived redo log backup, because there are no PDB-specific redo logs. Instead, you will do your archived redo log backups in the normal way from the root container. They can be done along with the database backups or as a separate operation, as shown below. $ rman target=/ RMAN> BACKUP DATABASE PLUS ARCHIVELOG; RMAN> BACKUP ARCHIVELOG ALL; Answer is B
upvoted 1 times
...
lollo1234
3 years, 11 months ago
C? Found this in the Docs: Create a full backup of the PDB including the archived redo log files. If RMAN backups of the PDB already exist, then these backups are usable after the PDB is migrated to another destination CDB. However, it is recommended that you back up the archived redo log files. The following command backs up the PDB when you are connected to the PDB as a local user with the SYSDBA or SYSBACKUP privilege: RMAN> BACKUP DATABASE PLUS ARCHIVELOG ALL TAG for_migration; Ref: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/backing-up-database.html#GUID-E5A3E523-C55C-4666-8334-81E7A224371B
upvoted 1 times
...
hemang_07
4 years, 9 months ago
B is the right answer
upvoted 3 times
...
Sugar
4 years, 11 months ago
C is correct. Note that the PLUS ARCHIVELOG clause performs the following: Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command Runs the BACKUP ARCHIVELOG ALL command. If backup optimization is enabled only backs up logs that have not already been backed up. Backs up files specified in the BACKUP command Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command Backs up any remaining archived logs including those generated during the backup
upvoted 1 times
...
joe_doe
5 years ago
Definitely B,PDB is same as non-CDB for user,so they won't know which kind of database will be backedup,it must be success
upvoted 2 times
...
rcgenilo27
5 years, 2 months ago
B is the correct answer
upvoted 1 times
...
FelipeK
5 years, 3 months ago
Correct Answer: B
upvoted 2 times
...
sherifelia
5 years, 4 months ago
answer B
upvoted 3 times
...
gracee
5 years, 5 months ago
answer should be B
upvoted 1 times
...
Sherry
5 years, 9 months ago
Should be C
upvoted 1 times
...
Jake
6 years ago
Should be A
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
Loading ...