Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Faster backups through intra-file parallel backup and restore operations (11g only)


When a parallel backup takes place there are several backup processes started. Each one is responsible for processing one file at a time. Oracle is aware that this strategy is fine for the current average database size, but this strategy soon may not be enough.

This scalable solution for backups is also known as the multi-section backup. Each datafile is divided into a defined number of sections, each section is defined as a contiguous range of database blocks, and each parallel process takes care of one section at a time, so several parallel processes manage a big database file at the same time.

Let's issue the command to perform the multi section backup:

# One-off configuration of device type and parallelism.
CONFIGURE DEVICE TYPE sbt PARALLELISM 4;
CONFIGURE DEFAULT DEVICE TYPE TO sbt;
# Divides the tablespace in 512M sections.
RUN {
BACKUP SECTION SIZE 512M TABLESPACE any_huge_TS;
}

Some issues you should...