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: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 04 Oct 2002 05:18:24 -0800
Message-ID: <F001.004E08D2.20021004051824@fatcity.com>


Dennis,

I guess you just gotta have faith after a complete test of various types of recovery that the software works. Once it passes all your tests, and you are comfortable that it orks as advertised, it's just a matter of going for it.

I am also convinced that Oracle support is able to help with Rman recovery as long as you use the software in an approved manner. This is one reason that I always stress to people on this list to use Oracle as the documentation says to use it - like the discussion the other day about putting indexes on SYS objects. Stuff like this gets you in trouble sooner or later.

Cold backups are a good thing for the installed software. Stuff like the OS system files, Oracle software etc.

But, in my view, we (as DBA's) just don't have the luxury anymore of taking a database offline for a backup - the costs (both in real $$'s and politically) are just too high. Especially when we are provided tools that are reliable. And Rman has entered this category.

Just my 2 cents.

Tom Mercadante
Oracle Certified Professional

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

Sent: Friday, October 04, 2002 12:08 AM
To: Multiple recipients of list ORACLE-L

Ruth, Tom, or anyone

   So what is the final checklist before you take a deep breath and stop cold backups. I have successfully run a disaster recovery test, but after so many years of the comfort of a cold to go back to, it sorta takes you back.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

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

Sent: Thursday, October 03, 2002 3:33 PM To: Multiple recipients of list ORACLE-L

I don't do them either, 4.5 years here. Ruth
----- Original Message -----

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 03, 2002 4:17 PM

I haven't done nor recommended a cold backup in 3 years since I've been using Rman. Just not needed anymore.

Tom Mercadante
Oracle Certified Professional

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

Sent: Thursday, October 03, 2002 3:14 PM To: Multiple recipients of list ORACLE-L

I still prefer cold backups when performing full OS backups.

>>> RROGERS_at_galottery.org 10/03/02 02:28PM >>> Lest we not forget the archivelogs also during this backup procedure. Ron

>>> rgramolini_at_tax.state.vt.us 10/03/02 01:53PM >>> I forgot about alter tablespace begin backup; etc. I am spoiled, I use rman
to do online backups. No problem with recovery! Ruth
----- Original Message -----

To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, October 03, 2002 12:18 PM

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 -- Maili
ng 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: 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: 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: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.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: 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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.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). Received on Fri Oct 04 2002 - 08:18:24 CDT

Original text of this message

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