Snapshot mode

Table: Snapshot modes and their purposes shows common uses for each snapshot mode.

Table: Snapshot modes and their purposes

Snapshot mode

Purpose

online_snapshot

Choose online_snapshot if you want to:

  • Clone a database. A clone database can be used for decision-support analysis, reporting, development, or testing.

  • Recover the primary database if it is corrupted by either taking over the primary role or performing a reverse resync. With online_snapshot you cannot roll forward any logs because the primary and secondary log sequences are different.

  • Back up the primary database on the same or a different host.

online_mirror

Choose online_mirror if you want to:

  • Create a "hot backup" image.

  • Back up the primary database on the same host at the operating system level using different set of storage.

  • Perform a point-in-time recovery of the primary database if it becomes corrupted. With online_mirror, it is possible to roll forward to recover changes to your database.

offline

Choose offline if you want to:

  • Clone your production database if it is offline. A clone database can be used for decision-support analysis, reporting, development, or testing.

  • Back up your production database if it is offline.