Re: backup & recovery

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 Sat Jun 03 2000 - 00:00:00 CDT