Its been a while that I have been working with Oracle Database. Here is my query below.
We are running daily full backups at 5:00 PM and it completes at around 6:30 PM.
Suppose we have the backups for say 21st August, 22nd August. On 23rd August we need to do a point in time restore/recovery.
We restored the latest available control file backup (22nd August) and started database in mount state.
a) We we use the point in time as 4:00PM for 22nd August, which backup will it consider for restore and recovery.
b) If we use the recovery time as 5:30PM 22nd August, is it possible to complete the restore/recovery and open the database.
c) If we use the point in time as any time post backup completion (after 6:30 PM), will it be possible to complete the restore/recovery and open the database.
Apologies for the basic questions but SMEs need your expert guidance here.