Re: Backups

OK, Gene, you asked for it. :)

The context of your message suggests that a hot backup is somehow more likely to be corrupted than a cold one.

I hate to resurrect an old flame war, but...

No, I take it back. I don't hate it a bit. ;)

There aren't many occasions that call for a cold backup.

I'm just curious what you believe a cold backup is buying you that a hot backup won't deliver.

Jared

On Thursday 03 October 2002 14:54, Gene Sais wrote:
> wow, never a cold backup for any os,oracle, application upgrades? i prefer
> to shutdown everything, backup the filesystems, let the vendor have his
> way. if he screws up, its much easier to restore a complete filesystem
> than a corrupted database. cold backups are a good thing. i sleep good at
> nite :) soon, rman will be another backup method in my toolbox. but when
> that happens, i can see hot backups going away but cold backups will still
> be needed on occassion.
>
> >>> rgramolini_at_tax.state.vt.us 10/03/02 04:33PM >>>
>
> 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
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, October 03, 2002 9:08 AM
>
>
> 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: Jared Still
  INET: jkstill_at_cybcon.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).