Dell Avamar for Oracle 19.10 User Guide

The restore of a database that contains datafiles that uses the UTF-8 character set fails with the following error messages:

channel c0: ORA-19870: error while restoring backup piece

ORCL_0vnahoeh_1_1ORA-19504: failed to create file
"/home/oracle/app/oracle/oradata/orcl/home/oracle/app/oracle/product/11.2.0/dbhome_1/home/oracle/app/oracle/product/11.2.0/dbhome_1/home/oracle/app/oracle/product/11.2.0/dbhome_1.dbf"

ORA-27040: file create error, unable to create file

Solaris-AMD64 Error: 2: No such file or directory failover to previous backup released channel: c0

RMAN-00571: =======================================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS =====
RMAN-00571: =======================================
RMAN-03002: failure of restore command at 05/09/2014 10:01:35
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

Oracle requires you to set the NLS_LANG environment variable to the correct language, territory, and character set when the following configuration settings are true:

• The operating system is in a locale other than English.
• The database contains datafiles that use the UTF-8 character set.