We help IT Professionals succeed at work.

UTF8 / AL16UTF16 database rman duplication question.

Oscar Veloz
Oscar Veloz asked
I have a db (SOURCE) that is Oracle Enterprise Edition, and its national character set UTF8.

I have an Oracle Database Appliance on which I will create an Oracle EE DB (TARGET) to duplicate (RMAN) my source DB to, and during the creation of it I am presented with the option to choose either UTF8 or AL16UTF16 as my national character set.

Do they have to match? Both UTF8 for the duplication process to work?
Watch Question

Systems Administrator

The RMAN duplicate restores / duplicates the SOURCE db, so I will use UTF8.