Re: Datafile for rollback segment

Hi Alfons,

Following on from what Howard said previously, why ?

Cheers

Richard
"Alfons Zimmermann" <alfons.zimmermann_at_simplefact.de> wrote in message news:3DA2B931.8050304_at_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
>
Received on Tue Oct 08 2002 - 08:14:33 CDT