RE: RE: What are the common mistakes DBA do re...

Have found the following "interesting" cases -

1. For cold backups; DBAs were providing a list of files to the unix team to backup and would shut down the database. The List of files wasn't updated though more datafiles were added to the database.

2. Controlfile was not being backed up after a rman backup.

3. While using conventional backup; After end backup command, no log switch and no archive log backup was taken.

Joseph

"Bobak, Mark" <Mark.Bobak@il.proquest.com> wrote:

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@freelists.org 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@enkitec.com"randy.johnson@enkitec.com

_____

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@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

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

Joseph Amalraj

2007-07-04