Restore points

• 1: Restore points

1 - Restore points

Restore points

Restore points are useful for cases such as the following:

• If a user error compromises data integrity, such as unintentionally dropping a table or inserting the wrong data into a table, you can restore the database to a state before the problematic transactions.
• In the case of a failed upgrade, you can restore the database to its pre-upgrade state.
• You want to create a number of backups while avoiding the overhead of storing copies of the database externally.

Restore points UI tour

You can view and manage restore points. After logging in to the OTCAD application, the home page appears. Select the More options button and Restore points. The Restore points page appears as shown in this image:

The Restore points page displays the following information:

Select the information icon i to view a summary of the restore point such as the folder name, the number of restore points to save, and the owner details.

Create an archive

An archive acts as a folder that contains restore points. Before saving restore points, you must first create an archive to store them. You can then save restore points to the archive and select a restore point when restoring the database.

To create an archive, do the following:

1. In the Restore points page, select + New Archive. The Create Restore points page opens.

2. In the Folder name field, enter a unique name for the archive.

3. In the Number of restore points to save field, enter the maximum number of restore points that can be saved on the archive.

   Note

     If an archive contains the maximum number of restore points and a new restore point is saved, the oldest restore point in the archive is deleted.
   

4. Save the restore point. Do one of the following:

   • Select Schedule.
   • From the date picker, select the Start date and time.
   • In the Repeat every field, specify the duration at which the restore point needs to be saved.
   • From the Unit drop-down list, select the minute, hour, day, week, or month at which the restore point needs to be saved.
   • Select the On day option and specify the day on which the restore point needs to be saved.
   • Select the On option and specify the exact day and month on which the restore point needs to be saved.

   OR

   • Select Execute once to create the restore point manually.

5. Select Create.

Create a restore point

You can associate a restore point with an existing archive. Before you can save restore points, you must first create an archive to store them. Archives store the restore points in descending chronological order based on the times at which the restore points were saved. You can identify each restore point by its unique identifier or the index in the archive, where an index of 1 specifies the most recently saved restore point.

To create a restore point:

1. In the Restore points page, select +. The restore point is created and displays the following information:

   • Index - The serial number of the restore point in the archive.
   • Timestamp - The date and time of creation of the restore point.
   • Database version - The database version of the OTCAD application.
   • ID - The unique identifier of the restore point.
   • Status - The present status of the restore point. The status can be either Completed or Saving.

   Note

     You need to have super user privileges to create archives and restore points.
   

Edit an archive

After creating an restore point, you can edit the details to suit your requirements.

1. In the Restore points page, select an archive.
2. Hover over ⋮ and select Edit. All the details of the restore point are populated. For more information about editing an archive, see Create an archive.
3. Select Update.

Delete all restore points in an archive

You can delete all restore points in an archive that are no longer in use or required.

1. In the Restore points page, select an archive.
2. Hover over ⋮ for an archive and select Delete all restore points.
3. In the Confirmation dialog, select Delete.

Restore a database from a restore point

After you have saved restore points to an archive, you can use those restore points to restore a database. The database is restored to the state at which the restore point was saved earlier.

The version of the revived database must be the same as or newer than the version of the database when the restore point was saved. After a database is revived, any restore point that was saved using a version newer than the version of the revived database will be invalidated. You can remove the invalidated restore points from the database.

The revive operation preserves existing archives, but their configuration, including restore point limits, are rolled back to their state when the restore point was saved. If an archive did not exist at the time of the restore point to which the database was revived, that archive is revived with default configuration settings—no restore point limit and dbadmin as the owner.

1. In the Restore points page, select an archive.
2. Hover over ⋮ for a restore point and select Restore.
3. In the Confirmation dialog, select Confirm. The Close ongoing session dialog is displayed.
4. Select Proceed anyway. The estimated time to restore the database is displayed. After the database is successfully restored, it is displayed in the Restore points page with the status Completed.

Remove a restore point

You can remove a restore point that is no longer in use or required.

1. In the Restore points page, select an archive.
2. Hover over ⋮ for a restore point and select Remove restore point.
3. In the Confirmation dialog, select Delete.