NLS_NCHAR_CHARACTERSET Of Mounted Standby after Active Duplicate is Not Reflecting Correct Value

Last updated on OCTOBER 17, 2016

Applies to:

Symptoms

RMAN duplicate from active database does not change/update the NLS_NCHAR_CHARACTERSET parameter when the standby database is mounted.

Primary Database: 

PARAMETER                                                 VALUE

-------------------------------------------------------------
NLS_CHARACTERSET                                   UTF8
NLS_NCHAR_CHARACTERSET                       UTF8

Standby Database:

Before Duplicate:
PARAMETER                                                 VALUE
-------------------------------------------------------------------
NLS_CHARACTERSET                                    US7ASCII
NLS_NCHAR_CHARACTERSET                       AL16UTF16

After Duplicate when standby is mounted:
PARAMETER                                                  VALUE
--------------------------------------------------------------------
NLS_CHARACTERSET                                     UTF8
NLS_NCHAR_CHARACTERSET                        AL16UTF16

Before doing RMAN duplicate for Standby Db, the value of NLS_NCHAR_CHARACTERSET was set to AL16UTF16.   Thus after the duplicate completes, the value remained the same when the standby database is mounted.  Thus the RMAN duplicate is not setting the NLS_NCHAR_CHARACTERSET parameter value to that of the primary database.  

Changes

 Created physical standby database using rman duplicate from active database. 

Cause