Hi Norman
Since the backups are are level 0 backups the validate command seems enough
so far. My goal was testing only the backup consistency (not to recover
until point of failure). Basically the test consists to validate a tape
backup from 6 months ago using RMAN.
Thanks
On Mon, Apr 17, 2017 at 10:00 PM, Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
wrote:
As far as I remember, a restore validate only validates the level 0
incremental backup that RMAN would restore first, before restoring the
level 1 incremental and whatever archived logs etc to bring the restore up
to date.
I've never run a validate on a non-incremental backup, but I would imagine
that doing so would validate all required backup pieces. For incremental,
you only validate the level 0, at least, in all the tests I've done with:
Run {
Allocate ...
Set until sequence n;
Restore validate dstabase;
...
}
The reason being that you cannot run a 'recover validate database'
command, so you don't get the level 1 and archived logs being validated.
HTH
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.