1

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?

1

Redo log is crucial in data guard environment. Hence we enable force logging before configuring data guard at the database level. So, no matter whether you use NOLOGGING clause or not the operation will be logged and replicated in the standby site.

When you perform a DML or DDL operation using the NOLOGGING or UNRECOVERABLE clause, the standby database is invalidated and may require substantial DBA administrative activities to repair. You can specify the SQL ALTER DATABASE or SQL ALTER TABLESPACE statement with the FORCE LOGGING clause to override the NOLOGGING setting. However, this statement will not repair an already invalidated database.

NOLOGGING or Unrecoverable Operations

You might be interested in this thread from the asktom site.

Dataguard and Nologging

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.