RMAN DUPLICATE CHANGES DB_NAME DB_UNIQUE_NAME TO UPPERCASE FOR CLONE DATABASE (Doc ID 2050095.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

 RMAN DUPLICATE always changed DB_NAME / DB_UNIQUE_NAME parameter value to UPPERCASE, even with below attempts:

+ In aux init<SID>.ora, mention db_name = db_unique_name = "lower_case_name"

+ In DUPLICATE command, mention :

DUPLICATE TARGET DATABASE TO "lower_case_db_name" ......

+ Setting explicit value for spfile clause of DUPLICATE command:

DUPLICATE TARGET DATABASE TO "lower_case_db_name".....
....
SPFILE
..
..
  set db_name="lower_case_db_name"
  set db_unique_name="lower_case_db_unique_name"

+ Also, single quote (') or double quotes (") doesn't make any difference in results.

Changes

 RMAN DUPLICATE is performed.

 

Example Script with lower case name for db_name and db_unique_name:

 

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