Re: best solution for backup with archivelog mode

Andrea 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

http://tahiti.oracle.com
Search for "RMAN"

Nothing you are describing is best practice.

I would suggest you read the docs and then ask questions if there is are any.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org