Which three are true about Database Point-in-Time Recovery? (Choose three.)

The correct answer is B. The database must be in MOUNT state when performing Database Point-in-Time Recovery. D. The Database must be in ARCHIVELOG mode. F. The database must be open RESETLOGS after Database Point-in-Time Recovery. 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%2…

Perform Backup and Recovery

Question

Options

AThe database must have FLASHBACK DATABASE ON to perform Database Point-in-Time
BThe database must be in MOUNT state when performing Database Point-in-Time Recovery.
CDatabase Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
DThe Database must be in ARCHIVELOG mode.
EThe target point for the recovery must be specified as a stime or System Change Number (SCN).
FThe database must be open RESETLOGS after Database Point-in-Time Recovery.

How the community answered

(38 responses)

A
3% (1)
B
71% (27)
C
8% (3)
E
18% (7)

Explanation

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%2 0point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20t

Topics

#Point-in-Time Recovery#RESETLOGS#MOUNT state#ARCHIVELOG mode

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice