Re: Oracle Database Backups using Legato

On 4/20/06, Sam Bootsma <sbootsma_at_gbrownc.on.ca> wrote:
>
>
>
> One of our user departments has an Oracle 10g database running on a Windows
> 2003 box. The ITS department performs the backups using Legato and the
> Legato Oracle Module. To the best of my knowledge, RMAN is not used for
> this particular database. I think it is a hot backup directly to tape, or
> maybe SAN storage.
>
>
>
> I know a plain and simple hot backups creates a worthless backup unless the
> tablespaces are put in backup mode or RMAN is used. The backup people
> believe the Legato Oracle Module will ensure the hot backup is good … but I
> am not so sure. I thought the Legato Oracle Module just provided an
> interface for the Oracle database (eg. RMAN) to use Legato Backup and still
> write directly to tape. I don't think the Legato Oracle Module ensures the
> backup is good. Can somebody confirm, and even better, clarify, my
> understanding of how Legato Oracle Module works with Oracle to perform
> backups? Also, is RMAN still needed for the backup to be good? I expect
> they are backing up both data files (open of course) and archived log files.

Your understanding is correct.

From Legato NetWorker Module for Oracle Administrator's Guide, Release 4.0:

<quote>
During the Oracle backup and restore operations, NetWorker Module for Oracle acts as an intermediary between the NetWorker server and RMAN. RMAN is the main Oracle utility for backing up, restoring, and recovering Oracle datafiles, control files, and archived redo log files. It stores information
about its operations in the control file of the backed-up database (the target database) and, optionally, in the Recovery Catalog on the Oracle Server host. </quote>

Regards,
Dimitre

--
http://www.freelists.org/webpage/oracle-l