I have a weird problem in all our databases with dataguard. When we issue "delete archivelog all backed up 1 times to disk;" the archive logs which have not been backed up are also showing up as candidates for deletion.
To confirm these observations I did a test in our lab.
A)
On a stand alone DB, I took a backup and then switched log files.
list archivelog all, list archivelog all backed up 1 times to device type disk and delete archivelog all backed up 1 times to device type disk - All these three commands returned expected results. Especially the third command showed just the archived logs backed up as candidates for deletion
b) Then I setup dataguard, took backup on primary again and switched some log files.
Now, list archivelog all and list archivelog all backed up 1 times to device type disk returned expected results.
BUT delete archivelog all backed up 1 times to device type disk is showing all archive logs, even those that have not been backed up as candidates for deletion. This is puzzling me especially given that list command gives the current results.
Did anyone see this behavior. Let me know if you need any o/p to troubleshoot this issue. Thanks for your help..