RDBPROD: Routine database / backup verification
edited Jan 10, 2014 7:34AM in Rdb on OpenVMS, IBM zSeries and Oracle on OpenVMS (MOSC) 1 commentAnswered ✓
Hello,
We restore a database from a backup file on a regular basis in order :
1. to check if the RBF file is restoreable
2. to perform VERIFY / ALL to test all error situations
My question :
Does RESTORE operation itself repair some errors that could
possibly still exist in a live production database so that I
cannot detect them in a restored database ?
In other words - I want to avoid performing verify/all on a
live database to avoid possible locks for a longer period of time.
So I do that on a restored copy of a live database.
Is it reliable ?
We restore a database from a backup file on a regular basis in order :
1. to check if the RBF file is restoreable
2. to perform VERIFY / ALL to test all error situations
My question :
Does RESTORE operation itself repair some errors that could
possibly still exist in a live production database so that I
cannot detect them in a restored database ?
In other words - I want to avoid performing verify/all on a
live database to avoid possible locks for a longer period of time.
So I do that on a restored copy of a live database.
Is it reliable ?
0