Oracle8i Recovery Manager User's Guide and Reference
Release 2 (8.1.6)

Part Number A76990-01





Go to previous page Go to beginning of chapter Go to next page

Recovery Manager Command Syntax, 50 of 50




To examine a backup set and report whether it can be restored. RMAN scans all of the backup pieces in the specified backup sets and looks at the checksums to verify that the contents are intact so that the backup can be successfully restored if necessary.


The validate backupset command tests whether the backup sets can be restored, whereas change ... crosscheck merely examines the headers of the specified files if they are on disk or queries the media management catalog if they are on tape. 

Use this command when you suspect that one or more backup pieces in a backup set are missing or have been damaged. Use validate backupset to specify which backups to test; use the validate option of the restore command to let RMAN choose which backups to validate.


Keywords and Parameters


specifies the backup sets to be validated by primary_key. Obtain the primary keys of backup sets by executing a list statement or, if you use a recovery catalog, by querying the RC_BACKUP_SET fixed view. 

check logical 

tests data and index blocks that pass physical corruption checks for logical corruption, for example, corruption of a row piece or index entry. If RMAN finds logical corruption, it logs the block in the alert.log and server session trace file. The RMAN command completes and Oracle populates V$BACKUP_CORRUPTION and V$COPY_CORRUPTION with corrupt block ranges.

Note: validate does not use maxcorrupt


Validating a Backup Set

This example validates the status of the backup set whose primary key is 12:

     allocate channel ch1 type disk;
     validate backupset 12;
# As the output indicates, RMAN determines whether it is possible to restore the
# specified backup set.
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel ch1: sid=10 devtype=DISK
RMAN-03022: compiling command: validate
RMAN-03023: executing command: validate
RMAN-08016: channel ch1: starting datafile backupset restore
RMAN-08502: set_count=16 set_stamp=341344502 creation_time=14-AUG-98
RMAN-08023: channel ch1: restored backup piece 1
RMAN-08511: piece handle=/oracle/dbs/0ga5h07m_1_1 params=NULL
RMAN-08024: channel ch1: restore complete
RMAN-08031: released channel: ch1

Related Topics


Go to previous page Go to beginning of chapter Go to next page
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.