I have a normal situation where we have 3 Redo Groups (A,B & C) with 1 member (100 MB) each and database is also in Archive log Mode.
In normal scenarios whenever there is redo log switch, there will be a archive file generated and if we have all backups and archive files we can have our database recover till the point we have archive logs.
My question is - when writing to redo log group C (A & B has been archived already), let say 50 MB is written and database crashes, so definitely C group has not been archived yet.
So is it like, while recovering my database again on a different server, i will be losing 50 MB of data? or my understanding is wrong.
Is there any way we can also get that 50 MB of data somehow?