Q128. 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?
- A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
- B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
- C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
- D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
- E. This cannot be done due to the lack of a clean restore point.
Xem thêm:
- Managing constraints | Sử dụng Constraints trong SQL
- Q89 View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?
- Tạo Database mới bằng DBCA trong Oracle database 19c
- Pmon là gì?
- Clone database, duplicate database – Restore Oracle Database to New Server using Rman