Please, I am having problems backing up my large database. Its size is 50GB. It has two tables containing LOBs and other tables that are not posing problems. Whenever my backup gets to the LOB tables, it hangs and comes back with a rollback segment error, or it causes the system to have a stop error. How do I solve this problem?
To be honest, a 50GB database is not that large. I have indexes that are larger than that! And I wish you would have posted your exact error message. But I would guess that your "rollback segment error" means you need larger rollback segments to support your operation. This seems odd to me since a proper backup strategy should not rely heavily on the rollback segments. How are you performing your backup? And what is the exact error?
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.