PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to check the status of backup/Recovery when Net vault/Netbackup is not installed ?

Query 10) How to check the status of backup/Recovery when Net vault/Netbackup is not installed
Answers )
If we don’t have Netvault installed, but have access to the teradata dictionary the below script helps us to find the status of the Backup or Restore of the TPA.

/* Script to report ARC status */

SELECT * FROM DBC.RCEVENT WHERE OPERATIONINPROCESS = ‘Y’ ;

This may report all failed events aswell, to filter it down to 2 days an additional where clause could be used.

SELECT * FROM DBC.RCEVENT WHERE OPERATIONINPROCESS = ‘Y’ AND CREATEDATE > DATE -1 ;

Add a Comment

Your email address will not be published. Required fields are marked *