I'm having this question regarding a restore scenario in RMAN:
A database is running in Archivelog mode. Full RMAN hot backups are taken, redologs are backed up with RMAN to tape. The application remains online while any backup is taken.
Enter this scenario:
01h30 Redologs are backed up to tape using RMAN
02h00 a Full backup starts
08h00 the Full backup ends (and it was 100% successfull)
08h05 ALL Redologs on disk, including multiplexed copies, are permanently lost. Additionally, one (1) regular datafile is lost.
Note the backup itself took a long time : assume that is normal. During that same time, there was activity (as stated above, the application was running), but there really was not much happening. Still, redologs were written in that period (the same redologs that were lost).
And this is the question I'm wondering now :
If we just restore the complete database, on purpose not specifying any time to restore to, it is correct to say the the restore will restore to a point in time, just after 02h00 ?