Problem solve Get help with specific problems with your technologies, process and projects.

How much redo is generated from a hot backup?

How much redo will be generated when we take a hot backup of 100 tablespaces?

How much redo will be generated when we take a hot backup of 100 tablespaces?
The amount of redo generated depends on your transaction volume during the time of your hot backup. The more transactions, the more redo that will be generated. This has nothing to do with the number of tablespaces, but the transaction volume. This is why hot backups are typically done at night during non-peak times.

The above assumes you are using the old-style hot backups. If you are using RMAN to perform your hot backups, then...

you do not have to worry about an increase in your redo generation.

This was last published in November 2005

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.