Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Specification does not match any backup in the repository -- need help to resolve

SusjaMar 17 2017 — edited Mar 24 2017

Folks, I need a help to resolve the issue ..

We have established process for backup for a while. Recently we noticed that space is shrinking significantly. We did not have this issue before. The issue started on January 1st 2017.

Our retention policy is 10 days. Last log timestamp is 12-21-2016. New logs do not get deleted while we should have only for the last 10 days.

I ran the script that we run every morning and redirected it to the text file. I'm attaching 2 images: 1. top of the file and 2. IMG_0103.JPGIMG_0104.JPGbottom of the file.

Could you please help to understand and resolve it? What happened that it stopped deleting logs? How we could fix it?

Thanks in advance.

Hi, I tried all steps described in topic 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. What else could I try to do? Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2017
Added on Mar 17 2017
16 comments
18,033 views