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 AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Goal

 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

RMAN>RECOVER DATABASE NONLOGGED BLOCK

This document explains the steps for the same.

 

Solution

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

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


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