My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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
Changes
Cause
Solution
References


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