RMAN-06531 Changing Level 0 Backupset To Keep In 12c (Doc ID 1989725.1)

Last updated on APRIL 09, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Changing level 0 backupset to keep in 12c is failing with error RMAN-06531.

RMAN> change backupset 66 keep until time 'sysdate+10';

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of KEEP command at 01/19/2015 10:35:24
RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET

 

 

== Test Case ==
 
  Able  to exempt L0 backup from retention policy using change command
 
  RMAN>  run{
  2>  allocate channel t1 type disk;
  3> allocate channel t2 type disk;
  4> backup as compressed backupset incremental level 0 format '/u04/%U'
  database;
  5> }
  RMAN> sql 'alter system archive log current';
  RMAN> sql 'alter system archive log current';
  RMAN> sql 'alter system archive log current';
 
  RMAN> run{
  2>  allocate channel t1 type disk;
  3> allocate channel t2 type disk;
  4> backup as compressed backupset incremental level 1  format '/u04/%U'
  database;
  5> }
 
  11gR2
  ======
  RMAN> list backup ;
 

  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  ------- ---- -- ---------- ----------- ------------ ---------------
  364     Incr 0  21.12M     DISK        00:00:30     14-JAN-15
         BP Key: 371   Status: AVAILABLE  Compressed: YES  Tag:
  TAG20150114T153118
         Piece Name: /u04/dcpsn649_1_1
   List of Datafiles in backup set 364
   File LV Type Ckp SCN    Ckp Time  Name
   ---- -- ---- ---------- --------- ----
   3    0  Incr 5712900    01-JAN-15 /u03/stage/datafile/EXAMPLE_5.xtf
   5    0  Incr 5925139    14-JAN-15
  +DATA/ora1124/datafile/undotbs2.782.865870811
   7    0  Incr 5925139    14-JAN-15 +DATA/ora1124/datafile/users.783.854016321
 
  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  ------- ---- -- ---------- ----------- ------------ ---------------
  367     Incr 1  176.00K    DISK        00:00:03     14-JAN-15
         BP Key: 374   Status: AVAILABLE  Compressed: YES  Tag:
  TAG20150114T153700
         Piece Name: /u04/dfpsn68u_1_1
   List of Datafiles in backup set 367
   File LV Type Ckp SCN    Ckp Time  Name
   ---- -- ---- ---------- --------- ----
   2    1  Incr 5925253    14-JAN-15
  +FRA/ora1124/datafile/sysaux.11538.850085547
   5    1  Incr 5925253    14-JAN-15
  +DATA/ora1124/datafile/undotbs2.782.865870811
   7    1  Incr 5925253    14-JAN-15 +DATA/ora1124/datafile/users.783.854016321
 
  RMAN> change backupset 364 keep until time 'sysdate+10';                         <==== Able to change in 11.2
 
  using channel ORA_DISK_1
  keep attributes for the backup are changed
  backup will be obsolete on date 24-JAN-15
  backup set key=364 RECID=364 STAMP=868980903
 
  RMAN>>change backupset 367 keep until time 'sysdate+10';
 
  using channel ORA_DISK_1
  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================
  RMAN-03002: failure of KEEP command at 01/14/2015 15:37:53
  RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET                        <==== Expected for L1 backup
 
  RMAN>
 
 
  12.1.0.1
  ========
  Able to exempt backup from retention policy  without issue.
 
 
  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  ------- ---- -- ---------- ----------- ------------ ---------------
  16      Incr 0  51.52M     DISK        00:01:26     14-JAN-15
         BP Key: 16   Status: AVAILABLE  Compressed: YES  Tag:
  TAG20150114T134603
         Piece Name: /u02/0kpsn07a_1_1
   List of Datafiles in backup set 16
   Container ID: 3, PDB Name: PDB12101
   File LV Type Ckp SCN    Ckp Time  Name
   ---- -- ---- ---------- --------- ----
   8    0  Incr 2241287    14-JAN-15
  /u02/database/ora12101/ORA12101/0C8BFF5FE40307D4E054DFFF7FFDFFFF/datafile/o1_mf_system_bcbkfxgk_.dbf
   10   0  Incr 2241287    14-JAN-15
  /u02/database/ora12101/ORA12101/0C8BFF5FE40307D4E054DFFF7FFDFFFF/datafile/o1_mf_users_bcbkkshs_.dbf
 
 
  RMAN> change backupset 16 keep until time 'sysdate+10';                                                              <====  Able to change for L0
 
  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: SID=244 device type=DISK
  keep attributes for the backup are changed
  backup will be obsolete on date 24-JAN-15
  backup set key=16 RECID=16 STAMP=868974912
 
  12.1.0.2
  ========
 
  RMAN> list backupset 66;
  List of Backup Sets
  ===================
  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  ------- ---- -- ---------- ----------- ------------ ---------------
  66      Incr 0  102.07M    DISK        00:00:40     19-JAN-15
         BP Key: 68   Status: AVAILABLE  Compressed: YES  Tag:
  TAG20150119T100938
         Piece Name: D:\ORADATA\DBCDB\BACKUP\3TPT3OV2_1_1
   List of Datafiles in backup set 66
   File LV Type Ckp SCN    Ckp Time  Name
   ---- -- ---- ---------- --------- ----
   3    0  Incr 2619649    19-JAN-15 D:\ORADATA\DBCDB\DATA\CDB\SYSAUX01.DBF
   6    0  Incr 2619649    19-JAN-15 D:\ORADATA\DBCDB\DATA\CDB\DEFTBS01.DBF
 
  RMAN> change backupset 66 keep until time 'sysdate+10';                                                            <==========  Issue
 
  using channel ORA_DISK_1
  using channel ORA_DISK_2
  using channel ORA_DISK_3
  using channel ORA_DISK_4
  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================
  RMAN-03002: failure of KEEP command at 01/19/2015 10:35:24
  RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET

 

Changes

 Upgraded database from 11g to 12c (12.1.0.2).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms