My Oracle Support Banner

OCI EXACS BKUP_API BACKUP FAILED WITH ORA-19806: cannot make duplex backups in recovery area (Doc ID 2739081.1)

Last updated on FEBRUARY 28, 2021

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A to N/A [Release N/A]
Information in this document applies to any platform.

Symptoms

Environment: OCI EXACS DB System

Issue: Database incremental backup configured through bkup_api failed as below.

/var/opt/oracle/bkup_api/bkup_api list jobs --all --dbname=dbname

454f1794409711ebxxxxxxxxxxxxxxxxx | 2020-12-17 18:40:28 | failed  | None               | incremental>>>>>>>>>>>>>>>Failed

From backup log under directory  /var/opt/oracle/log/<db_name>/obkup/

    obkup_2020-12-17_02:40:36.log

OBKUP:: Wallet is in open state
OBKUP:: Oracle database state is up and running
catalog mode  no
################################ PERIODICAL BACKUP STARTING ################################
...
OBKUP:: DB instance: <dbinstance_name>
OBKUP:: Validating the backup repository ......
Executing rman instructions
.....
OBKUP:: Performing backup to local storage (primary backup)
OBKUP:: Executing rman instructions
....
 -> show all;
 -> set command id to '<command_id>';
 -> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
 -> CONFIGURE CHANNEL DEVICE TYPE DISK CONNECT '*';
 -> configure device type DISK PARALLELISM 8 BACKUP TYPE TO COMPRESSED BACKUPSET;
 -> set encryption on;
 -> RECOVER COPY OF DATABASE WITH TAG 'dbaas_incr_backup' UNTIL TIME 'SYSDATE - 8';
 -> BACKUP SECTION SIZE 64G INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'dbaas_incr_backup' DATABASE;
 -> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
 -> DELETE NOPROMPT OBSOLETE DEVICE TYPE DISK;
 ->  RMAN OUTPUT:
     .......
      RMAN> BACKUP SECTION SIZE 64G INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'dbaas_incr_backup' DATABASE;
      RMAN-03090: Starting backup at 17-DEC-2020 02:42:48
      RMAN-08031: released channel: ORA_SBT_TAPE_1
      RMAN-08031: released channel: ORA_SBT_TAPE_2
      RMAN-08031: released channel: ORA_SBT_TAPE_3
      RMAN-08031: released channel: ORA_SBT_TAPE_4
      RMAN-08031: released channel: ORA_SBT_TAPE_5
      RMAN-08031: released channel: ORA_SBT_TAPE_6
      RMAN-08031: released channel: ORA_SBT_TAPE_7
      RMAN-08031: released channel: ORA_SBT_TAPE_8
      RMAN-12016: using channel ORA_DISK_3
      RMAN-12016: using channel ORA_DISK_4
      RMAN-12016: using channel ORA_DISK_6
      RMAN-12016: using channel ORA_DISK_7
      RMAN-12016: using channel ORA_DISK_1
      RMAN-12016: using channel ORA_DISK_2
      RMAN-12016: using channel ORA_DISK_5
      RMAN-12016: using channel ORA_DISK_8
    .....
      ORA-19806: cannot make duplex backups in recovery area
      RMAN-12019: continuing other job steps, job failed will not be re-run
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03009: failure of backup command on ORA_DISK_2 channel at 12/17/2020 02:42:52
      ORA-19806: cannot make duplex backups in recovery area

 

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.