Re: RMAN Recovery Question

From: ErkkaH <evs_at_poista.pp.inet.fi>
Date: Mon, 18 Apr 2005 11:59:38 GMT
Message-ID: <KiN8e.157$N_.142@read3.inet.fi>

Usually archiving every 30min should suffice? Then the max amount of transactions you will lose in recovery will be <30min.

I think that there are ways of applying online redo logs on top of archived ones, but that's not done using RMAN. Also there's the risk of applying corrupt redo's since they resided on the failed media (?)

EricH

<amerar_at_iwc.net> kirjoitti
viestissä:1113505245.986936.85800_at_o13g2000cwo.googlegroups.com...
>
> Let me restate my question, as I think people have been misled:
>
> If my disk drives crash and I recover my database, what happens to the
> transactions that were in the online redo logs, but not yet archived?
>
> How does RMAN apply those transactions?
>
> Again, I perform an UPDATE, commit it, and 5 minutes later we lose a
> drive.
>
> Ok, I use RMAN and restore using my backup and my archive logs. Now,
> what happens to the commited transaction I did, which is not yet in the
> archive logs????
>
> Arthur
>
Received on Mon Apr 18 2005 - 06:59:38 CDT