require help to find and delete/purge applied archives from the stand by database.
i am new to dataguard environment and we have RAC stand by database and some times we are getting +ARCH file system alerts from the 12c grid.
we are using ASM file syetem for RAC stannd by database and we have multiple RAC stand by databases in same server with sharing the same file system.
could you please help with providing some quieries to check applied archives to delete once archives are applied.
my requirement is follwoing :
1) i want to know which archive is applied and which archive i need to delete and which archive copy & apply is in progress between primary & stannd by database.