Create Standby Database in Enterprise Manager Job Fails With ORA-12920: Database Already In Force Logging Mode
Last updated on SEPTEMBER 30, 2015
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
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.
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