Q

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 first published in November 2005

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close