Re: best solution for backup with archivelog mode

On 30 Apr 2007 03:25:06 -0700, Andrea <netsecurity_at_tiscali.it> wrote:

>Hi,
>i need some advisors for management backup and archivelog mode.
>
>We make backup of whole database (10g) in offline mode every week on
>library DLT, and archivelog+flashback is enabled on DB, in this case
>is possible delete the oldest redolog archived on disk before backup
>offline?
>
>So, on DLT there are all data and redologs required for restore until
>last week, and after i can use last redolog (available on ours SAN
>storage) for recovery DB. It's correct?
>
>Or i need to preserve all redolog files?
>
>thanks!
>bye
>Andrea

As usual, the purpose of this forum is not provide CBTs for Oracle free of charge. Actually the CBTs are already available, they are called 'documentation'.
Obviously, one of the 'smartest' things you could do is to delete your archivelogs *prior* to a cold backup, as you outline above. However, *after* a *proper* cold backup, the archives are irrelevant. That was true way back in the late 80's with Oracle 6, and still is.

-- 
Sybrand Bakker
Senior Oracle DBA