dbed_vxdba

NAME

dbed_vxdba - administer database, Storage Checkpoints, and space alarms

SYNOPSIS

AVAILABILITY

VERITAS Storage Foundation for Oracle. To determine whether this product is installed on a HP-UX system, enter:

swlist VRTSdbed

DESCRIPTION

The dbed_vxdba utility presents a menu of possible operations to the database administrator. Based on the operations selected, the command guides you through the necessary steps and prompts you for information to enter to complete the operation.

The dbed_vxdba utility can be run by the Oracle Database Administrator (typically, the user ID oracle) of the database instance for most operations. Some VxDBA operations, like the file system space management operations, require superuser (root) privileges.

Before running dbed_vxdba, you must define the environment variables $ORACLE_SID and $ORACLE_HOME. If the Oracle initialization parameter file is not located under $ORACLE_HOME/dbs, specify this startup parameter file pathname in the environment variable $ORA_PFILE or place it permanently in the settings file for VxDBA (/etc/vx/vxdba/$ORACLE_SID/settings).

Each VxDBA menu has the following standard operational and navigational controls:

? - Display Help About the Current Menu
This menu option provides online help for the current VxDBA menu, listing the available operations and a definition of each.

q - Exit From Current Menu
This menu option returns you to the main menu if you are in one of the administration submenus or exits VxDBA if you are at the main menu level.

x - Exit From VxDBA Utility
This menu option exits the VxDBA utility.

The VxDBA main menu provides access to the following operations:

1 - Database Administration
Use this menu to perform basic database management operations. The Database Administration menu provides access to the following operations:

- Startup Database Instance
- Shutdown Database Instance
- Display/Update Tablespace Information
2 - Display Database/VxDBA Information
Use this menu to display information about various aspects of your database environment, as well as examine and save configuration information for database recovery. The Display Database/VxDBA Information menu provides access to the following operations:

- Display Database Information
- Display/Update Tablespace Information
- Display Datafile/File System Information
- Display VxDBA/Database Configuration Files
- Examine Volume/File System/Database Configuration
- Save Volume/File System/Database Configuration
3 - Storage Checkpoint Administration
Use this menu to create, display, mount, unmount, and remove Storage Checkpoints. A Storage Checkpoint can be considered to be an online database backup that contains a snapshot image of the database when the Storage Checkpoint was created. You can then use these Storage Checkpoints to roll back the image of a database, tablespace, or datafile to some earlier state. The Storage Checkpoint Administration menu provides access to the following operations:

- Create New Storage Checkpoint
- Display Storage Checkpoints
- Mount Storage Checkpoint
- Umount Storage Checkpoint
- Remove Storage Checkpoints
4 - Storage Rollback Administration
Use this menu to roll back a database, tablespace, datafile, or list of datafiles to a Storage Checkpoint and configure rollback options. You must shut down the database instance before performing Storage Rollback operations, or may leave the database up for file or tablespace rollback. In this case, VxDBA will check if the target database objects are offline before proceeding. The Storage Rollback Administration menu provides access to the following operations:

- Roll Back the Database to a Storage Checkpoint
- Roll Back a Tablespace to a Storage Checkpoint
- Roll Back Files to a Storage Checkpoint
- Set Number of Storage Rollback Threads
- Set Buffer Size for Storage Rollback
- Show Backup Control File List
5 - Monitoring Agent Administration
Use this menu to display the space usage of file systems and Storage Checkpoints, display current space alarm settings, and enable and configure space alarm settings. VxDBA's monitoring agent monitors space usage for your database file systems, tablespaces, and datafiles. The monitoring agent can be configured to send alarm notifications and automatically grow file systems when space usage exceeds user-defined thresholds. The Monitoring Agent Administration menu provides access to the following operations:

- File System Space Administration
- Oracle Tablespace/Datafile Space Administration
- Configure Monitoring Agent Options
- Configure Statistics Collection
- Start/Stop Monitoring Agent
6 - Storage Checkpoint Capacity Planning
Use this menu to plan for file system space requirements for Storage Checkpoints. The Storage Checkpoint Capacity Planning menu provides access to the following operations:

- Create Capacity Planning Schedules
- Display Capacity Planning Schedules
- Display Space Usage Information
- Remove Capacity Planning Schedules
.br

NOTES

The VxDBA utility maintains information about the tablespaces and datafiles that are allocated to a database and the file systems that these objects reside on. This information is updated when the Update Tablespace option is selected in VxDBA and before creating a Storage Checkpoint. However, for other operations, this data may be stale if tablespaces, datafiles, or file systems have changed. It is important to update the VxDBA information for your database whenever changes are made.

The VxDBA command line interface commands also use the current VxDBA information to perform operations and do not prompt you to update the configuration.

The space-usage statistics displayed by VxDBA in the monitoring agent area may be different than the output from the df command. This is because df makes certain assumptions that are valid for the UFS file system, but do not apply to VxFS. For correct space usage on VxFS file systems, use the /opt/VRTS/bin/df command.

For all issues with configuring the monitoring agent, see the dbed_mon(1M) man page and the VERITAS Storage Foundation for Oracle Database Administrator's Guide.

FILES

/var/log/dbed_mon

Log and statistics files from VxDBA monitoring agent.

/etc/vx/vxdba

VxDBA database containing Oracle instance information.

/etc/vx/vxdba/$ORACLE_SID/settings

Directory containing VxDBA settings for an Oracle instance. Place any required environment variables into this directory. Template environment variables already in the directory are the $ORACLE_PFILE file location, the $ORA_DBA setting to specify the user that owns the database, and the $USER_DUMP_DEST setting to specify where backup control files are dumped.

SEE ALSO

dbed_ckptcreate (1M), dbed_ckptdisplay (1M), dbed_ckptmount (1M), dbed_ckptplan (1M), dbed_ckptpolicy (1M), dbed_ckptquota (1M), dbed_ckptremove (1M), dbed_ckptrollback (1M), dbed_ckptumount (1M), dbed_clonedb (1M), dbed_mon (1M), dbed_update (1M), qio_convertdbfiles (1M), qio_getdbfiles (1M), qio_recreate (1M), vxckptadm (1M), vxgrowfs(1M), oracle_edition (7)

VERITAS Storage Foundation for Oracle Administrator's Guide