You can use WebAdmin to recover data to a backup point.
Note
Recovery operation cannot be performed on an instance that is part of a streaming replication cluster in standby mode.
If disk failure occurs on a standby instance, it may be necessary to delete and re-create the instance.
Recovery operation can be performed on an instance that is part of a streaming replication cluster in "Master" mode. If a recovery operation is performed on a master instance, it will break the replication cluster and streaming replication will stop between the master instance and all its standby instances. In such an event, the standby instances can be promoted to standalone instances or can be deleted and re-created.
Follow the procedure below to recover the data in the data 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.
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, select the instance to be recovered and click .
Recover to the backup point
In the [Restore Instance] dialog box, click [Yes].
Recovery is performed. An instance is automatically started when recovery is successful.
Resume database operations
If necessary, re-execute transaction processing from the backup point to when an erroneous operation was performed, and then resume database operations.