Doesn't hurt to backup online redologs, but I wouldn't restore them. They contain the most recent commited transactions, so if you replace them with copies made with last backup, you lose current data (and may have issues w/ controlfiles too). -----Original Message----- From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA Sent: Saturday, October 02, 2004 4:40 AM To: oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx Subject: [askdba] Question in HOT BACKUP Hi, I just appeared in an interview. When I was asked which filese I will copy for hot backup, I said redo too. Cause I think they can help us always to recover database upto point of time. I was pulled a lot, but my only question that if not redo then how will you recover yr DB upto point of failure, stopped the arguements. M I true in this case? I have done expoerts in hot backups in production database. Can anyone clear my doubts? If u copy couple datafiles in hotback with begin backup, n yr DB crashes... what will happen? Assume that an archive log file is generated every 30 minutes and my DB crashed after 15 minutes of Last Archive file generated. Can I go without REDO Log File ??? - Chirag ************************************************************************************** The information contained in this email is privileged and confidential information intended only for the use of the individual or entity named as recipient. If the reader is not the intended recipient, please be notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please do not disclose this communication to any other person. Please notify us immediately by telephone and return the original to us at the address indicated above. Thank you This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.