Re: backup & recovery

Really??
if i do recover database in database mounted status, those data in redo log can't be rollforward??

Alvin Huang

Martin Haltmayer ¼¶¼g©ó¤å³¹ <39392476.5A4CCF7B_at_0800-einwahl.de>...
>Yes, you can loose data even if did not use "nologging" operations.
>
>Do the following:
>
>alter system switch logfile;
><do some transactions that are committed but not yet flushed to disk by
 DBWR.
>You can achieve this by setting your logging options so high that no data
 is
>flushed before a redo log switch. >
>shutdown abort
>
>Then physically remove all members of the group of the current redo log.
>
>There is no way to replay the lost current redo log's entries.
>
>Martin
>
>
>
>zameer2_at_my-deja.com wrote:
>>
>> Hi,
>>
>> In archive log mode is there any chance that you might loss committed
>> data ?
>>
>> Thanks for your feedback.
>>
>> Zameer
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
>
Received on Mon Jun 05 2000 - 00:00:00 CDT