Re: Different Backups - A Comparartive analysis

To add to your list:

1. Is an additional volume of redo generated, resulting solely from being in backup mode?
2. Is backup capable of any other purpose, such as checking for corruption in database blocks and/or archivelog files?
3. Additional hidden costs of integrating with tape subsystem (i.e. additional integration with media-management software)?
4. Is a consistent restore even possible when backup occurs while database is being actively updated? (this is not the same as "database status up/down")

Another question: should SQL BackTrack be included for consideration?

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, January 13, 2003 5:58 AM

>
> 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: Tim Gorman
  INET: Tim_at_SageLogix.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).