Today i had a smaller problem registering a newly created database in a rman catalog. The only unusual thing was that the database was using a unicode character set.
RMAN failed with:
[oracle@rac02a ~]$ rman target / catalog rman/rman@rman Recovery Manager: Release 11.2.0.3.0 - Production on Wed Feb 12 05:31:49 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA11 (DBID=781875003) connected to recovery catalog database RMAN> show all; starting full resync of recovery catalog RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of show command at 02/12/2014 05:31:57 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of full resync command on default channel at 02/12/2014 05:31:57 ORA-29275: partial multibyte character
As you can see the database was using Unicode:
[oracle@rac02a ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Feb 12 05:32:23 2014 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select * from nls_database_parameters; NLS_CHARACTERSET AL32UTF8
So i changed the environment to match the character set of the database:
[oracle@rac02a ~]$ export NLS_LANG=GERMAN_GERMANY.AL32UTF8
And… Problem solved!
[oracle@rac02a ~]$ rman target / catalog rman/rman@rman Recovery Manager: Release 11.2.0.3.0 - Production on Mi Feb 12 05:32:53 2014 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Mit Ziel-Datenbank verbunden: ORA11 (DBID=781875003) Verbindung mit Datenbank des Recovery-Katalogs RMAN> show all; Vollständige Neusynchronisation des Recovery-Katalogs wird begonnen Vollständige Neusynchronisation abgeschlossen RMAN-Konfigurationsparameter für Datenbank mit db_unique_name ORA11 sind: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/nfs/backup/rman/ORA11/%F'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COPY; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/nfs/backup/rman/ORA11/%U'; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/nfs/backup/rman/ORA11/backup/snapcf_ORA11.f';