Re: Datafile sizes - talking about RMAN block recover now...

I asked about this a while back; follow this thread: http://www.freelists.org/archives/oracle-l/09-2006/msg00060.html

For a really simplistic summary (emphasis on simplistic), you can use your favorite editor and just write to the datafile.

I also found Dizwell's "Corruption Fun", which is quite good. Not sure if it is still available out there, but I can send you a copy if you like.

On 5/2/07, Mayen.Shah_at_lazard.com <Mayen.Shah_at_lazard.com> wrote:
>
>
> 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
>
>
>

-- 
Charles Schultz

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