"Oracle Case" RMAN-08138

1.1.1. RMAN-08138

Date: 2014-05-21 14:36

Environment: Test environment

"Scenario description"

On the test machine, when you use Rman to delete archived log files, you are prompted to warning a warning and the archive log cannot be deleted.

"Error Message"

rman> Delete Archivelog all completed before ' sysdate ';

Released Channel:ora_disk_1

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=129 Devicetype=disk

rman-08138:warning:archived log notdeleted-must Create more backups

Archived Log filename=/u01/app/test/rman/fra/testdb/archivelog/2014_05_20/o1_mf_1_68_9qo951ol_.arcthread=1 sequence=68

"Cause of error"

The delete command executed in Rman is caused by a conflict with the Archive Log deletion policy configured in Rman.

"Workaround"

Because it is tested in a test environment, modify the delete policy of the archive log in Rman, and then execute the delete command to delete the archive log.

Current Archive Log deletion policy:

CONFIGURE ARCHIVELOG deletion POLICY tobacked up 3 times to DISK;

To modify a policy:

Rman> Configure Archivelog Deletionpolicy clear;

After modification:

CONFIGURE ARCHIVELOG deletion POLICY tonone; # Default

To delete an archive log:

rman> delete Archivelog all completed;