Home » RDBMS Server » Backup & Recovery » Set NLS_DATE_FORMAT RMAN for Windows XP
icon6.gif  Set NLS_DATE_FORMAT RMAN for Windows XP [message #192527] Tue, 12 September 2006 14:09 Go to next message
Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA
Junior Member
Hi,
My Oracle 10g rel 2 RMAN seems to display the date format as 'DD-MON-YY' and I want it to display the date as 'MON DD, YYYY HH24:MI:SS' by setting 2 env variables before invoke RMAN from DOS. For example:
C:\DOS> set NLS_LANG=american
C:\DOS> set NLS_DATE_FORMAT='MON DD, YYYY HH24:MI:SS'
C:\DOS> rman target sys/sys@orcl10r2

But RMAN still display the date format as 'DD-MON-YY'. Did I miss something?
Cool
Re: Set NLS_DATE_FORMAT RMAN for Windows XP [message #192541 is a reply to message #192527] Tue, 12 September 2006 16:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Set it without the single quotes:

C:\>set NLS_DATE_FORMAT=MON DD, YYYY HH24:MI:SS

C:\>echo %nls_date_format%
MON DD, YYYY HH24:MI:SS



Re: Set NLS_DATE_FORMAT RMAN for Windows XP [message #192810 is a reply to message #192541] Wed, 13 September 2006 13:13 Go to previous message
Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA
Junior Member
Thanks, ebrian, that works perfectly.
Previous Topic: norman recovery
Next Topic: Datafile Missing...not able to connect
Goto Forum:
  


Current Time: Wed Dec 07 05:09:24 CST 2016

Total time taken to generate the page: 0.13441 seconds