The ccmdb repair command repairs database
indexes.
Synopsis
ccmdb repair database_path -i|-repair_index table_name|index_name|"" [-y]
ccmdb repair database_path -t|-repair_table table_name [-y]
Uses
Use the ccmdb
repair command to repair indexes
and tables corrupted at the database level.
Note: Ensure
that all Rational Synergy
sessions are shut down before executing the
ccmdb repair command.
If any sessions are running when you execute the command, you receive
an error message. (For information about shutting down a database,
see
ccmdb shutdown.)
To
run this command, you must log on as the Oracle user who has write
privileges for the appropriate tasks. For more information, see Setting up user privileges for UNIX on Oracle.
Options and arguments
- database_path
- Specifies the path to the database you are repairing.
- -i|-repair_index table_name|index_name|""
- Indicates that you want to re-create an index. If -repair_index is
specified with a table name, all the indexes in the table are repaired.
If an index name is specified, only the specified index is repaired.
If "" is specified, all indexes in the database are repaired.
- The possible tables are as follows: acckeys, attrib, bind, bsite, compver, control, relate,
and release.
- -t|-repair_table table_name
- Indicates that you want to repair table data for table_name.
To repair table data, rename the table, create the table, copy to
the new table, and then delete the old table.
- -y
- Executes the command without displaying confirmation messages.
Example
Based on the results
of ccmdb check, fix an index corruption in the attrib table
in the /vol/tom/ccmdb/primo database.
$
ccmdb repair /vol/tom/ccmdb/primo -repair_index attrib