Re: Minimizing backup induced downtime

Alexander Skwar wrote:

<<snipp>>

>
> > - you start an Online Backup with Rman after that
> >
> > Restore :
> > - restore your Filesystem Snapshot from 23:00
> > - Recover your Database until time 23:00
> >
> > What is your Problem ?
>
> Problem: Somebody could, at least in theory, come in between 23:00
> and the time I start the RMAN backup and change something. That's
> what I meant with "odd chance". Yes, that chance is very small, but
> it's not 0. To get it to 0, I'd need to shutdown the application. Or
> I need to make sure, that the two actions "create snapshot" and "start
> RMAN backup" occur at the very same time.
>
> Example: At 23:00, there are files "a", "b" & "c" in the vault directory.
> At 23:30 (or 23:00:01, which doesn't make a difference, as we're talking
> theory here), I start RMAN backup. Problem: At 23:15, somebody added
> a file. This file is NOT part of the snapshot. The database, however,
> says that this file should be present. But according to the filesystem,
> it's not present.
>
> To solve that problem, I need to make sure that no user can fiddle with
> the files. The only way to do that, is to shut down the application.
>
> Alexander Skwar

please lookup the meaning of "recover until time" in the manual.

regards

Stefan Kapitza Received on Fri Jul 13 2007 - 02:43:46 CDT