Re: Rman Backup-Files

=?ISO-8859-15?Q?Bj=F6rn_W=E4chter?= <bwc_at_p3-solutionsKILL_SPAM.de> wrote in news:5f15m6F3aaj58U1_at_mid.dfncis.de:

> Hi all,
>
> I'm using Enterprise Manager to backup my 10g Oracle DB on
> Linux. Once a week there is a Full Backup with the options:
>
> Use as the base of an incremental backup strategy = checked,
> Backup Mode = Online Backup,
> Also back up all archived logs on disk = checked,
> Delete all archived logs from disk after they are successfully
> backed up = checked,
> Delete obsolete backups = checked.
>
> Backup folder is /opt/oracle/flash_recovery_area
>
> Each day there is an incremental backup with the
> following settings:
>
> Incremental Backup (Level 1) = checked
> Refresh the latest datafile copy on disk to the current time using
> the incremental backup = unchecked
>
> Everything is running well but I have the problem:
> I don't know which files I have to copy to my backup
> server to restore the database in the cases of a crash.
>
> In my restore tests it sometimes it looks like I also need
> to backup the archive log files written during the backup
> process. Is this true?
> Is there a easy way to figure out which archive log files
> are also needed?
>
>
> Thanks Björn
>
>

The recovery uses archive logs to restore updates which executed during the backup. If you backup your archivelog files after the online backup then you have a reasonable backup. Please check that the backup includes the controlfiles.

Andy Received on Wed Jul 04 2007 - 06:28:25 CDT