Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!headwall.stanford.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: joel-garry@home.com (Joel Garry)
Newsgroups: comp.databases.oracle.server
Subject: Re: Datafile for  rollback segment
Date: 10 Oct 2002 15:24:16 -0700
Organization: http://groups.google.com/
Lines: 55
Message-ID: <91884734.0210101424.2ff255c8@posting.google.com>
References: <7ca2852.0210080027.22123f38@posting.google.com> <3DA2B931.8050304@simplefact.de> <rHAo9.48648$g9.139362@newsfeeds.bigpond.com>
NNTP-Posting-Host: 67.116.125.178
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034288656 29379 127.0.0.1 (10 Oct 2002 22:24:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 22:24:16 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163794
X-Received-Date: Thu, 10 Oct 2002 15:24:11 MST (news.easynews.com)

"Richard Foote" <richard.foote@bigpond.com> wrote in message news:<rHAo9.48648$g9.139362@newsfeeds.bigpond.com>...
> Hi Alfons,
> 
> Following on from what Howard said previously, why ?

Maybe disk2 needs to be used for other things during normal ops, but
is appropriate for a weekend gigantor atomic update rollback?

> 
> Cheers
> 
> Richard
> "Alfons Zimmermann" <alfons.zimmermann@simplefact.de> wrote in message
> news:3DA2B931.8050304@simplefact.de...
> >
> > I would recommend:
> > a) CREATE 2 different Tablespaces (say TS_RBS_A, TS_RBS_B)
> >     for rollback segments,
> >     each of them with ONE Datafile, but these two Datafiles
> >     on different Disks:
> >     CREATE TABLESPACE TS_RBS_A
> >        DATAFILE '/disk1/.../ts_rbs_a_01.dbf' SIZE 500M
> >     CREATE TABLESPACE TS_RBS_B
> >        DATAFILE '/disk2/.../ts_rbs_b_01.dbf' SIZE 500M;
> >
> > b) CREATE first Rollback Segment (e.g.: rbs_a1) in TS RBS_A
> >     CREATE ROLLBACK SEGMENT rbs_a1 TABLESPACE ts_rbs_a;
> > c) CREATE 2.    Rollback Segment (e.g.: rbs_b1) in TS_RBS_B
> >     CREATE ROLLBACK SEGMENT rbs_b1 TABLESPACE ts_rbs_b;
> >
> >
> > d) Additionally, you could use the init.ora parameter
> > ROLLBACK_SEGMENTS=(rbs_a1, rbs_b1, rbs_a2, rbs_b2...)
> > to control the way, these rollback segments are initialized
> > on startup
> >
> >
> > Jayaraman Ashok wrote:
> > > Hi
> > > I have two datafiles for rollback segment tablespace and have enough
> > > free space on both the datafiles. Now to create a rollback segment in
> > > one specific datafile i offline the other datafile and try to create
> > > the rollback segment, which naturally must create it on the online
> > > datafile. But it is failing with ORA-3113 and i have to do media
> > > recovery to bring it back online. What is wrong here ? The setup is
> > > Oracle8.1.7.0.0 on Solaris7.
> > >
> > > Cheers,
> > > Ashok
> >

jg
--
@home is bogus.
Yes, I've had to deal with situations that silly.