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: data time stamp after database recovery

Re: data time stamp after database recovery

From: Bud <tulsadum_at_gmx.de>
Date: Thu, 22 Feb 2007 21:49:03 +0100
Message-ID: <erkvk1$4bb$1@online.de>

"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

Original text of this message

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