Create Standby Database in Enterprise Manager Job Fails With ORA-12920: Database Already In Force Logging Mode (Doc ID 2059847.1)

Last updated on SEPTEMBER 30, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager Cloud Control, during new build of standby database, the create standby database job fails during step "Source Validation" with the following error:

ORA-12920: the database is already in force logging mode

The ORA-12920 error is seen in the alert.log, emoms.log/trc and also in the job step.

Changing logging status on the database side by issuing ALTER DATABASE FORCE LOGGING or ALTER DATABASE NO FORCE LOGGING before resubmitting the job does not make any difference.

Cause

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 hundreds of Community platforms