Re: Recovery From Hot Backup

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Tue, 3 Oct 2000 14:45:53 -0500
Message-ID: <8rdd05$qd3$1@news.gte.com>

If you loose a member of an online redo group...

Assuming you are in ARCHIVELOG mode, AND that you have multiple groups of redo with multiple redundant members, you simply restore your latest full hot backup ( or equivalent ) and apply all your archived redo up to the point of failure. Then allow the database to recover all committed transactions in the online redo members that are still available for each group.

Basically, you should never loose ALL your online redo. If you do, you could always recover up to the last archived redo log, then open RESETLOGS.

-Kevin
<perfect_golf_at_my-deja.com> wrote in message news:8rd8or$6ih$1_at_nnrp1.deja.com...
> Scenario: I do a hot backup every night which includes backing up all
> tablespaces, control files, archive log files & parameter file. The
> redo log files are not backed up. This is based on Oracles backup/
> recovery documentation.
>
> Question: If I loss all the online redo log file(s), how do I recover
> these file(s)???
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 03 2000 - 14:45:53 CDT