This content has been marked as final.
Show 11 replies
-
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? -
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 -
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. -
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 -
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? -
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 -
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] -
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. -
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 -
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 -
11. Re: rollback issue
Munish Feb 11, 2013 3:28 PM (in response to Munish)I ended up re-creating the DB.
Thanks
Munish