Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

The correct answer is D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using. In 19c, you can actually flashback a PDB from a restore point even if it's not clean: When using restore points, you can perform a flashback database operation either to a CDB restore point, PDB restore point, PDB clean restore point, or PDB guaranteed restore point…

Perform Backup and Recovery

Question

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1. How do you achieve this?

Exhibit

Options

AExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using
BExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL
CExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL
DExecute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using
EThis cannot be done due to the lack of a clean restore point.

How the community answered

(55 responses)

A
13% (7)
B
2% (1)
C
5% (3)
D
76% (42)
E
4% (2)

Explanation

In 19c, you can actually flashback a PDB from a restore point even if it's not clean: When using restore points, you can perform a flashback database operation either to a CDB restore point, PDB restore point, PDB clean restore point, or PDB guaranteed restore point. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing- flashback-dbpitr.html#GUID-C1215E86-9A7B-4EC9-9777-2A18BD627394

Topics

#FLASHBACK PLUGGABLE DATABASE#restore point#PDB recovery#point-in-time recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice