Q
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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close