Name

VALIDATE

Synopsis

Oracle9i Syntax:

VALIDATE BACKUPSET primary_key [, primary_key ...]
[ CHECK LOGICAL 
| DEVICE TYPE deviceSpecifier [, deviceSpecifier ...]
]
[ CHECK LOGICAL 
| DEVICE TYPE deviceSpecifier [, deviceSpecifier ...]
]...;

Oracle8i Syntax:

VALIDATE BACKUPSET primary_key [, primary_key ...] 
[ CHECK LOGICAL ];

Checks the integrity of a backup. RMAN examines all of the associated backup pieces to determine whether their contents can be restored, if necessary, and if they are free of physical corruption. For Oracle8i, you must execute this command from within the RUN command.

Keywords

CHECK LOGICAL

Validates that there are no logical corruptions, such as corruption of an index entry.

Common keywords and clauses: deviceSpecifier, primary_key.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial