Oracle Database 12.2.0
RHEL 7.4
Hello Team,
how r u?
I have scheduled a daily backup - device type disk. I would like to know why it is giving me error despite allocating channel for maintenance type disk? Is it a bug in 12.2?
RMAN> allocate channel for maintenance device type disk;
released channel: ORA_DISK_1
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: SID=387 device type=DISK
RMAN> delete noprompt obsolete;
....
Backup Set 609 30-APR-2019 02:27:14
Backup Piece 609 30-APR-2019 02:27:14 controlfile_c-582889872-20190430-00
Backup Set 612 07-MAY-2019 01:58:59
Backup Piece 612 07-MAY-2019 01:58:59 DWARE1_oau0tk6s_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 05/18/2019 19:07:51
RMAN-06091: no channel allocated for maintenance (of an appropriate type) <----------------------------------- error despite allocating maintenance to disk
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 8 days
RMAN parameter
RMAN> show all;
RMAN configuration parameters for database with db_unique_name DWARE1 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; <---- set to sbt because both tape and disk backup being performed.
CONFIGURE CONTROLFILE AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/oldbackup/BI/backup/%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'controlfile_%F';
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
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 MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_DWARE1.f'; # default
Regards,
Joe
RMAN>