RE: What are the common mistakes DBA do retarding backup & Recovery?

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Wed, 4 Jul 2007 08:45:54 -0500
Message-ID: <000c01c7be41$a5abcd40$01077d0a@scraunch>

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_at_enkitec.com"randy.johnson_at_enkitec.com
 

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
 


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 04 2007 - 08:45:54 CDT