Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN question: How do you connect SCN# with real time

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

From: StefanKapitza <skapitza_at_volcanomail.com>
Date: 28 Jul 2005 05:24:55 -0700
Message-ID: <1122553494.962324.179570@g14g2000cwa.googlegroups.com>

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 Received on Thu Jul 28 2005 - 07:24:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US