Database Backup and Recovery (MOSC)

MOSC Banner

Database is 12.2.0.1 with optimizer at 11.2.0.4 - Unable to create standby database due to disk grou

edited Oct 12, 2018 5:03AM in Database Backup and Recovery (MOSC) 2 commentsAnswered

I have a primary RAC database version 12.2.0.1 with a standby RAC database created with Active Data Guard.

We encountered a bug that required setting optimizer_features_enable=11.2.0.4.

Recreating the standby database is failing with:

released channel: a4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 10/04/2018 08:02:59

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of sql command on clone_default channel at 10/04/2018 08:02:59

RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database

ORA-00201: control file version 12.2.0.0.0 incompatible with ORACLE version 11.2.0.4.0

ORA-00202: control file: '+DUMMY_DG/njwprds/standby.ctl'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center