Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Datafile for rollback segment
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 - 05:53:37 CDT