Oracle Cloud Infrastructure Documentation

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.
      Note

      If you've disabled crash recovery on your DB system, it will be automatically deleted in case a database failure occurs.
  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.

Using the CLI

Use the command-line interface to enable or disable crash recovery.

This task requires the following:
  • A DB system Oracle Cloud Identifier (OCID).
  • A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
  1. Open a command prompt and run the following command:
    oci mysql db-system update --db-system-id <DBSystemOCID> --crash-recovery <CrashRecoveryOption>
    • db-system-id: Specify the OCID of the DB system.
    • crash-recovery: Specify whether to enable crash recovery. Allowed values are ENABLED and DISABLED.
      Note

      To disable crash recovery, you must first disable the backup policy and point-in-time recovery. Disabling crash recovery also disables backups and prevents stop and restart operations on the DB system.
The command updates the DB system and returns the work request information.