Query 10) How to check the status of backup/Recovery when Net vault/Netbackup is not installed
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 ;