RMAN NLS_DATE_FORMAT
Stanislav Sust, October 12, 2015 - 10:42 am UTC
Tom,
I call rman script save in rman catalog from EMC Networker wizard and I cannot use OS setting - export NLS_DATE_FORMAT.
I try to use sql 'alter session ...' but it is not working :
RMAN> run {SQL 'ALTER SESSION SET NLS_DATE_FORMAT="DD.MM.YYYY HH24:MI:SS"';
2> ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' MAXOPENFILES 1 PARMS='SBT_LIBRARY=/usr/lib/libnsrora.so';
3> BACKUP INCREMENTAL LEVEL 1 SKIP OFFLINE SKIP INACCESSIBLE DATABASE FORMAT 'df_%d_%U';
4> release channel CH1;}
sql statement: ALTER SESSION SET NLS_DATE_FORMAT="DD.MM.YYYY HH24:MI:SS"
allocated channel: CH1
channel CH1: SID=133 device type=SBT_TAPE
channel CH1: NMDA Oracle v8.2.1
Starting backup at 12-OCT-15
skipping datafile 5; already backed up 6 time(s)
skipping datafile 7; already backed up 6 time(s)
channel CH1: starting incremental level 1 datafile backup set
channel CH1: specifying datafile(s) in backup set