Recover a failed disk using WebAdmin.
In a streaming replication configuration, the master instance can be recovered, but the standby instance cannot. If disk failure occurs on a standby instance, it may be necessary to delete and re-create the instance. Also, recovering the master instance stops streaming replication to and from all standby instances. In such an event, the standby instances can be promoted to standalone instances or can be deleted and re-created
Recover the database cluster by following the appropriate recovery procedure below for the disk where the failure occurred.
If failure occurred in the data storage disk or the transaction log storage disk
Follow the procedure below to recover the data storage disk or the transaction log storage disk.
Stop applications
Stop applications that are using the database.
Stop the instance
Stop the instance. Refer to "2.1.1 Using WebAdmin" for information on how to stop an instance. WebAdmin automatically stops instances if recovery of the database cluster is performed without stopping the instance.
Recover the failed disk
Replace the disk, and then recover the volume configuration information.
Create a tablespace directory
If a tablespace was defined after backup, create a directory for it.
Recover the keystore, and enable automatic opening of the keystore
Do the following if the data in the database has been encrypted:
Restore the keystore to its state at the time of the database backup.
Enable automatic opening of the keystore.
Recover the database cluster
Log in to WebAdmin, and in the [Instances] tab, click [Solution] for the error message in the lower-right corner.
Run recovery
In the [Restore Instance] dialog box, click [Yes].
Instance restore is performed. An instance is automatically started when recovery is successful.
Resume applications
Resume applications that are using the database.
Point
WebAdmin may be unable to detect disk errors, depending on how the error occurred.
If this happens, refer to "17.10.3 Other Errors" to perform recovery.
If failure occurred on the backup data storage disk
Follow the procedure below to recover the backup data storage disk.
Recover the failed disk
Replace the disk, and then recover the volume configuration information.
Recover the backup data
Log in to WebAdmin, and in the [Instances] tab, click [Solution] for the error message.
Run backup
Perform backup to enable recovery of the backup data. In the [Backup] dialog box, click [Yes]. The backup is performed. An instance is automatically started when backup is performed.
Point
If you click [Recheck the status], the resources in the data storage destination and the backup data storage destination are reconfirmed. As a result, the following occurs:
If an error is not detected
The status of the data storage destination and the backup data storage destination returns to normal, and it is possible to perform operations as usual.
If an error is detected
An error message is displayed in the message list again. Click [Solution], and resolve the problem by following the resolution for the cause of the error displayed in the dialog box.
