QUOTE (burleson @ Mar 21 2017, 05:01 PM)
>> Does it have some relation to particular timestamp?
From what you said, that date change event precipitated the problem!
I tried all steps described in topic you pointed me http://dbaforums.org/oracle/index.php?showtopic=16916
but it did not have any effect.
Then I ran these sets of commands:
list backup summary
o Run “crosscheck backup;”
o Run “crosscheck archivelog all;”
o Run “crosscheck backupset;”
o Run “delete noprompt expired backup;”
o Run “delete noprompt expired backupset;”
o Run “delete noprompt expired archivelog all;
• Run “list backup summary’” again and see that nothing has changed
o Run “delete noprompt backupset <12345> <12346;”>
o Run “list backup summary” again and see that nothing has changed
Finally ran this: delete force noprompt backupset 12345 12346;” but again nothing has changed.
Note: From the thread you pointed me I did all steps except this one: (my management did not recommend me to do it)
3. If your database is flashback enabled, then just for a moment, disable this.
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter flashback off;
SQL> alter flashback on;
SQL> alter database open;
Any other suggestions? It sounds to me that those files for some reason do not have 'attributes' for deletion.