Re: best solution for backup with archivelog mode
- From: sybrandb@xxxxxxxxx
- Date: Mon, 30 Apr 2007 16:13:16 +0200
On 30 Apr 2007 03:25:06 -0700, Andrea <netsecurity@xxxxxxxxxx> 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
.
- References:
- best solution for backup with archivelog mode
- From: Andrea
- best solution for backup with archivelog mode
- Prev by Date: Re: Particular GROUP BY sum requiring analytic function(s) -I guess...-
- Next by Date: Re: The Oracle 10g on Linux Glibc Problem
- Previous by thread: best solution for backup with archivelog mode
- Next by thread: Re: best solution for backup with archivelog mode
- Index(es):
Relevant Pages
|
