Which three are true about Database Point-in-Time Recovery? (Choose three.)
Which three are true about Database Point-in-Time Recovery? (Choose three.)
Database Point-in-Time Recovery (DBPITR) requires the database to be in MOUNT state because the database must be restored from the backup to the desired point-in-time, which involves rolling forward through the archived logs (B). The database must be in ARCHIVELOG mode because redo logs are necessary to roll forward changes from the restored data files to the target time or SCN (D). After the recovery, the database must be opened with RESETLOGS to reset the online redo logs and synchronize them with the recovered database state (F).
Response: B,D,F Archivelog mode and mount state are needed (B, and D) After the restore you need to open with reset logs (F) E is discarted because sequence number also is valid https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%20time.
Agree, BDF
Agreed, BEF A is wrong To perform Database Point-in-Time Recovery not only must have FLASHBACK DATABASE ON
Sorry I meant BDF
agree BDF
BDF C can also use RESTORE POINT and SEQUENCE THREAD
MRP process is for a Dataguard recovery process. The FLASHBACK and PITR are separate features and independent of each other and hence A is out and D (You can recover a DB to a sequence number which is PITR) and E are incorrect as well Correct answer is BDF!
Certain prerequisites must be met to perform database point-in-time recovery (DBPITR). This includes the following: Your database must be running in ARCHIVELOG mode. You must have backups of all data files from before the target SCN for DBPITR and archived logs for the period between the SCN of the backups and the target SCN. https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-performing-flashback-dbpitr.html#GUID-2CF6EEFB-0344-4FD6-9BBB-F2D241172BC6
BDF correct
i think bdf
Must be in the MOUNT state, archivelog is needed to roll forward the transactions since the data files backup, and open resetlogs is needed because (not all) information in the online redo log is longer relevant.
C is wrong, it's not in a data guard standby database environment
BDEF all 4 points are necessary to perform point in time recovery. Tricky one :) B. DB should be in mount mode D. Must be archive log mode. E. we need to specify SCN or Time to perform incomplete recovery F. need to be open in resetlogs.
E is not necessary. you can recover until cancel
E is wrong, You can recover to an SCN, time, log sequence number, or restore point.