11gR2 RMAN and NLS_COMP/NLS_SORT
We have a new 11.2.0 database that the users wanted to have case-insensitive sorting on. As such, we set the following:
I did discover that if I turned off the NLS_COMP and NLS_SORT (setting back to BINARY) at the database level then RMAN would not hang anymore. Oracle Support was able to reproduce this and provide a workaround whereby they set these to BINARY in RMAN before running the backup. I decided to try it:
ALTER SYSTEM SET NLS_COMP=LINGUISTIC SCOPE=SPFILE;We later ran into some problems with this database. One was ORA-04031, the other was that RMAN was hanging.
ALTER SYSTEM SET NLS_SORT=BINARY_AI SCOPE=SPFILE;
I did discover that if I turned off the NLS_COMP and NLS_SORT (setting back to BINARY) at the database level then RMAN would not hang anymore. Oracle Support was able to reproduce this and provide a workaround whereby they set these to BINARY in RMAN before running the backup. I decided to try it:
0