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!

How to delete previous day backups

nydbaJun 11 2015 — edited Jun 11 2015

Hello

I am on 11203  and like to delete previous day backup but rman backup does not count this as previous day backup. i believe it's due to backup being still in 24 hours window

I want to delelte all backups took yesterday between 12:01 AM till 11:59 Pm and like ot know the command

RMAN> delete noprompt backup completed before 'trunc(sysdate-1)';

using channel ORA_DISK_1
specification does not match any backup in the repository

RMAN> delete noprompt backup completed before 'SYSDATE-1';

using channel ORA_DISK_1

specification does not match any backup in the repository

Jun 10 11:31 test_jghtuvx1.bkp

Jun 10 11:42 test_jghtuvx4_.bkp

Jun 10 11:43 test_jghtuvx5_.bkp

Jun 10 11:44 test_jghtuvx6_.bkp

Jun 10 11:46 test_jghtuvx5_.bkp

Jun 10 11:47 test_jghtuvx3_.bkp

Jun 10 11:48 test_jghtuvx9_.bkp

This post has been answered by Tom321 on Jun 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2015
Added on Jun 11 2015
4 comments
10,038 views