Re: best solution for backup with archivelog mode

On Apr 30, 3:25 am, Andrea <netsecur..._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

Personally, I've found that some redundancy in backing up archivelogs has meant the difference between "oh, gee, bad backup, just use another one" and what would've been "oh, oh..." Keeping a few days of arcs around has meant the difference between "oh, just cp some to the standby" and "oh man, now I've gotta dig through backups."

DLT's can really suck at times. Especially with unattended backups that have tapes changed (or not) by many different monkeys.

jg

--
@home.com is bogus.
http://edp.org/monkey.htm