Sam, Before calling the RMAN executable, set the UNIX environment variable NLS_DATE_FORMAT to the desired format, instead of the Oracle session variable after you're in RMAN. -Tim On Tue, 23 Jan 2007 15:38:48 -0500, Sam Bootsma wrote > I call my RMAN script from aUnix shell script. I have pasted parts of the > RMAN output below. Notethat I have changed nls_date_format to > ?yyyy-mm-dd-hh24-mi-ss'. Iexpected to see the date displayed in this format, > but instead I see the dateas ?23-JAN-07?. Can anybody tell me how I can get > the RMANlog file to show the date as 2007-01-23-13-27-14? Or even better, as > 2007-01-2313:27:14. > > BTW, RMAN threw errors whenI used ?:? in the time part of the date format, > that is why I havedashes there. > > Here is the partial outputfrom the RMAN log file. > > Recovery Manager: Release10.2.0.2.0 - Production on Tue Jan 23 12:14:01 2007 > > RMAN> connect target * > 2> connect catalog * > 3> run { > 4> sql "altersession set nls_date_format=''yyyy-mm-dd-hh24-mi-ss''"; > 5> sql "alter systemarchive log current"; > 6> allocate channel t1type 'SBT_TAPE'; > 7> send'NSR_ENV=(NSR_SERVER=X, NSR_DATA_VOLUME_POOL=TAPEDAILY)'; > 8> backup > 9> format'/LOG_%d_%T_%p_%s%t' > 10> (archivelog alldelete input); > 11> release channel t1; > 12> } > 13> > ? > sql statement: alter sessionset nls_date_format=''yyyy-mm-dd-hh24-mi-ss'' > sql statement: alter systemarchive log current > ? > Starting backup at 23-JAN-07 > ? > channel t1: starting piece 1at 23-JAN-07 > channel t1: finished piece 1at 23-JAN-07 > ? > channel t1: backup setcomplete, elapsed time: 01:40:37 > ? > Finished backup at 23-JAN-07 > > ? > > Sam Bootsma > Oracle Database Administrator > Information Technology Services > George Brown College > Phone: 416-415-5000 x4933 > Fax: 416-415-4836 > E-mail: sbootsma@xxxxxxxxxxxxxx > Tim Gorman consultant - Evergreen Database Technologies, Inc. website = http://www.evdbt.com email = tim@xxxxxxxxx mobile = +1-303-885-4526 fax = +1-303-484-3608