Re: Hotbackup without a standby?

Presumably you have off-box, if not off-site, backups of your datafiles and controlfiles?

A quick bit of shell scripting (or batch file editing) and you can easily arrange for off-box (or off-site) backups of your archivelogs.

Put the two together, and you have a very recoverable database, regardless of what happens to the host box. If disaster strikes, you've probably lost the current redo... but even with Standby Database that's probably true, since there's no archive of the current log.

Archivelogs are the only thing standing between you and major data loss. They are, in that respect, extremely useful. I'd hazard a guess and say that 90+% of all production databases run in archivelog mode. Of those, maybe 20% at best have standby's.

Regards
HJR "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uu1ytnv1g.fsf_at_verizon.net...
> On 27 Aug 2001, galenboyer_at_hotpop.com wrote:
>
> > If you don't have a standby, does archive logging get less
> > useless?
>
> I meant useful, not useless.
>
> To me, you still can recover to the last redo log, so it is still
> quite useful, but if the machine that the instance is running
> craps out, was the archive logging solution not really helpful?
>
> --
> Galen Boyer
> It seems to me, I remember every single thing I know.
Received on Mon Aug 27 2001 - 16:01:25 CDT