Exam 1z0-083 topic 1 question 44 discussion

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

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

BDF C can also use RESTORE POINT and SEQUENCE THREAD

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.