Oracle case study RMAN-08138

1.1.1 RMAN-08138

Date:

Environment: test environment

[Scenario description]

On the test machine, when RMAN is used to delete archived log files, a WARNING is prompted, and archive logs 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

[Error cause]

The delete Command executed in RMAN conflicts with the archive log deletion policy configured in RMAN.

[Solution]

Because it was tested and used in the test environment, modify the deletion policy for archiving logs in RMAN and run the delete command to delete the archived logs.

Current archiving log deletion policy:

Configure archivelog deletion policy tobacked up 3 times to disk;

Modify policy:

RMAN> configure archivelog deletionpolicy clear;

After modification:

Configure archivelog deletion policy tonone; # default

Delete archived logs:

RMAN> delete archivelog all completed;