The things that you can implement with dataguard in known..
There are modes, you should review them and think about a solution according to your needs ;
Dataguard Data Protection Modes:
Maximum Protection Mode : LGWR SYNC AFFIRM -- Primary database shuts down itself(Dataguard shuts it down) in case of a failure encountered writing its redo stream to one of remote standby redologs in all the standby databases.. This protection mode requires standby redolog files(sized as the same as primary) available in standby . Having 2 standby databases is recommended in this protection mode, as if 1 standby database fails, production will continue to work.
Maximum Availability Mode : LGWR SYNC AFFIRM -- Primary does not shut down itself in case of a remote write failure , but the primary operates in Maximum Performance mode till the error is fixes and then resumes operating in maxium Availability mode. This protection mode requires standby redolog files(sized as the same as primary) available in standby .
Maximum Performance Mode: Any failure in standby does not stop the primary from running. LGWR ASYNC or ARCH. This protection mode does not require standby redolog files available in standby, but having standby redolog files are recommended. This protection method has the minimal impact on primary performance and also note that, when the network is fast, the data protection provided with this method may reach the same level as the maximum availability mode.
Read this blog post as well ->
https://ermanarslan.blogspot.com/2016/03/rdbms-high-level-overview-of-dataguard.html
Locked
