Database Validation Check and Rebuild menu options

The Database Validation Check and Rebuild option lets you validate and rebuild the currently selected database.

Table: Database Validation Check and Rebuild menu options

Option	Description
Standard Validation	The standard type of validation is not supported. This option performs a full validation.
Full Validation	This option performs a database validation on all of the database tablespaces in the selected database. Validates the indexes and keys on all of the tables in the database. Scans each table. For each row, a check is made that it exists in the appropriate indexes. The number of rows in the table must match the number of entries in the index. Ensures that every row that is referenced in each index exists in the corresponding table. For foreign key indexes, it also ensures that the corresponding row exists in the primary table. Note: To perform a full database validation, shut down NetBackup and start only the database service. If any validation errors are reported, perform the following tasks: Shut down NetBackup (all daemons and services). Start only the NetBackup database server (vrtsdbsvc_psql). Repeat the validation check using this tool or the nbdb_admin command line utility. If validation errors persist, contact Veritas Technical Support. The administrator may be asked to rebuild the database using the Database Rebuild option or the nbdb_unload.exe command-line utility.
Database Rebuild	This option lets you rebuild the database. A Database Rebuild results in a complete unload and reload of the database. A new database with all of the same options is built in place. A Database Rebuild may be required if Database Validation errors are reported using the Standard or Full Validation options. During a Database Rebuild, all NetBackup operations are suspended. When you select this option, a message appears which recommends that you exit and create a backup using the Backup Database option before you rebuild the database. You then have the choice of whether to continue or not.

Option

Description

Standard Validation

The standard type of validation is not supported. This option performs a full validation.

Full Validation

This option performs a database validation on all of the database tablespaces in the selected database.

Validates the indexes and keys on all of the tables in the database.
Scans each table. For each row, a check is made that it exists in the appropriate indexes. The number of rows in the table must match the number of entries in the index.
Ensures that every row that is referenced in each index exists in the corresponding table. For foreign key indexes, it also ensures that the corresponding row exists in the primary table.

Note:

To perform a full database validation, shut down NetBackup and start only the database service.

If any validation errors are reported, perform the following tasks:

Shut down NetBackup (all daemons and services).
Start only the NetBackup database server (vrtsdbsvc_psql).
Repeat the validation check using this tool or the nbdb_admin command line utility.

If validation errors persist, contact Veritas Technical Support. The administrator may be asked to rebuild the database using the Database Rebuild option or the nbdb_unload.exe command-line utility.

Database Rebuild

This option lets you rebuild the database. A Database Rebuild results in a complete unload and reload of the database. A new database with all of the same options is built in place. A Database Rebuild may be required if Database Validation errors are reported using the Standard or Full Validation options.

During a Database Rebuild, all NetBackup operations are suspended.

When you select this option, a message appears which recommends that you exit and create a backup using the Backup Database option before you rebuild the database. You then have the choice of whether to continue or not.

More Information

Backup and Restore Database menu options

Database Validation Check and Rebuild menu options

Feedback

Feedback