If my Primary database happen to crash, and if i have a STANDBY DATABASE setup, is it possible to recover completely.
Suppose, if i have a 5MB sized online redolog member, and my Primary database crashes, when it was halfway through, what about the commited changes which were present in the online logs, (since it has not been archived). When i activate the standby these changes are not present in the archive. Is it possible to recover these changes as well with the standby setup.
If you can atleast mount your primary (depending on the type of DB crash) and swith the logs a couple of times - this should create the archive logs. You can manually transport them on the standby and apply before opening the standby DB.