ADSM-L

SQL-BACKTRACK & ORACLE

2001-08-13 18:49:19
Subject: SQL-BACKTRACK & ORACLE
From: Thiha Than <tthan AT US.TIVOLI DOT COM>
Date: Mon, 13 Aug 2001 15:49:51 -0700
hi,

>Our oracle DBA claims that 'hot' incremental backups of Oracle takes as =
>long as 'hot' full backups using SQL-BACKTRACK. Instead he does weekly =
>full 'hot' backups of the database and backups of the redo logs thru the
=
>week.

>Is that how others using SQL-BACKTRACK and ORACLE do thier backups?


It's the same for backing up oracle databases using RMAN, incremental
takes almost as long as a full backup.  I have never used sql-backtrack
before so I cannot comment on it.  With RMAN, it has to scan through every
single Oracle data block to find the changed block.  So the incremental
backup will take a long time, but the amount of data sent through can be
significantly less.

regards,
Thiha
<Prev in Thread] Current Thread [Next in Thread>