Enabling or Disabling Crash Recovery

Enable crash recovery to ensure durability and to enable data recovery in the event of an unexpected server exit.

Note

You cannot disable crash recovery on an Always Free DB system.
Use one of the following method to enable or disable crash recovery:

Using the Console

Use the Console to enable or disable crash recovery on a DB system.

This task requires the following:
  • A running DB system.
  • Automatic backups are disabled on the DB system if you want to disable crash recovery.
  • (Recommended) You have created a full backup before disabling crash recovery.
Do the following to enable or disable crash recovery on a DB system:
  1. On the DB systems list page, select the DB system that you want to work with. If you need help finding the list page or the DB system, see Listing DB Systems - Using the Console.

    The details page opens and displays information about the DB system.

  2. Select the Details tab.
  3. To disable crash recovery on a DB system if it is currently enabled, do the following:
    1. Find the Crash recovery field under DB system information, select Edit
    2. In the Disable crash recovery dialog box, select Disable crash recovery for this DB system and then select Disable.
      The DB system enters the Updating state and crash recovery is disabled.
  4. To enable crash recovery on a DB system if it is currently disabled, do the following:
    1. Find the Crash recovery field under DB system information, select Edit
    2. In the Enable crash recovery dialog box, select Enable to enable crash recovery.
      The DB system enters the Updating state and crash recovery is enabled.
      Note

      Automatic backups are not automatically enabled. You must enable them manually.