My Oracle Support Banner

After a switchover of a physical standby database, the initialization parameter AUDIT_TRAIL is not converted to DB in the new primary database (Doc ID 1494631.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.0 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

After a Data Guard switchover of a physical standby database, the initialization parameter AUDIT_TRAIL is not converted to DB in the new primary database.

Changes

A switchover was performed between a physical standby and a primary databases.

Initialy both primary and standby databases had the parameter audit_trailset to DB.

The ADG (Active Data Guard) was set up in standby database which set the audit_trail to OS in that standby, as expected.

After a switchover the primary became a standby and the standby became a primary. The parameter audit_trail had a value of OS in both databases.

Instead of retaining the value DB in the primary instance, it was changed by the Data Guard to audit_trail = OS.

Cause

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
Symptoms
Changes
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.