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 mª¿ªm



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