Re: exp and archive available.... recover table

Preston wrote:

> Alexander Skwar wrote:
>
> > I now "played" a bit and am (again G) not so convinced that RMAN
> > would be my best solution. What advantage does RMAN offer over
> > backing up the "hot" database .dbf files in combination with the
> > archived redo log files? I'm only interested in doing backup to
> > disk. At least for now.
>
> To do a hot backup, you need to put the tablespace in backup mode.
> While it's in backup mode, any activity will result in the writing of
> the complete changed blocks, plus the changes themselves, to redo.
> This doesn't happen with RMAN, so there's less overhead. It doesn't
> sound like that would be much of a concern for you though, given that
> the database isn't normally being used when you do the backups.

Bad form, but if you're on 10g, RMAN can also apply changes to an image copy backup, & delete the now-obsolete archive files. This will make recovery faster, which could be important for you if the database dies during the day.

-- 
Preston.