Re: Changing Date Format in RMAN log file

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_at_georgebrown.ca
>  

Tim Gorman
consultant - Evergreen Database Technologies, Inc.

website = http://www.evdbt.com 
email   = tim_at_evdbt.com 
mobile  = +1-303-885-4526 
fax     = +1-303-484-3608
 

--
http://www.freelists.org/webpage/oracle-l