My Oracle Support Banner

How to Resolve ORA-1578 /ORA-26040 Nologging operation in 12.2 on Standby database (Doc ID 2378500.1)

Last updated on DECEMBER 20, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


 This Article is Useful for Customer who don't want the Primary database to be in Force logging mode in Primary- Standby configuration  and would want to have  to their application perform certain No logging operation to have some performance benefit at the same time ensure that Standby database doesn't get affected By No logging Corruption Message.




 A Nologging operations indicates that a DML operations like Insert/update/dlete have not been logged into the redo logfile.
If Force logging is not enabled on Primary database ,when MRP is run on Standby database and it comes across
no logging operation it will mark the Block as Corrupt
and proceed with the recovery.When Such blocks are
accessed it reports the Ora-1578/ORA-26040.

12.2 new Feature allows us to recover such no logging operations using Rman command ,without having to restore a fresh copy of datafile from primary or Enabling Force logging on Primary database.

This can be achieved by using the new Rman command


This document explains the steps for the same.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.