[EN] RMAN-12012: multiple records for SBT_TAPE parallelism found in catalog

Problem:

[HOSTXXX]/u01/app/oracle/admin/hostxxx/bfile $ rman target rman/passxxx@DBXXX

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jul 29 06:31:51 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DBXXX (DBID=1713800945)

RMAN> connect catalog rman/cat_passxxx@rman;

connected to recovery catalog database

RMAN> print script dbxxx_backup_arch;

printing stored script: dbxxx_backup_arch

{SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

SET command id TO 'dbxxx_backup_arch';                                                                                        

CHANGE ARCHIVELOG ALL CROSSCHECK;                                               

CONFIGURE CONTROLFILE AUTOBACKUP ON;                                            

CONFIGURE DEFAULT DEVICE TYPE TO sbt;                                           

CONFIGURE CHANNEL DEVICE TYPE sbt parms 'ENV=(NSR_SERVER=server_bkcp_1,NSR_CLIENT=hostxxx)';                                                                           

CONFIGURE DEVICE TYPE sbt PARALLELISM 5;                                        

backup ARCHIVELOG ALL filesperset 1 format 'dbxxx_arch.%U' delete input;         

}

RMAN> run { execute script dbxxx_backup_arch;}

connected to target database: DBXXX (DBID=1713800945)

connected to recovery catalog database

executing script: dbxxx_backup_arch

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

executing command: SET COMMAND ID

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03015: error occurred in stored script dbxxx_backup_arch

RMAN-03002: failure of crosscheck command at 07/29/2012 07:01:14

RMAN-12010: automatic channel allocation initialization failed

RMAN-12012: multiple records for SBT_TAPE parallelism found in catalog

Recovery Manager complete.

Solution1: (Quick Fix)

[HOSTXXX]/u01/app/oracle/admin/hostxxx/bfile $ sqlplus / as sysdba
SQL> execute dbms_backup_restore.resetConfig;

Solution2:

[HOSTXXX]/u01/app/oracle/admin/hostxxx/bfile $ rman target rman/passxxx@DBXXX

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jul 29 06:31:51 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DBXXX (DBID=1713800945)

RMAN> connect catalog rman/cat_passxxx@rman;

connected to recovery catalog database

RMAN> show all;

RMAN configuration parameters for database with db_unique_name DBXXX are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of show command at 07/29/2012 09:09:00

RMAN-12010: automatic channel allocation initialization failed

RMAN-12012: multiple records for SBT_TAPE parallelism found in catalog

RMAN> exit

Recovery Manager complete.

[HOSTXXX]/u01/app/oracle/admin/hostxxx/bfile $ rman target rman/passxxx@DBXXX

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jul 29 06:31:51 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DBXXX (DBID=1713800945)

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 16; --the number here is unimportant

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 5 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters are successfully stored

RMAN> exit

Recovery Manager complete.

[HOSTXXX]/u01/app/oracle/admin/hostxxx/bfile $ rman target rman/passxxx@DBXXX

Recovery Manager: Release 11.1.0.7.0 - Production on Sun Jul 29 06:31:51 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: DBXXX (DBID=1713800945)

RMAN> connect catalog rman/cat_passxxx@rman;

connected to recovery catalog database

RMAN> show all;

starting full resync of recovery catalog

full resync complete

RMAN configuration parameters for database with db_unique_name DBXXX are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 16 BACKUP TYPE TO BACKUPSET;

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(NSR_SERVER=server_bkcp_1,NSR_CLIENT=hostxxx)';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.1.0/db_4/dbs/snapcf_DBXXX.f'; # default

Now the archive backup can be taken with no problem.