Re: Oracle backup to tape Please help....

Comments embedded

"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message news:3ee4fce2$0$18665$79c14f64_at_nan-newsreader-01.noos.net...
> hi from Paris
>
>
> this kind of strategy is secureless: imagine your hard disks begin to stop
> right during the copy to disk, of right before physical backup. In case of
> big disaster, you may lose all a day of work.
>
> backup strategies using stagging disks as deposit for robotics are always
a
> bad ideas. They presents a major spof: the disk himself.
>

Of course you backup to *DIFFERENT* disk(s)
> Data flow to backup should always be sent directly to tape drive, disks
are
> only coming for simpler restores.
>
> Two things to never lose data:
>
> - backup to tape every hours archived logs,
> - hot backup dbfiles directy to tape, including control an init.ora files.
>
> This done correctly, you cannot lose more than 1 hour of your customers
> work.
>

What if the tape drive is NEVER cleaned and/or the backup is ran WITHOUT VERIFY? What is the more dependable backup?

Regards

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address