RMAN Scripts reports RMAN-08138 in 12.1.0.2/12.2.0.1.0 when running delete noprompt archivelog all backed up 1 times to device type 'disk'
(Doc ID 2421365.1)
Last updated on NOVEMBER 02, 2019
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database - Standard Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
Symptoms
Not able to Delete the archivelog file backed up more than once in 12.1 and above using delete archivelog all backed up 1 times to device type 'disk'
Error reported
RMAN-08138: WARNING: archived log not deleted - must create more backups
Using below Script .
run
{
allocate channel ch1 type disk maxpiecesize 4G;
sql 'alter system archive log current';
Backup archivelog all format '&1/Arch_%U.arc';
delete noprompt archivelog all backed up 1 times to device type 'disk' completed before 'sysdate - 1';
}
run
{
allocate channel ch1 type disk maxpiecesize 4G;
sql 'alter system archive log current';
Backup archivelog all format '&1/Arch_%U.arc';
delete noprompt archivelog all backed up 1 times to device type 'disk' completed before 'sysdate - 1';
}
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |