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!

"Backup cancelled because all files were skipped"

862643Jul 24 2011 — edited Jul 26 2011
Hi

I am performing database backup using the following command:

run {
allocate channel c1 device type disk;
backup incremental level 0 database plus archivelog delete input;
release channel c1;
restore database validate;
}

upon checking the RMAN logs, it finishes and I can tell that it is a good backup. I can also list the backup pieces that had just been backed up. after this step, i want to backup the flash_recovery_area to tape, i used this command:

run {
allocate channel t1 device type sbt;
BACKUP RECOVERY AREA;
DELETE OBSOLETE DEVICE TYPE sbt;
release channel t1;
}

when i do this, i get this message from the logs, and i dont see any backups on tape:

------LOGS-------
allocated channel: t1
channel t1: SID=503 device type=SBT
channel t1: Oracle Secure Backup

Starting backup at 23-JUL-11
Specification does not match any archived log in the recovery catalog
Specification does not match any datafile copy in the repository
Specification does not match any backupset in the repository
backup cancelled because all files were skipped
Finished backup at 23-JUL-11

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
no obsolete backups found

released channel: t1

RMAN>

i dont understand why i am getting this message where in fact, i have archivelog, datafile and backupset backed up in my FRA. Any ideas?

Thanks!
This post has been answered by Hemant K Chitale on Jul 25 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2011
Added on Jul 24 2011
8 comments
1,949 views