17.9.2 Index operations (in the case of the cold standby configuration)
This subsection explains how to use B-tree indexes, text indexes, and range indexes in the cold standby configuration.
The following operations related to B-tree indexes, text indexes, and range indexes are unique to the cold standby configuration:
-
Releasing a B-tree index from unfinished status
-
Releasing a text index from unfinished status
-
Releasing a range index from unfinished status
All other operations are the same as when the cold standby configuration is not used. See 11.3 Index operations.
- Organization of this subsection
(1) Releasing a B-tree index from unfinished status (in the case of the cold standby configuration)
If hot standby processing occurs while the adbimport command or the adbidxrebuild command is executing, B-tree indexes are placed in unfinished status. If this happens, re-execute the command in the new active system.
If the following file systems can be accessed from both hosts using the same paths, you can resume the processing from the point where it was interrupted when the command is re-executed:
-
File system storing the DB directory
-
File system storing the input data files that are used in data import processing (applicable to the adbimport command)
-
File system storing temporary work files
For details about the unfinished status of B-tree indexes, see 15.9.1 Steps to take when unfinished status is applied to a B-tree index.
(2) Releasing a text index from unfinished status (in the case of the cold standby configuration)
If hot standby processing occurs while the adbimport command or the adbidxrebuild command is executing, text indexes are placed in unfinished status. If this happens, re-execute the command in the new active system.
If the following file systems can be accessed from both hosts using the same paths, you can resume the processing from the point where it was interrupted when the command is re-executed:
-
File system storing the DB directory
-
File system storing the input data files that are used in data import processing (applicable to the adbimport command)
-
File system storing temporary work files
For details about the unfinished status of text indexes, see 15.10.1 Steps to take when unfinished status is applied to a text index.
(3) Releasing a range index from unfinished status (in the case of the cold standby configuration)
If hot standby processing occurs while the adbidxrebuild command is executing, range indexes are placed in unfinished status. If this happens, re-execute the command in the new active system.
If the following file systems can be accessed from both hosts using the same paths, you can resume the processing from the point where it was interrupted when the command is re-executed:
-
File system storing the DB directory
-
File system storing temporary work files
For details about the unfinished status of range indexes, see 15.11.1 Steps to take when unfinished status is applied to a range index.