From today’s post, I am going to remind you all about those colleges day when we used to learn about the validation in programming languages. In daily life are aware of validation. In the database world, it is little different. Let’s have look at the types of validation in general terms.



Some of the types of data validation include:

  • Code validation
  • Data type validation
  • Data range validation
  • Constraint validation
  • Structured validation

Now come to our world, As we have gone through about validation. Look at for the purpose of VALIDATE.


Use the VALIDATE command to check for corrupt blocks and missing files, or to determine whether a backup set can be restored.


Step 1: The below command just gives the report of backups that are used to do the  restore and recover :

Step 2: Then run the below command to check the backup pieces are good :

The below command will read the backup pieces/Copies which has datafiles and if finds any error it will report at the RMAN prompt.


Step 3: Check the archivelogs needed for recovery

Replace the xxx, yyy with the start and end archivelog sequence reported by restore database preview command ran in the step 1.

Thanks to all readers for reading our post.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.