Home > Archive > Oracle Server > July 2005 > Re: RMAN question: How do you connect SCN# with real time









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: RMAN question: How do you connect SCN# with real time
StefanKapitza

2005-07-28, 7:23 am



EdwardNing (nospam) wrote:
> I would like to test a incomplete recovery, but when I do a "list backup of
> archivelog all", I can get scn# plus timestamp, but the time stamp is only
> "26-Aug-2005", with no hour:mi info, how could I know which archivelog to
> apply in this case?
>
> It is Oracle 9201 on windows.
>
> Thanks for your help.

try setting nls_date_format in you env before calling rman e.g.

>set nls_date_format=DD.MM.YYYY HH24:MI:SS

regards.

Stefan Kapitza

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com