Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovery of DB -> online redo log ?
As well as what Howard told you,
you can reduce the window for potential loss by creating more but smaller
logs.
Mike
"Rob" <donaldduck_at_ducktown.usa> wrote in message
news:blm8bt$lfo$1_at_reader08.wxs.nl...
> Hi there,
>
>
> I have a question about recovery.
> I have a 8.1.7.4 DB running on Windows NT (i know, it's the boss who
like's
> it).
> I have 3 redolog group with 2 files each. Both files are local.
> These are archived to the local server.
> A job checks for new files and copies one to a remote server. From there
on
> tape.
>
> So in case of a crash / data loss, etc i have copies of all my archived
> redolog files on tape.
> Now for the ONLINE redolog files at the moment of crash ??
> Lets say i logswitch every 30 minutes.
> In a bad example we loose 29 minutes of work. Because it isn't archived
yet
> and lost in the crash.
>
> Can i do something about this ?
> In unix / linux i imagine you mount some drive and set a second archive
dir
> in the pfile.
> Under windows you cannot mount "MAP" a remote drive without being logged
on.
> Could i create a third redolog file with filename
> '\\\remoteserver\sharename\redo_1_c.log' ??
>
> When i ask oracle about this they simply say "Install RAC".
> We cannot afford it (yet).
>
> If you have any other suggestions, please post !!
>
>
> Thanks in advance,
>
> Robert
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
Received on Sun Oct 05 2003 - 14:35:32 CDT