rollback issue

Munish Feb 8, 2013 7:34 AM

Currently Being Moderated

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 7:39 AM (in response to Munish)

Currently Being Moderated

Do you have a complete & recent backup of this DB?
Report Abuse

Like (0)
2. Re: rollback issue

Krishna-Oracle Feb 8, 2013 7:49 AM (in response to Munish)

Currently Being Moderated

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

Like (0)
3. Re: rollback issue

Munish Feb 8, 2013 7:53 AM (in response to sb92075)

Currently Being Moderated

I have export from last night and export looks good.
Report Abuse

Like (0)
4. Re: rollback issue

Munish Feb 8, 2013 7:54 AM (in response to Krishna-Oracle)

Currently Being Moderated

Hi Krishna,

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

RBS20 is actually rollback segment 20

Thanks
Munish
Report Abuse

Like (0)
5. Re: rollback issue

rp0428 Feb 8, 2013 7:57 AM (in response to Munish)

Currently Being Moderated

>
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?
Report Abuse

Like (0)
6. Re: rollback issue

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

Currently Being Moderated

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

Like (0)
7. Re: rollback issue

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

Currently Being Moderated

Refer to
ORA-1562 and ORA-1650 Unable to Extend Rollback Segment [ID 1066542.6]
Report Abuse

Like (0)
8. Re: rollback issue

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

Currently Being Moderated

Hi,
I did add the datafile, but the errors still keeps coming up.
It seems like something did not get "cleared" out.
Report Abuse

Like (0)
9. Re: rollback issue

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

Currently Being Moderated

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

Like (0)
10. Re: rollback issue

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

Currently Being Moderated

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

Like (0)
11. Re: rollback issue

Munish Feb 11, 2013 7:28 AM (in response to Munish)

Currently Being Moderated

I ended up re-creating the DB.

Thanks
Munish
Report Abuse

Like (0)

Go to original post

Actions

Legend

Correct Answers - 10 points
Helpful Answers - 5 points