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

My last failure was some time ago. It was a client that I got called into on an emergency, so I didn't configure the backups or anything. Frankly I don't remember a lot of detail about it except that the block recover didn't work. Could have been any number of things really... It's like anything else... when we get stung by something, we tend to be cautious about trusting it afterwards.

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: Thursday, May 03, 2007 12:01 PM
To: Robert Freeman
Cc: daniel.hubler_at_aurora.org; oracle-l_at_freelists.org Subject: Re: Datafile sizes - talking about RMAN block recover now...

So what happens when it doesn't work?

Are you doing "backup validate database" before running it?

--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/


On 5/3/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:


> LOL... I mean it's worked about 50% of the time for me

> when I've tried to use it.

>

> RF

>

> --- Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>

> wrote:

>

> > I've corrupted blocks manually and then I've used it

> > to repair them,

> > no issues. What do you mean 50% hit ratio?

> >

> > --

> > 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:

> > > 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/

> > >

> > >

> >

> >

> > --

> > Christo Kutrovsky

> > Senior Database/System Administrator

> > The Pythian Group - www.pythian.com

> > I blog at http://www.pythian.com/blogs/

> >

>

>

> Robert G. Freeman

> Author:

> Portable DBA: Oracle  (Oracle Press)

> Oracle Database 10g New Features (Oracle Press)

> Oracle9i RMAN Backup and Recovery (Oracle Press)

> Oracle9i New Features (Oracle Press)

> Oracle Replication (Rampant Tech Press)

> Mastering Oracle8i (Sybex)

> Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>)

> Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)

>



--
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