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