One of our development database backup failed with RMAN-06817: Pluggable Database DEVPDB1 cannot be backed up in NOARCHIVELOG mode and RMAN-03002: failure of backup command at particular time period.
RMAN> BACKUP PLUGGABLE DATABASE DEVPDB1;
Starting backup at 24-JUN-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/24/2019 10:33:51
RMAN-06817: Pluggable Database DEVPDB1 cannot be backed up in NOARCHIVELOG mode.
Since our development databases are not critical so all our development and testing databases are in noarchivelog mode.
How to resolve RMAN-06817 issue?
To resolve this error either put the database in archivelog mode or else take the cold backup in mount state in noarchivelog mode.
RESOLUTION 1: Put the database in archivelog mode and start the backup. Below are the steps to put database in archivelog mode.
RESOLUTION 2: Bring down and startup the database in mount state and initiate the backup.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/11.2.0.4.0/dbs/arch
Oldest online log sequence 26879
Current log sequence 26881
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
DEVPDB1 READ WRITE
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size 2262656 bytes
Variable Size 4160752000 bytes
Database Buffers 1157627904 bytes
Redo Buffers 24088576 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
bash-4.1$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Mon Jun 24 10:38:42 2019
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: devcx1 (DBID=4646687692, not open)
RMAN> run {
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/devpdb1_bkp/%U';
BACKUP PLUGGABLE DATABASE DEVPDB1;
backup current controlfile;
backup spfile;
}2> 3> 4> 5> 6> 7>
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/devcx1_bkp/%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/app/devcx1_bkp/%U';
new RMAN configuration parameters are successfully stored
Starting backup at 24-JUN-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=460 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=688 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00011 name=/u01/app/oracle/oradata/devcx1/devpdb1/tms_idx1.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_app.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_app_idx.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_def_idx.dbf
input datafile file number=00043 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_batch_lob_idx.dbf
input datafile file number=00115 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMO1_mds.dbf
input datafile file number=00111 name=/u01/app/oracle/oradata/devcx1/devpdb1/BUR00AOYFR_ias_opss.dbf
input datafile file number=00113 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMO1_ias_opss.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_dcd_idx.dbf
input datafile file number=00112 name=/u01/app/oracle/oradata/devcx1/devpdb1/BUR00AOYFR_iau.dbf
input datafile file number=00120 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMORE_iau.dbf
input datafile file number=00041 name=/u01/app/oracle/oradata/devcx1/devpdb1/xdb01.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_li_idx.dbf
input datafile file number=00027 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_resp_idx.dbf
input datafile file number=00029 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_disc_idx.dbf
input datafile file number=00026 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_resp.dbf
input datafile file number=00035 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_lr_idx.dbf
input datafile file number=00046 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_other_idx_bdd.dbf
input datafile file number=00052 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_resp_idx_bdd.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_glib.dbf
input datafile file number=00023 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_dcmq_idx.dbf
input datafile file number=00030 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_vrv.dbf
input datafile file number=00031 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_vrv_idx.dbf
input datafile file number=00038 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_disc_rep_data.dbf
input datafile file number=00050 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_disc_idx_bdd.dbf
input datafile file number=00114 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMO1_svctbl.dbf
input datafile file number=00039 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_dx_table_data.dbf
input datafile file number=00119 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMORE_svctbl.dbf
input datafile file number=00040 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_dx_index_data.dbf
channel ORA_DISK_1: starting piece 1 at 24-JUN-19
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/devcx1/devpdb1/tms_data1.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/devcx1/devpdb1/sysaux01.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_dcd.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/devcx1/devpdb1/system01.dbf
input datafile file number=00044 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_batch_lob.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/devcx1/devpdb1/devpdb1_users01.dbf
input datafile file number=00033 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_des_idx.dbf
input datafile file number=00032 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_des.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/devcx1/devpdb1/tms_clob1.dbf
input datafile file number=00053 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEV_mds.dbf
input datafile file number=00117 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMORE_mds.dbf
input datafile file number=00118 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMORE_ias_opss.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_def.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_dcmq.dbf
input datafile file number=00116 name=/u01/app/oracle/oradata/devcx1/devpdb1/DEMO1_iau.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/devcx1/devpdb1/bc4j_internal_data.dbf
input datafile file number=00042 name=/u01/app/oracle/oradata/devcx1/devpdb1/tools.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_glib_idx.dbf
input datafile file number=00045 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_other_bdd.dbf
input datafile file number=00034 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_lr.dbf
input datafile file number=00037 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_test_index.dbf
input datafile file number=00048 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_li_idx_bdd.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_li.dbf
input datafile file number=00047 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_li_bdd.dbf
input datafile file number=00051 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_resp_bdd.dbf
input datafile file number=00028 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_disc.dbf
input datafile file number=00036 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_test_data.dbf
input datafile file number=00049 name=/u01/app/oracle/oradata/devcx1/devpdb1/ocl_disc_bdd.dbf
input datafile file number=00110 name=/u01/app/oracle/oradata/devcx1/devpdb1/BUR00AOYFR_svctbl.dbf
channel ORA_DISK_2: starting piece 1 at 24-JUN-19
channel ORA_DISK_2: finished piece 1 at 24-JUN-19
piece handle=/u01/app/devcx1_bkp/02u4t4ud_1_1 tag=TAG20190624T104323 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:05:26
channel ORA_DISK_1: finished piece 1 at 24-JUN-19
piece handle=/u01/app/devcx1_bkp/01u4t4ud_1_1 tag=TAG20190624T104323 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:06:26
Finished backup at 24-JUN-19
Starting backup at 24-JUN-19
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 24-JUN-19
channel ORA_DISK_1: finished piece 1 at 24-JUN-19
piece handle=/u01/app/devcx1_bkp/03u4t5af_1_1 tag=TAG20190624T104951 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-19
Starting backup at 24-JUN-19
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 24-JUN-19
channel ORA_DISK_1: finished piece 1 at 24-JUN-19
piece handle=/u01/app/devcx1_bkp/04u4t5ak_1_1 tag=TAG20190624T104951 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 24-JUN-19
Starting Control File and SPFILE Autobackup at 24-JUN-19
piece handle=/u01/app/oracle/product/RDBMS/12.1.0.2/dbs/c-3636687691-20190624-00 comment=NONE
Finished Control File and SPFILE Autobackup at 24-JUN-19
RMAN>