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

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Sun, 8 Jul 2007 21:50:07 -0500
Message-ID: <000f01c7c1d3$de153320$6701a8c0@scraunch>

We're using FRA and Flashback database as an integral part of our B&R strategy. Flashback database has already saved us some downtime when a developer truncated the wrong table in our dev database.

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 Arif Gulzar
Sent: Sunday, July 08, 2007 9:30 PM
To: ag_at_oracloid.com
Cc: ORACLE-L
Subject: Re: What are the common mistakes DBA do retarding backup & Recovery?

Interesting comments by all oracle Gurus, I never saw any body taking advantage of Flashback database in my circle. Flash recovery area, Flashback table,Flashback Drop, query etc all are some sky birds for most companies....

On 7/6/07, Alex Gorbachev <HYPERLINK
"mailto:ag_at_oracloid.com"ag_at_oracloid.com> wrote:

I remember we asked once to backup a fairly important file to tape. Instead, SA copied the tape device over the file. Boy, I couldn't stop laughing. :D

On 7/6/07, Keith Moore <HYPERLINK
"mailto:kmoore_at_zephyrus.com"kmoore_at_zephyrus.com> wrote:
> Unix admin had the backup tape writeable and
> had the tape drive configured so that when a tape was put in the drive, it
was
> automatically formatted for the next backup.

--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
HYPERLINK
"http://www.pythian.com/blogs/author/alex"http://www.pythian.com/blogs/autho
r/alex HYPERLINK "http://blog.oracloid.com"http://blog.oracloid.com
BAAG party - HYPERLINK
"http://www.BattleAgainstAnyGuess.com"www.BattleAgainstAnyGuess.com
--
HYPERLINK
"http://www.freelists.org/webpage/oracle-l"http://www.freelists.org/webpage/
oracle-l






No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.2/890 - Release Date: 7/7/2007
3:26 PM



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.10.2/890 - Release Date: 7/7/2007
3:26 PM
 


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

Received on Sun Jul 08 2007 - 21:50:07 CDT