RE: Different Backups - A Comparartive analysis

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 13 Jan 2003 06:19:28 -0800
Message-ID: <F001.0052D994.20030113061928@fatcity.com>

Vivek - I believe you are off to a good start. I'm assuming you are considering the database to be in archivelogmode in all the scenarios.

   Also, keep in mind that export is not a valid sole backup method for a production database. There are many situations that having an export alone will not enable you to recover. However, export is an excellent supplement to the other backup methods.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, January 13, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L

Need to Do a Comparative analysis of General Characteristics of HOT , COLD , exp , RMAN
backups

What additional Headings can be Explored ?

Some Feadings below :-

1. Database Status during backup - UP / Down
2. Time of Backup
3. Restoration effort & time
4. Reovery facility
5. Dependency on Database Size
6. Backup Devices - Can exp be taken Directly on TAPES & Extracted therefrom confidently OR does ?
7. Ease of Backup
8. De-Skilling of Backup Job
9. Dependency on Oracle Software
10. Performance Overheads during Backup
11. Incremental Backups - Do HOT / Cold Backups allow any incremental Backups ? Is incremental Backup Disabled from 8i onwards for exp ?
12. Limitations - Compress/Splitting of exp files etc ?

--

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

Author: VIVEK_SHARMA
  INET: VIVEK_SHARMA_at_infosys.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.net
--

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). Received on Mon Jan 13 2003 - 08:19:28 CST