I need to create a materialized view (MV) with auto refresh every hour. After I create it, a lot of redo logs are generated (10GB per hour). I think the solution is to recreate the MV in NOLOGGING mode.
Are there some problems with my DG database and with a second DG database in read only mode?
Can my RMAN backups restore fail, or do I need only to recreate the MV after a data recovery?