Problem solve
Get help with specific problems with your technologies, process and projects.
Problems backing up LOB tables
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.
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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments