Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Oracle Database Backups using Legato

Oracle Database Backups using Legato

From: Sam Bootsma <sbootsma_at_gbrownc.on.ca>
Date: Thu, 20 Apr 2006 12:20:54 -0400
Message-ID: <CC7ECEDD58772D41A44D87EBED4A77A1B19FF8@TCCEML02.gbrownc.on.ca>


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.  

This entire situation is more political than it is anything else. I have suggested a test recovery be performed to validate the backup, but I didn't get feedback to make me believe that is going to happen. Also, the political nature of this issue means they don't me involved.  

Thanks for your responses!    

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_gbrownc.on.ca <mailto:sbootsma_at_gbrownc.on.ca>  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 20 2006 - 11:20:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US