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 Dedicated Clusters > 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	The snapshot works properly.
   Creating	The snapshot is being created.
   Restoring	The snapshot is being restored.
   Unavailable	The snapshot is unavailable.
   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 snapshot.
   Automated	The snapshot was automatically created by the system when automated snapshot backup is enabled for the cluster. You cannot delete the snapshots that are automatically created. The system automatically deletes the snapshots whose retention duration expires.

   Table 3 lists the snapshot types.

   Table 3 Snapshot types

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

   Table 4 describes the storage media of the snapshot.

   Table 4 Storage media

   Storage Media	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.

   Table 5 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.

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. Choose Dedicated Clusters > Clusters in the navigation pane.
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 the fine-grained snapshot function. Click Advanced Search on the right.

   You can set a triplet consisting of a database, a schema, and a table in a fine-grained query on the snapshot information in a specified database schema table. For details about the snapshot information, see 3.

   

   Table 6 Triplet description

   Tuple Name	Description
   database	Database name
   schema	Schema name
   table	Table name