Currently, I synchronize the standby database from primary database by copying archive logs from primary server to the secondary server. I do this activity daily. I have heard that there are automated process for this are available.
But the problem is that, the primary data gets corrupted, then the same will be replicated to the secondary standby database. This will make the standby database of no use.
Is there any way of automated process so that only the data to be synchronized to the standby database which is not corrupted in the primary database ?