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

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: