Re: Backups

From: Robyn Anderson Sands <Robyn_at_iTeamTech.com>
Date: Wed, 02 Oct 2002 20:18:18 -0800
Message-ID: <F001.004DEE20.20021002201818@fatcity.com>

Thank you for the response - I especially liked (& agreed with) the rant. You expressed many of the same concerns that I have, but this is a small operation and there's a lot to clean up. The application was installed in the system schema, the users all had 'SYSTEM' for their temporary tablespace, dual had 121 rows in it, backup was copying the wrong $ORACLE_HOME, the database and configuration files were in 'unusual' locations and the developer uses a where clause to sequence his results instead of specifying 'order by'. Did I mention there's no test server?

Maybe I'll get them on RMAN eventually, and I will be testing the recovery process, but for now, I'll just be happy to get a complete backup on tape. If anyone is aware of potential pitfalls to watch out for until the situation can be improved, I'd appreciate add'l input.

Robyn

Tim Gorman wrote:

> I've relied on "dd", mainly when working with "raw" devices.  "dd" is
> probably one of the oldest commands in the UNIX lexicon.  It's just another
> way to get the job done...
> 
> <soapbox rant>
> RMAN is a *much* better solution.  After all, how are these exports, backup
> scripts, and what-not going to check the database for block corruption?  For
> archived redo logfile corruption?  How will someone be able to determine how
> many backups are on tape for each datafile and archived redo logfile?  Can
> you do trial restores, to test what's on tape?  Will any restore/recovery
> scenarios be scripted?
> </soapbox rant>
> 
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 02, 2002 6:08 PM
> 
> 
> 

>>Hello,
>>
>>I need some info about backups. I am working on a customer site, and
>>have implemented both exports and hot backups. Both jobs copy to a
>>separate mount point, and a job scripted by another individual then
>>moves the files to tape.
>>
>>Here's the problem - he's using a dd command, primarily because it
>>provides a succinct output he can email to non-technicals. The file
>>system is built on a 12 disk A1000 array. We've provided him with a
>>ufsdump script, but he's doesn't want to use it. Can the system be
>>recovered from this tape? Has anyone ever relied on a dd for a daily
>>backup method? The system is Oracle 9i on Solaris 8.
>>
>>Robyn
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Robyn Anderson Sands
>> INET: Robyn_at_iTeamTech.com
>>
>>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>>San Diego, California -- Mailing list and web hosting services
>>---------------------------------------------------------------------
>>To REMOVE yourself from this mailing list, send an E-Mail message
>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>the message BODY, include a line containing: UNSUB ORACLE-L
>>(or the name of mailing list you want to be removed from). You may
>>also send the HELP command for other information (like subscribing).
>
>

-- 
Robyn Anderson Sands
iTeam Technologies, Inc.
Office: 404.816.6920
Mobile: 404.234.4873

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robyn Anderson Sands
  INET: Robyn_at_iTeamTech.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Oct 02 2002 - 23:18:18 CDT