Updating the repository using dbed_update
Prev Appendix B. Storage Foundation for Databases (SFDB) tools command line interface Next

Updating the repository using dbed_update

You can use the dbed_update command to update the repository.

Any time you change the structure of the database (for example, by adding or deleting datafiles, converting PFILE to SPFILE, or converting SPFILE to PFILE), you must run dbed_update.

Before updating the repository, review the following information:

Prerequisites

  • You must be logged on as the database administrator (typically, the user ID oracle).

Usage notes

  • The dbed_update command saves or updates the information related to the Oracle database in the SFDB repository.

  • The database must be up and running, and the ORACLE_SID and the ORACLE_HOME variable arguments must be specified with the -S and -H options, respectively.

  • See the dbed_update(1M) manual page for more information.

Options for updating the repository:

Option

Sample value

Description

-S

ORACLE_SID

Specifies the name of the Oracle database whose information will be retrieved.

-H

ORACLE_HOME

The ORACLE_HOME setting for the ORACLE_SID database.

-G

SERVICE_GROUP

Specifies the VCS service group name for the ORACLE_SID database if it is under VCS control.

This option is required in an HA environment, however it is not required in an SF Oracle RAC environment.

-P

ORACLE_PFILE

Specifies the fully qualify path of the Oracle pfile if it is not located under ORACLE_HOME/dbs directory.

-R

REPOSITORY_PATH

Specifies a user-defined location for the repository. In a RAC or HA situation, it should be located on shared storage. The default location is on the mountpoint of the SYSTEM tablespace of the Oracle database. This way it is shared easily among cluster nodes. If REPOSITORY_PATH is slash (/), the repository location is switched back to the default path.

-I

N/A

An integrity check of the repository is performed, without refreshing from the Oracle database . If successful, the string "ok" is printed to stdout. In addition, the full path of the repository file is shown. Whenever refreshing from the database, an integrity check is automatically performed.

-o

list

The list of hosts and their internal ID is shown.

-o

rename

Rename a host in the repository, by specifying old and new name. This is useful for DR after a failover, because the hostnames on the DR site differ from the original ones.

For example:

-o rename,old_node=old_name,new_node=new_name

To update the SFDB repository

Prev Up Next
About the command line interface Home Creating Storage Checkpoints using dbed_ckptcreate