How to delete obsolete from physical standby
When I issue a report obsolete from one of my phisycal stand by databases a lot of obsolete archivelogs are shown. These are some of the ones shown with the report obsolete command:
Archive Log 104966 21-07-2013 01:34:21 +RECOVERY/orcldg/archivelog/2013_07_21/thread_2_seq_14230.25689.821367261
Archive Log 104967 21-07-2013 01:34:27 +RECOVERY/orcldg/archivelog/2013_07_21/thread_2_seq_14231.25722.821367267
Archive Log 104968 21-07-2013 01:34:29 +RECOVERY/orcldgdg/archivelog/2013_07_21/thread_1_seq_14326.25820.821367269
Archive Log 104969 21-07-2013 02:04:27 +RECOVERY/orclddg/archivelog/2013_07_21/thread_1_seq_14327.25884.821369067
Archive Log 104970 21-07-2013 02:04:29 +RECOVERY/orcldg/archivelog/2013_07_21/thread_2_seq_14232.25916.821369069
But when I connect with rman and issue a delete noprompt obsolete device type disk nothing happens:
[oracle@dgali01 gnosisdg]$ rman target / catalog rman/indicodb2013@rmanrepo
Archive Log 104966 21-07-2013 01:34:21 +RECOVERY/orcldg/archivelog/2013_07_21/thread_2_seq_14230.25689.821367261
Archive Log 104967 21-07-2013 01:34:27 +RECOVERY/orcldg/archivelog/2013_07_21/thread_2_seq_14231.25722.821367267
Archive Log 104968 21-07-2013 01:34:29 +RECOVERY/orcldgdg/archivelog/2013_07_21/thread_1_seq_14326.25820.821367269
Archive Log 104969 21-07-2013 02:04:27 +RECOVERY/orclddg/archivelog/2013_07_21/thread_1_seq_14327.25884.821369067
Archive Log 104970 21-07-2013 02:04:29 +RECOVERY/orcldg/archivelog/2013_07_21/thread_2_seq_14232.25916.821369069
But when I connect with rman and issue a delete noprompt obsolete device type disk nothing happens:
[oracle@dgali01 gnosisdg]$ rman target / catalog rman/indicodb2013@rmanrepo
1