rman备份 ORA-12713

1.环境：

[root@single19 ~]# cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 7.9 (Maipo)
[root@single19 ~]# su - oracle
Last login: Fri Aug  2 10:40:38 CST 2024 on pts/4
[oracle@single19 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Aug 2 11:02:17 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> 

SQL>
2.现象
rman备份报错 ORA-12713: Character data loss in NCHAR/CHAR conversion

RMAN> backup as compressed backupset archivelog all format '/$backup_path/${backup_date}_arc_%s_%p' tag="full_arc";
Starting backup at 02-AUG-24
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=8 RECID=3 STAMP=1175942689
input archived log thread=1 sequence=9 RECID=4 STAMP=1175942784
input archived log thread=1 sequence=10 RECID=5 STAMP=1175943152
channel ORA_DISK_1: starting piece 1 at 02-AUG-24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/02/2024 10:52:34
ORA-12713: Character data loss in NCHAR/CHAR conversion
RMAN> 

3.解决
ORA-12713: Character Data Loss In NCHAR/CHAR Conversion (Doc ID 2322626.1)

[oracle@single19 ~]$ export NLS_LANG=AMERICAN_AMERICA.UTF8
[oracle@single19 ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Fri Aug 2 10:56:35 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1699360900)

RMAN> backup as compressed backupset archivelog all format '/$backup_path/${backup_date}_arc_%s_%p' tag="full_arc";

Starting backup at 02-AUG-24
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=143 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=8 RECID=3 STAMP=1175942689
input archived log thread=1 sequence=9 RECID=4 STAMP=1175942784
input archived log thread=1 sequence=10 RECID=5 STAMP=1175943152
input archived log thread=1 sequence=11 RECID=6 STAMP=1175943410
channel ORA_DISK_1: starting piece 1 at 02-AUG-24
channel ORA_DISK_1: finished piece 1 at 02-AUG-24
piece handle=/home/oracle/rman_backup/§Y0802_arc_12_1 tag=FULL_ARC comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 02-AUG-24
Starting Control File and SPFILE Autobackup at 02-AUG-24
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2024_08_02/o1_mf_s_1175943412_mbrlqnjl_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 02-AUG-24
RMAN>