Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> data time stamp after database recovery
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:38:14 CST