Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: backup & recovery
Precisely. Because your information to roll forward is stored in your online redo log. If you lost it and if it is not flushed to disk how do you want to restore it?
Martin
Alvin wrote:
>
> 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 Tue Jun 13 2000 - 00:00:00 CDT