EXPORT vs. Hot Physical Backup

2001-05-03 Thread Chris Rezek

Which is a better way to back up a database - use EXPORT/IMPORT or
physical datafile backups?

Chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chris Rezek
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).



RE: EXPORT vs. Hot Physical Backup

2001-05-03 Thread Koivu, Lisa
Title: RE: EXPORT vs. Hot Physical Backup





Yes. 


Er, both, that is. 


What is your target MTTR (mean time to recovery)? There's a lot to consider other than just the obvious question below.  I take both daily hot backups and daily exports.

 
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess


[EMAIL PROTECTED]
 
 NeoMedia
 
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com <http://www.neom.com> 
www.paperclick.com <http://www.paperclick.com> 
www.qode.com <http://www.qode.com> 
 
P a p e r C l i c k . c o m <http://www.paperclick.com/home.htm> 
 



 Enter Your PaperClick Code Here!
 
 



-Original Message-
From: Chris Rezek [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 3:30 PM
To: Multiple recipients of list ORACLE-L
Subject: EXPORT vs. Hot Physical Backup



Which is a better way to back up a database - use EXPORT/IMPORT or
physical datafile backups?


Chris
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chris Rezek
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California    -- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).





Re: EXPORT vs. Hot Physical Backup

2001-05-04 Thread nlzanen1


Hi,


Ever tried to export a let's say 50Gb database, let alone import it again??

I'd say the export utility should only be used to recover an accidentally
dropped/corrupted table and datafile backup (either hot, or if you have the
luxury, cold) is the way for backup & Recovery of entire database.


Jack


   
  
Chris Rezek
  
 
ck.com>  cc:   
  
Sent by: Subject:     EXPORT vs. Hot Physical Backup   
  
[EMAIL PROTECTED] 
  
om 
  
   
  
   
  
03-05-2001 
  
21:30  
  
Please respond 
  
to ORACLE-L
  
   
  
   
  



Which is a better way to back up a database - use EXPORT/IMPORT or
physical datafile backups?

Chris
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Chris Rezek
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).




=
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
=





--