OraFAQ Forum: Backup & Recovery » Set NLS_DATE

Home » RDBMS Server » Backup & Recovery » Set NLS_DATE_FORMAT RMAN for Windows XP

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Set NLS_DATE_FORMAT RMAN for Windows XP [message #192527]

Tue, 12 September 2006 14:09

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

Report message to a moderator

Re: Set NLS_DATE_FORMAT RMAN for Windows XP [message #192541 is a reply to message #192527]

Tue, 12 September 2006 16:08

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

Report message to a moderator

Re: Set NLS_DATE_FORMAT RMAN for Windows XP [message #192810 is a reply to message #192541]

Wed, 13 September 2006 13:13

Henry_VA
Messages: 12
Registered: September 2006
Location: Northern VA

Junior Member

Thanks, ebrian, that works perfectly.

Report message to a moderator

Previous Topic:	norman recovery
Next Topic:	Datafile Missing...not able to connect

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 18:51:53 CDT 2024