Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data time stamp after database recovery
On Feb 22, 3:38 pm, "Bud" <tulsa..._at_gmx.de> wrote:
> Hi,
>
> i just made a copy of database <prod> onto another box.
>
> On the new box media recovery (recover database until time
> '2007-01-31:11:15:00';) terminated successfully !
>
> Also "alter database open noresetlogs" terminated successfully.
>
> How can i query the latest time stamp ('2007-01-31:11:15:00') ?
>
> Select first_time from v$log
> only shows
>
> FIRST_TIME
> ---------------
> 31-JAN-07
> 31-JAN-07
> 31-JAN-07
> 31-JAN-07
>
> Thanks,
>
> bud
ALTER SESSION SET NLS_DATE_FORMAT='dd-mon-yyyy hh24:mi:ss'; SELECT * FROM v$log; Received on Thu Feb 22 2007 - 14:42:02 CST