Viewing Snapshots of a DWS Cluster

Viewing Snapshot Information

1. Log in to the DWS console.
2. In the navigation pane on the left, choose Cluster > Management > Snapshots. In the snapshot list, all snapshots are displayed by default.
3. You can view the Snapshot Name, Snapshot Status, Cluster Name, Backup Mode, Snapshot Type, Storage Media, Snapshot Level, and creation time of snapshots.

   You can also enter a snapshot name or cluster name in the upper right corner of the snapshot list and click to search for the specified snapshot. DWS supports fuzzy search.

   Table 1 describes snapshot status.

   Table 1 Snapshot status

   Status	Description
   Available	Indicates that the existing snapshot works properly.
   Creating	Indicates that a snapshot is being created.
   Restoring	The snapshot is being restored.
   Unavailable	Indicates that the existing snapshot cannot provide services.
   Frozen	The snapshot is frozen (except for legal reasons)
   Frozen for legal reasons	The snapshot is frozen for legal reasons and cannot be deleted.

   Table 2 lists the backup modes.

   Table 2 Backup modes

   Type	Description
   Manual	Snapshot that you manually create through the DWS console or using APIs. You can delete the snapshots that are manually created.
   Automated	Snapshot that is automatically created after the automated snapshot backup policy is enabled. The system automatically deletes the automated snapshots after the retention period expires. You cannot delete them.

   The following table describes the snapshot types.

   Table 3 Type

   Type	Description
   Full	The snapshot is a full backup.
   Incremental	The snapshot is an incremental backup.

   The following table describes the snapshot media.

   Table 4 Storage media

   Storage Medium	Description
   OBS	The created snapshot is an OBS snapshot and the backup data is stored on the OBS server.
   NFS	The created snapshot is an NFS snapshot and the backup data is stored on the NFS server.

   The following table describes the snapshot levels.

   Table 5 Snapshot levels

   Snapshot Level	Description
   cluster	A backup of all the configurations and service data of a cluster at a specific point in time.
   schema	A backup of all the service data of a schema at a specific point in time.
   table	A backup of all the service data of a table at a specific point in time.

Querying Snapshot Information by Table Name

Only the snapshots that are created after the fine-grained snapshot function is enabled support fine-grained search. Only cluster versions 8.2.1.230 and later support snapshot query by table name.

1. Log in to the DWS console.
2. In the navigation pane on the left, choose Cluster > Cluster List.
3. In the cluster list, click the name of the target cluster. The Cluster Information page is displayed.
4. In the navigation pane, choose Snapshots. Click the Snapshots tab and enable fine-grained snapshot. Click Advanced Search on the right.

   You can set a database, schema, and a table in the format "database.schema.table" to view the snapshot information of the specified table in a database schema.