Re: Are offline backups an option, or a neccessity?

Muli Koppel <mkoppel_at_barakitc.co.il> wrote:

]If I'm wrong about my following statements - do not hesitate...
]
]1. Tablespaces are taking offline during Hot Backup. Any DML changes during
]the copying of the tablespace's underlying files are written to the Redo Log
]Files.
]
]2. To Guarantee 100% of sucessful Hot Backup, these Redo Logs should be backed
]up as well.
]
]3. Therefore, we're doing Hot Backups - and only hot backups - everyday, doing
]the
]following :
]
] - taking each tablespace offline & backing its files
] - and then :
] - find out current log file
] - alter system switch log file
] - alter database backup control file to 'backup area'
] - copying switched log file to 'backup area'
]
]This way a complete database resotre is possible, rolling forward only archive
]logs that
]were created since the very beginning of the backup untill crash has happened.
]

You need to copy *ALL* the archived logs to the backup area. Complete logs can be generated during the backup, so just copying the switched log at the end can cause you to miss a log in your backup.

-- 
 ,-,_|\   George Dau,                                             __
/    * \  Unix (Solaris, DEC Unix, Linux), NT, Oracle, Internet. (OO)
\_,--\_/  Home: gedau_at_pobox.com          Work: gedau_at_mim.com.au ( \/ )
      v   WWW:  http://pobox.com/~gedau                          W--W

Food for spambots: 
yesleads_at_answerme.com pageplus_at_answerme.com bulkmail_at_rlyeh.com
publisher_at_rlyeh.com selfhelp_at_answerme.com richl_at_stockscape.com
info_at_stockscape.com sales_at_SendAd.com support_at_SendAd.com
macsupport_at_SendAd.com webmaster_at_SendAd.com xiaocf_at_cybersurf.com.sg
sowell_at_bizzy.net dey_at_algonet.se betters2_at_usa.net
comments_at_martianconsulate.com tracyb813_at_sprintmail.com
orders_at_amazon.com help_at_amazon.com info_at_amazon.com
catalog-typos_at_amazon.com feedback_at_amazon.com suggestions_at_amazon.com
marketing_at_amazon.com associates_at_amazon.com press_at_amazon.com