We are encrypting datafiles on a physical standby database via 'alter database datafile ... encrypt'. Is there any way to tell, on a database that is not open, which datafiles are encrypted and which are not? The only way I can find is to try to encrypt each file and I get an error on the ones that are already encrypted, but there must be a way to tell from the catalog, I just can't find it.
Thanks.