OceanBase supports data backup plus log archive for point-in-time recovery (PITR). Both must be configured for full DR capability.

Enable log archive

ALTER SYSTEM SET LOG_ARCHIVE_DEST = 's3://ob-backups/prod/archive';
ALTER SYSTEM ARCHIVELOG;

Verify archive lag in OCP. Sustained lag > 60s blocks clean PITR windows.

Weekly physical backup

Schedule full data backup to the same bucket prefix. Retain 4 weekly + 12 monthly per compliance policy.

Restore test (quarterly)

  1. Restore to an isolated restore tenant on scratch cluster.
  2. Recover to timestamp 24h ago.
  3. Run checksum queries on tables that matter for the business recovery objective.
  4. Document RTO/RPO achieved.

Never rely on untested backups. Restore only works cleanly when archive logs are contiguous.