 | ||
| About the Storage Foundation Database (SFDB) tools for Oracle | ||
|---|---|---|
| Prev | Overview of Storage Foundation storage and availability management for Oracle databases | Next |
| ||
| About the Storage Foundation Database (SFDB) tools for Oracle | ||
|---|---|---|
| Prev | Overview of Storage Foundation storage and availability management for Oracle databases | Next |
Storage Foundation Enterprise product suites provide enhanced I/O methods to improve database performance and a set of tools for increased ease of management of storage in a database environment.
Performance enhancement methods shared with the Storage Foundation Standard products include:
Storage Foundation Standard products include the following tools for storage management:
To learn more about Storage Checkpoints, FlashSnap, and Storage Tiering features available with the Storage Foundation Standard products:
See the Veritas Storage Foundation Advanced Features Guide.
Storage Foundation Enterprise products provide an extended version of the basic storage management functionality provided in Storage Foundation Standard products:
This extended tool set is the Storage Foundation for Databases (SFDB) feature for enhanced management of Oracle databases. The SFDB tools provide enhanced ease-of-use commands which can be run by a database administrator without root privileges to optimize storage for an Oracle database environment. This guide documents the deployment and use of the SFDB tools with Storage Foundation Enterprise Products. It is a supplemental guide to be used in conjunction with Veritas Storage Foundation product guides for users with Oracle databases.
Storage Foundation Enterprise product tools for optimizing storage for Oracle databases include:
Veritas Quick I/O is a VxFS feature that improves the throughput for Oracle databases built on VxFS file systems. Quick I/O delivers raw device performance to databases run on VxFS, providing the administrative advantages of using file systems without the performance penalties.
Veritas Cached Quick I/O further enhances database performance by leveraging large system memory to selectively buffer the frequently accessed data.
Veritas Extension for Oracle Disk Manager is a custom storage interface designed specifically for Oracle. Oracle Disk Manager allows Oracle to improve performance and manage system bandwidth through an improved Application Programming Interface (API) that contains advanced kernel support for file I/O.
Veritas Extension for Oracle Disk Manager supports Oracle Resilvering. With Oracle Resilvering, the storage layer receives information from the Oracle database as to which regions or blocks of a mirrored datafile to resync after a system crash. When using Oracle Resilvering, you can turn off VxVM Dirty Region Logging (DRL), which increases performance.
SmartSync recovery accelerator increases the availability of mirrored volumes by only resynchronizing changed data. SmartSync reduces the time required to restore consistency, freeing more I/O bandwidth for business-critical applications.
This feature is applicable only to databases that are configured on raw volumes. If supported by the database vendor, the SmartSync feature uses an extended interface between VxVM volumes and the database software to avoid unnecessary work during mirror resynchronization. For example, Oracle automatically takes advantage of SmartSync to perform database resynchronization when it is available.
Database Checkpoint for Enterprise products enables you to create a point-in-time image of a file system. Storage Checkpoints are treated like any other VxFS file system and can be created, mounted, unmounted, and removed with VxFS and Veritas Storage Foundation administrative utilities.
Database FlashSnap enables you to create, resynchronize, and reverse resynchronize an online point-in-time image of a database. You can use this image to perform backup, other maintenance tasks, or off-host processing while providing continuous data availability. Also, database administrators can perform these tasks without root privileges.
Database clone commands for Database Storage Checkpoints or Database FlashSnap can be used for troubleshooting, reporting, and quality assurance for databases.
Database Dynamic Storage Tiering enables you to manage your data so that less-frequently used data can be moved to slower, less expensive disks, allowing frequently-accessed data to be stored on the faster disks for quicker retrieval.
The Symantec Storage Plugin for Oracle Enterprise Manager (OEM) enables you to view VxFS properties, VxVM volume and LUN information for database objects such as tablespace, redo logs, controlfile, datafiles and others through the OEM interface.
Storage Foundation Database cloning tool for STANDBY database using point-in-time copies Database Storage Checkpoints and Database Flashsnap.
Veritas Cross-Platform Data Sharing allows data to be serially shared among heterogeneous systems where each system has direct access to the physical devices that hold the data. This feature can be used only in conjunction with Veritas Volume Manager. Shared or parallel access is possible for read-only data.
Cross-Platform Data Sharing provides the fastest way to use Oracle's Transportable Tablespace (TTS) feature for migrating databases to different platforms in Oracle 10g or later versions. It provides the fastest way to use Oracle's Transportable Tablespace (TTS) feature for moving sets of tablespaces between databases on the same platform in Oracle9.
The Veritas NetBackup for Oracle Advanced BLI Agent software supports Block-Level Incremental (BLI) Backup to reduce database down time, backup time, and backup volume, as well as CPU usage and network overhead. (Contact your Sales Representative for information about this optional product.)