- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: RBS segment not flushed after an import
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2007 03:27 AM
тАО02-06-2007 03:27 AM
we're using ORACLE 8.1.7.
We've found that the RBS isn't flushed after that an import run.
This means that if during the first import we use 40% of the RBS, at the end of the second import we've used 80% and the third import fails since not enough RBS is available.
The RBS isn't flushed when the database is halted.
I'd like to know if there's an automatic way to flush the RBS when the database is stopped, or alternatively which is the SQL command to flush the RBS.
Thanks, regards
Enrico
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2007 04:30 AM
тАО02-06-2007 04:30 AM
Re: RBS segment not flushed after an import
I would suggest increasing the frequency of rotating the RBS in the init.ora for the database.
You risk data loss if this configuration is not correct.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2007 05:15 AM
тАО02-06-2007 05:15 AM
Re: RBS segment not flushed after an import
RBS segments are not 'flushed' and they don't die. They just fade away, If they get re-used too soon you'll get the infamous :
"Ora-1555:Snapshot too old"
Oracle 8.1.7. So that is still the manual rollbackl segment manipulation right? You might want to google for some handy scripts to display usage.
>> We've found that the RBS isn't flushed after that an import run.
Any other long running queries?
>> The RBS isn't flushed when the database is halted.
Exactly what do you mean by that? How can you tell? Which SQL statement you you use to conclude that?
RBS data has no value when the database is halted. After stop + start you should be able to drop and recreate as you feel like.
(and re-create teh segments and put them online)
>> and the third import fails since not enough RBS is available.
Care to share the exact error message?
Anyhing extra in alert.log
>> which is the SQL command to flush the RBS
Something like;
alter rollback segment R01 offline;
drop rollback segment R01;
alter rollback segment R02 offline;
drop rollback segment R02;
alter rollback segment R03 offline;
drop rollback segment R03;
:
L
drop rollback segment RBS_DUMMY;
drop tablespace RBS1;
drop tablespace RBS2;
create rollback segment rbs_dummy tablespace SYSTEM;
alter rollback segment rbs_dummy online;
create tablespace RBS1
extent management local uniform size 1m
datafile '/oracle/dbf/roramst_rbs01.dbf' size 4000M reuse;
create tablespace RBS2
extent management local uniform size 1m
datafile '/oracle/dbf/roramst_rbs02.dbf' size 4000M reuse;
create rollback segment R01 tablespace RBS1 storage (initial 1m next 1m minextents 2 maxextents unlimited);
alter rollback segment R01 online;
create rollback segment R02 tablespace RBS2 storage (initial 1m next 1m minextents 2 maxextents unlimited);
alter rollback segment R02 online;
:
:
( back in 8.17. days I used to use perl scripts to generate sequences like this based on the active RBS situation )
Hth,
Hein van den Heuvel
HvdH Performance Consulting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2007 05:34 AM
тАО02-06-2007 05:34 AM
Re: RBS segment not flushed after an import
ALTER ROLLBACK SEGMENT rbsname SHRINK TO n M
If the rollback segment has an OPTIMAL value defined, 'ALTER ROLLBACK SEGMENT rbsname SHRINK' will return it to this OPTIMAL size.
PCS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2007 05:56 AM
тАО02-06-2007 05:56 AM
Re: RBS segment not flushed after an import
Still, your problem is a bit unusual in behavior - I believe the last 8.1.7 might have been 8.1.7.4 - are you up to that level?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2007 07:52 AM
тАО02-06-2007 07:52 AM
SolutionRBS are available for reuse once the data has been committed - if you shutdown the db then it will need the rbs to rollback the uncommitted transaction when the db is restarted.
Patti