VALIDATE

Purpose

The ALTER SYSTEM VALIDATE statement is used to perform physical backup validation.

Limitations and considerations

• Due to the frequent access to backup media required for validation tasks, which can consume network resources intended for backup tasks, it is recommended to execute validation tasks when no backup tasks are running in the user tenant and the system is under low load.

• When specifying the validation level for backup validation:

  • For backup sets and log archive pieces from versions earlier than V4.6.0, basic validation (file integrity check) is not supported.

  • For backup sets from versions earlier than V4.3.4, physical validation (checking the correctness of physical data and logical consistency) is not supported.

Privilege requirements

This statement must be executed by the administrator of each tenant. Specifically:

• In MySQL mode, the default administrator is the root user.

• In Oracle mode, the default administrator is the SYS user.

Syntax

ALTER SYSTEM VALIDATE { BACKUP | BACKUPSET [= 'backup_set_id_list'] | ARCHIVELOG_PIECE [= 'piece_id_list'] }
    [ DATA_BACKUP_DEST = 'data_backup_path' ]
    [ LOG_ARCHIVE_DEST = 'log_archive_path' ]
    [ LEVEL = { 'basic' | 'physical' } ];

backup_set_id_list:
    backup_set_id[,backup_set_id,...]

piece_id_list:
    piece_id[,piece_id,...]

Parameters

Examples

Validate all backup sets and log archive pieces in the entire backup path and archive path

The user tenant initiates a basic validation for all backup sets and log archive pieces in the current backup and archive paths of the tenant.

obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE BACKUP LEVEL = 'basic';

Validate a specified backup set or log archive piece

Validate a backup set

• The user tenant initiates a basic validation for all backup sets in the current backup path of the tenant.

  obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE BACKUPSET LEVEL = 'basic';
  

• The user tenant initiates a physical validation for backup sets with backup_set_id 1 and 2 in the current backup path of the tenant.

  obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE BACKUPSET = '1,2' LEVEL = 'physical';
  

Validate a log archive piece

• The user tenant initiates a basic validation for all log archive pieces in the current archive path of the tenant.

  obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE ARCHIVELOG_PIECE LEVEL = 'basic';
  

• The user tenant initiates a physical validation for log archive pieces with piece_id 1 and 2 in the current archive path of the tenant.

  obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE ARCHIVELOG_PIECE = '1,2' LEVEL = 'physical';
  

Validate a backup set or log archive piece in a specified path

Validate a backup set

• The user tenant initiates a basic validation for all backup sets in the specified backup path of the tenant.

  obclient> ALTER SYSTEM VALIDATE BACKUPSET DATA_BACKUP_DEST = 'file:///data/nfs/backup/data' LEVEL = 'basic';
  

• The user tenant initiates a physical validation for backup sets with backup_set_id 1 and 2 in the specified backup path of the tenant.

  obclient> ALTER SYSTEM VALIDATE BACKUPSET = '1,2' DATA_BACKUP_DEST = 'file:///data/nfs/backup/data' LEVEL = 'physical';
  

Validate a log archive piece

• The user tenant initiates a basic validation for all log archive pieces in the specified archive path of the tenant.

  obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE ARCHIVELOG_PIECE LOG_ARCHIVE_DEST = 'LOCATION=file:///data/nfs/backup/archive' LEVEL = 'basic';
  

• The user tenant initiates a physical validation for log archive pieces with piece_id 1 and 2 in the specified archive path of the tenant.

  obclient(sys@oracletenant)[SYS]> ALTER SYSTEM VALIDATE ARCHIVELOG_PIECE = '1,2' LOG_ARCHIVE_DEST = 'LOCATION=file:///data/nfs/backup/archive' LEVEL = 'physical';
  

References

• Overview of backup validation

• Validate the entire backup path and archive path

• Validate a specified backup set or log archive piece

• Validate a backup set or log archive piece in a specified path