| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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:Received on Wed May 02 2007 - 14:58:05 CDT
>
> 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
 |
 |