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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.



Relevant Pages

  • best solution for backup with archivelog mode
    ... We make backup of whole database in offline mode every week on ... library DLT, and archivelog+flashback is enabled on DB, in this case ... and after i can use last redolog (available on ours SAN ...
    (comp.databases.oracle.server)
  • Re: best solution for backup with archivelog mode
    ... i need some advisors for management backup and archivelog mode. ... We make backup of whole database in offline mode every week on ... library DLT, and archivelog+flashback is enabled on DB, in this case ... and after i can use last redolog (available on ours SAN ...
    (comp.databases.oracle.server)
  • Re: best solution for backup with archivelog mode
    ... i need some advisors for management backup and archivelog mode. ... We make backup of whole database in offline mode every week on ... library DLT, and archivelog+flashback is enabled on DB, in this case ... and after i can use last redolog (available on ours SAN ...
    (comp.databases.oracle.server)