Use bbed - http://orafaq.com/papers/dissassembling_the_data_block.pdf
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Mayen.Shah_at_lazard.com
Sent: Wednesday, May 02, 2007 1:58 PM
To: robertgfreeman_at_yahoo.com
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
Subject: RE: Datafile sizes - talking about RMAN block recover now...
How do I generate/create physical and logical block corruption in test
environment to test block recover.
Database : 9i & 10gR2
OS : Solaris
Standard precautions will be followed : test environment only with full
backup
before test etc. etc.
Thanks
Mayen Shah
"Robert Freeman"
To
<robertgfreeman_at_y "Christo Kutrovsky"
<kutrovsky.oracle_at_gmail.com>
ahoo.com>
cc
Sent by: daniel.hubler_at_aurora.org,
oracle-l_at_freelists.org
oracle-l-bounce_at_f
Subject
reelists.org RE: Datafile sizes - talking about RMAN
block
recover now...
May 02 2007 03:37
PM
Please respond to
robertgfreeman_at_ya
hoo.com
I'm less trusting of blockrecover than you are I think... :-) My hit
ratio
with blockrecover is probably hovering around 50%. I will say that the
sample is somewhat small though! :-)
Anyone else want to share their experiences with blockrecover?
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Sig V1.1
-----Original Message-----
From: Christo Kutrovsky [mailto:kutrovsky.oracle_at_gmail.com]
Sent: Wednesday, May 02, 2007 1:33 PM
To: robertgfreeman_at_yahoo.com
Cc: daniel.hubler_at_aurora.org; oracle-l_at_freelists.org
Subject: Re: Datafile sizes
I personally use bigfiles in ASM. I dont even consider the time to
restore a hugefile, because I do not forsee the need to restore only a
chunk of a tablespace. If I am restoring the entire tablespace, it
doesn't matter how many files I have.
If I have corrupted blocks, I would use RMAN's blockrecover command.
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
On 5/2/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
>
> Wow... that makes for a long dba_data_files query!! My personal
thought on
> this is for BIG databases, I like to time how long it takes to restore
a
> given datafile size. If I need to recover a given datafile, how long
do I
> want that to take? My general rule is no more than 10-15 minutes
(depending
> on any SLA's of course!). So if it takes 15 minutes to restore 20GB,
that
> would be my datafile size (assuming the OS can handle a datafile of
that
> size and so on).
>
> I much prefer fewer, larger datafiles to more, smaller ones. Much
easier
to
> manage among other things.
>
> RF
>
>
> Robert G. Freeman
> Oracle Consultant/DBA/Author
> Principle Engineer/Team Manager
> The Church of Jesus Christ of Latter-Day Saints
> Father of Five, Husband of One,
> Author of various geeky computer titles
> from Osborne/McGraw Hill (Oracle Press)
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On
> Behalf Of daniel.hubler_at_aurora.org
> Sent: Wednesday, May 02, 2007 9:50 AM
> To: oracle-l_at_freelists.org
> Subject: Datafile sizes
>
>
> Looking for comments & experiences regarding sizes of datafiles.
>
> We have a large (6+ TB) OLTP database, which currently has 2300+
datafiles.
> A while ago, we stopped adding datafiles and were exclusively
extending
> them.
> But we are wondering how far we can/should go, with the size of
individual
> data files.
> Currently about 30% of the datafiles are at 8 gig.
>
> BTW - this particular application resides on VMS.
>
>
> Any ideas/thoughts/comments would be appreciated.
>
> Thanks.
>
>
> Dan Hubler
> Database Administrator
> Aurora Healthcare
> daniel.hubler_at_aurora.org
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which
contains information which may be confidential or privileged. The
information is intended to be for the use of the individual or entity
named above. If you are not the intended recipient, please be aware that
any disclosure, copying, distribution or use of the contents of this
information is prohibited. Please notify the sender of the delivery
error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 02 2007 - 15:29:15 CDT
