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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Backups

RE: Backups

From: Steve McClure <smcclure_at_usscript.com>
Date: Thu, 03 Oct 2002 11:43:15 -0800
Message-ID: <F001.004DFDF4.20021003114315@fatcity.com>


RE: BackupsLots of folks here on the list can explain it, but really you would get more from the Oracle Backup and Recovery Manual. In short, you place your tablespaces in 'backup mode', one TS at a time is the prefered method. You backup the datafiles associated with the Tablespaces in backup mode, using cp or tar or dd or whatever you prefer. You end backup mode, perform a log switch, and backup all archived redo logs created during your backup. You do this, and you can restore your backup, and Oracle will, for the purposes of this response, magically recover your database.

Steve McClure
60% certified and counting
-----Original Message-----

  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Markham, Richard
  Sent: Thursday, October 03, 2002 11:03 AM   To: Multiple recipients of list ORACLE-L   Subject: RE: Backups

  It would be interesting to see how you would explain how either   cp or dd (which know nothing of archive log mode, or the concept   of hot backup, itself, none the less) is going to keep things   consistent, when these utilities themselves are for point in   time operations.

-----Original Message-----

  From: John Weatherman [mailto:john.weatherman_at_replacements.com]   Sent: Thursday, October 03, 2002 12:18 PM   To: Multiple recipients of list ORACLE-L   Subject: RE: Backups

  This doesn't sound right. Put the database in hot backup mode,   backup (whether using cp to a staging point like the poster here   is doing or straight to tape using dd or dump or some other utility),   come out of hot backup mode. Why wouldn't you be able to recover?

  John P Weatherman
  Database Administrator
  Replacements Ltd.

-----Original Message-----

  Sent: Thursday, October 03, 2002 10:18 AM   To: Multiple recipients of list ORACLE-L

  If you want to be able to use any OS backup for restore/recovery that   database must be closed when you do the backup. If it is not, you won't be
  able to recover.

  Just a thot,
  Ruth

  Robyn,
   We used the DD method on pre 7.1 oracle with RAW devices. It worked   fine except that it used a lot of tape dumping a raw device when only a   small portion was used. Using a dd command to place a copy of the data   on tape should not be a problem if a restoral is needed. The dd function   is just another OS method of copying data to a tape. I don't know for   sure but I think there might be some issues about transportability of   the dd tape.
  Other users will know about the transportability issues.   Ron
   ROR mm

  >>> Robyn_at_iTeamTech.com 10/02/02 08:08PM >>>   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).
--

  Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

  Author: Ron Rogers
    INET: RROGERS_at_galottery.org
  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).

--

  Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

  Author: Ruth Gramolini
    INET: rgramolini_at_tax.state.vt.us

  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).
--

  Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

  Author: John Weatherman
    INET: john.weatherman_at_replacements.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  INET: smcclure_at_usscript.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 Thu Oct 03 2002 - 14:43:15 CDT

Original text of this message

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