Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 8bit
Subject: RE: [QUAR] RE: What are the common mistakes DBA do retarding backup & Recovery?
Date: Thu, 5 Jul 2007 10:10:29 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B031C2E8D@jax-mbh-01.jax.crowley.com>
In-Reply-To: <AA29A27627F842409E1D18FB19CDCF2708B66E58@AABO-EXCHANGE02.bos.il.pqe>
Thread-Topic: [QUAR] RE: What are the common mistakes DBA do retarding backup & Recovery?
From: <Joel.Patterson@crowley.com>
To: <Mark.Bobak@il.proquest.com>,
 <randyjo@sbcglobal.net>,
 <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: Joel.Patterson@crowley.com

For conventional hot backups.

For cold you would, to keep the info that hasn't been archived yet.

Joel Patterson
Database Administrator
joel.patterson@crowley.com
x72546
904  727-2546

-----Original Message-----
From: oracle-l-bounce@freelists.org
[mailto:oracle-l-bounce@freelists.org] On Behalf Of Bobak, Mark
Sent: Wednesday, July 04, 2007 11:58 AM
To: randyjo@sbcglobal.net; 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@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


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