Restoring datafile from full backup - I can't see what I am missing
I allegedly have a full backup of my database - I have the output from list backup of database comleted after 'sysdate-1'; and crosscheck to ensure that they are there and available but when I do a restore, I get datafiles from 11 to being not found. This is confusing me because it seems to be there but it doesn't want to work.
This bothers me because the backup is available and is a full backup according to the RMAN list command. My understanding of full is that it should have everything required whcih makes me think I am either missing a crucial step or RMAN tells lies!