Question: How to I manage a Oracle
backup of a VLDB (very large database)?
Answer:
RAC with Grid is an ideal solution to take advantage of
these developments. RAC supports VLDB databases for data
consolidation and large data warehousing databases. Even in
a packaged application environment, as in SAP or PeopleSoft,
there is a tendency towards consolidating the databases to
provide lower cost and better administrative flexibility.
With the power of processors today, reducing a corporation's
database server footprint to be a tenth of what it was is a
real possibility.
Virtual machines are a big part of enterprise server
consolidation efforts.
Oracle VM is a less known product in the Virtual
Machine marketplace but is interesting because it is fully
supported for various Oracle products.
See MOSC Doc 464754.1 for the latest information
about RAC on Oracle VM.
Partitioning an Oracle backup VLDB
Database size has grown to a point where they are now
measured in the hundreds of gigabytes, and in some cases,
several terabytes. The characteristics of very large
databases (VLDB) demand a different style of administration.
The administration of VLDB often includes the use of
partitioning of tables and indexes.
Since partitioning is such an integral part of VLDB the
remainder of this article will focus on how to partition,
specifically, the partitioning of tables in an Oracle
environment.
There are two main reasons to use partitioning in a VLDB
environment. These reasons are related to management and
performance improvement.
Partitioning offers:
- Management at the individual partition level for
data loads, index creation and rebuilding, and
backup/recovery. This can result in less down time
because only individual partitions being actively
managed are unavailable.
- Increased query performance by selecting only from
the relevant partitions. This weeding out process
eliminates the partitions that do not contain the data
needed by the query through a technique called partition
pruning.
See these related notes on Oracle Backup
VLDB.
|
|
|
|
|
Oracle Training from Don Burleson
The best on site
"Oracle
training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop!
|
|
|
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
Burleson
Oracle ®
is the registered trademark of Oracle Corporation.
|
|
