Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

About administering the Storage Foundation for

Databases (SFDB) tools

After you have installed and configured your base Storage Foundation product,

you can set up and administer the Storage Foundation for Databases tools for

optimizing storage for your Oracle database. The following procedures apply for

all Storage Foundation 5.1 Enterprise products unless specifically noted otherwise.

About the Storage Foundation for Databases (SFDB)

repository database

The Storage Foundation for Databases (SFDB) repository or repository database

stores metadata information required by the Storage Foundation for Databases

tools. This information includes data about user databases, snapshot databases,

storage configuration, scheduled tasks.

Note: The repository database requires only occasional interaction outside of the

initial installation and configuration of Storage Foundation Enterprise products.

In this release of Storage Foundation products, the SFDB repository is stored in

a relational database and is managed by SQLite3. The default location of the

repository is on the mount point of the SYSTEM tablespace of the Oracle database.

This enables it to be shared easily among cluster nodes. However, you can choose

an alternate location if needed.

Configuring the Storage Foundation for Databases

(SFDB) repository

The Storage Foundation for Database (SFDB) repository stores information used

by SFDB tools. The repository contains Storage Checkpoint information, tablespace

and datafile information, Database FlashSnap information, and SmartTier for

Oracle parameters.

The SFDB repository:

■ Uses SQLite3 for the repository.

■ Is automatically created when you run dbed_update for the first time.

If the repository already exists, the command will refresh it. To use dbed_update:

■ The database must be up and running.

Administering Storage Foundation for Databases (SFDB) tools

About administering the Storage Foundation for Databases (SFDB) tools