Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data time stamp after database recovery
"Valentin Minzatu" <valentinminzatu_at_yahoo.com> schrieb im Newsbeitrag
news:1172176922.495916.89900_at_h3g2000cwc.googlegroups.com...
> 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;
>
THANKS !!! Received on Thu Feb 22 2007 - 14:49:03 CST