For conventional hot backups. For cold you would, to keep the info that hasn't been archived yet. Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Sent: Wednesday, July 04, 2007 11:58 AM To: randyjo@xxxxxxxxxxxxx; ORACLE-L Subject: RE: [QUAR] RE: What are the common mistakes DBA do retarding backup & Recovery? This is less common, as more and more folks move to RMAN, but, for conventional backups, don't backup the online redo logs! -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Randy Johnson Sent: Wed 7/4/2007 9:45 AM To: 'ORACLE-L' Subject: [QUAR] RE: What are the common mistakes DBA do retarding backup & Recovery? Putting it in and knowing how to backup but not knowing how to use it to recover. Also, I would think the "backup database" command might be misleading to most DBA's. It does not do a "switch logfiles" for you at the end of your backup. Better to use command "backup database plus archivelog [all] [delete input]". Or just know that you must "switch logfile" at the end to flush remaining transactions out of your redo log files. Randy Johnson Sr. Technical Consultant Enkitec, LLP Office ..... 817-255-3580 Mobile .... 817-564-6583 Email ..... HYPERLINK "mailto:randy.johnson@xxxxxxxxxxx"randy.johnson@xxxxxxxxxxx _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Syed Jaffar Hussain Sent: Wednesday, July 04, 2007 7:23 AM To: ORACLE-L Subject: What are the common mistakes DBA do retarding backup & Recovery? Hello List, I would like hear from you about the common mistakes by most of the DBAs do regarding the backup and recovery. I would think of the following: 1. Never testing their backups. 2. No good backup and recovery policies. 3. Afraid of using RMAN or Making benefits of RMAN I would really like to know if there are any other points than what I specified above. -- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA HYPERLINK "http://jaffardba.blogspot.com/"http://jaffardba.blogspot.com/ HYPERLINK "http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain "htt p://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ------------------------------------------------------------------------ ---- ------ "Winners don't do different things. They do things differently." No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.14/885 - Release Date: 7/3/2007 10:02 AM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.476 / Virus Database: 269.9.14/885 - Release Date: 7/3/2007 10:02 AM -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l