Understand the optimal use-case before you begin with Exadata Snapshots.

Exadata Snapshots provide a solution for creating space-efficient read-only or read-write clones of an Oracle database that you can use for development, testing, or other non-production purposes. Exadata Snapshots are particularly useful for non-production databases that leverage Exadata performance and availability features. For example, application functionality testing that validates the use of Exadata Smart Scan features.

However, before you begin with Exadata Snapshots, be aware that some non-production database needs may be better satisfied using alternative technologies or approaches. Consider the following in conjunction with your business needs:

• Starting with Oracle Exadata System Software release 24.1.0, Oracle Exadata Exascale introduces advanced snapshot and cloning capabilities that are tightly integrated with Oracle Database. These capabilities eliminate the requirement for a separate test master database to support Exadata Snapshots.

  Where possible, Oracle recommends using Exascale snapshot and cloning capabilities. See also:

  • What is Oracle Exadata Exascale?
  • Using Oracle Database with Exascale Snapshots and Clones

• If you require full end-to-end performance and high availability (HA) testing, Oracle recommends a matching test environment that mirrors the production environment. This is the only solution to fully evaluate performance gains or regressions in response to hardware, software, database, or application changes.

• If your Exadata system is limited to running without Exascale and your requirements emphasize dynamic snapshot capabilities without requiring Exadata smart storage features, then consider using Oracle Advanced Cluster File System (Oracle ACFS) snapshots on Exadata.