Re: data time stamp after database recovery

From: Bud <tulsadum_at_gmx.de>
Date: Thu, 22 Feb 2007 21:40:57 +0100
Message-ID: <erkv4p$3k1$1@online.de>

sorry - forgot :

database version is 9.2.0.5

"Bud" <tulsadum_at_gmx.de> schrieb im Newsbeitrag news:erkuvl$367$1_at_online.de...
> 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
>
Received on Thu Feb 22 2007 - 14:40:57 CST