11 Replies Latest reply on Feb 11, 2013 3:28 PM by Munish

rollback issue

Munish Feb 8, 2013 3:34 PM

Hi,

We have 8.1.7 oracle EE database running.
I got a message saying that RBS could not be extended , I looked into it and found out that the disk was out of space.
I created another RBS02 on another disk and shutdown the DB and restarted it.

Now there are errors in the alert.log that says RBS20 cannot be extended "ORA-1562" ERRORS.

I tried to take RBS20 offline, it says statement processed but it never takes it offline. It will not let me drop rollback segment. Now when I try to go into an application I get ORA-01562 ERRORS.

I tried to see if there was anything in these rollback segments and there is nothing. It is empty.

How can I remove them or fix them.

Thanks
Munish

1. Re: rollback issue

sb92075 Feb 8, 2013 3:39 PM (in response to Munish)

Do you have a complete & recent backup of this DB?
Like Show 0 Likes(0)

Actions
2. Re: rollback issue

Krishna-Oracle Feb 8, 2013 3:49 PM (in response to Munish)

Hi Munish,
Can you please explain the issue in detail
Is RBS a tablespace? if so what is RBS02 and RBS20
can you please clarify these

Thanks,
krishna
Like Show 0 Likes(0)

Actions
3. Re: rollback issue

Munish Feb 8, 2013 3:53 PM (in response to sb92075)

I have export from last night and export looks good.
Like Show 0 Likes(0)

Actions
4. Re: rollback issue

Munish Feb 8, 2013 3:54 PM (in response to Krishna-Oracle)

Hi Krishna,

I am sorry to confuse you.
Yes RBS02 is a datafile in TS RBS

RBS20 is actually rollback segment 20

Thanks
Munish
Like Show 0 Likes(0)

Actions
5. Re: rollback issue

rp0428 Feb 8, 2013 3:57 PM (in response to Munish)

>
Yes RBS02 is a datafile in TS RBS

RBS20 is actually rollback segment 20
>
That doesn't clarify it for me.

Are these TWO DIFFERENT datafiles? Or did you make a typo and say RBS02 when you meant RBS20?
Like Show 0 Likes(0)

Actions
6. Re: rollback issue

Munish Feb 8, 2013 4:17 PM (in response to rp0428)

I have one RBS tablespace called RBS
In it I have 2 datafiles (RBS01, RBS02).

RBS20 is the segment name.

Select segment_name,status from DBA_ROLLBACK_SEGS;

Hope that helps
Like Show 0 Likes(0)

Actions
7. Re: rollback issue

Osama_Mustafa Feb 8, 2013 4:23 PM (in response to Munish)

Refer to
ORA-1562 and ORA-1650 Unable to Extend Rollback Segment [ID 1066542.6]
Like Show 0 Likes(0)

Actions
8. Re: rollback issue

Munish Feb 8, 2013 4:43 PM (in response to Osama_Mustafa)

Hi,
I did add the datafile, but the errors still keeps coming up.
It seems like something did not get "cleared" out.
Like Show 0 Likes(0)

Actions
9. Re: rollback issue

Hemant K Chitale Feb 8, 2013 4:58 PM (in response to Munish)

If you are able to do a SHUTDOWN NORMAL or SHUTDOWN IMMEDIATE, there are no active transactions in the rollback segments at the next startup.

Adding another datafile to the same tablespace that contains the rollback segment should suffice unless the active transaction is so large that the added file is also completely used by the rollback segment as it grows.

Hemant K Chitale
Like Show 0 Likes(0)

Actions
10. Re: rollback issue

Munish Feb 8, 2013 11:38 PM (in response to Hemant K Chitale)

There is a lot of space about 65 Gigs left in RBS TS.
Even after the reboot the Rollback segments says FULL .

There are lots and lots of the following error in alert.log

Failure to extend rollback segment 20
Failure to extend rollback segment 20 because of 1562 condition
Fri Feb 08 18:32:02 2013
Errors in file e:\orant\ora81\admin\porcl2\bdump\porcl2SMON.TRC:
ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment number 20
ORA-01562: failed to extend rollback segment number 20

Not sure what to do here, is re-creating the DB the only option left?

Thanks
Munish
Like Show 0 Likes(0)

Actions
11. Re: rollback issue

Munish Feb 11, 2013 3:28 PM (in response to Munish)

I ended up re-creating the DB.

Thanks
Munish
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.