Document Type | Troubleshooting
Category | Backup/Recovery
Applicable Product Versions | 6FS06, 6FS07
Error Code | 24066
Document Number | TBATS007
Issue
During RMGR backup, ERROR_TCCF_RMGR_GET_FREE_BACKUP_SET_RECNO_FAILED(-24066) occurred causing the backup to fail.
SVR Error: -24066 Failed to get free backup set record number in the control file. # sys,log [2023-06-07T07:15:29.379967] [FRM-188] [I] THROW. ec=ERROR_TCCF_RMGR_GET_FREE_BACKUP_SET_RECNO_FAILED(-24066) [ Failed to get free backup set record number in the control file. ] (csr_id:4294967295) [cf_backup_set.c:594:cf_backup_set_add_for_archive_only] [2023-06-07T07:15:29.404513] [RVP-108] [I] RV master received SLAVE 1(188) DONE [2023-06-07T07:15:52.795398] [PE-807] [I] pe slave allocation failed, force serial execution: csr_id=472, slave_cnt=10, total_pes_cnt=22
Cause
The error occurs because the number of backup sets storable in the control file reaches 500 during rmgr execution.
SQL> select NAME, RECORD_MAX from _VT_CONTROLFILE_RECORD_SECTION where name in ('backup set','archive log');
---------------------------------------------------------
| NAME | RECORD_MAX |
---------------------------------------------------------
| backup set | 500 |
| archive log | 500 |
---------------------------------------------------------
2 rows selected.Solutions
1. Check the number of backup sets
Check the current number of backup sets.
select count(*) from v$backup_set;
2. Delete backup sets
If there are no backup files in the backup directory, delete the oldest backup sets from the control file.
tbrmgr delete --backup-set <SET_ID> --cf-only ex) tbrmgr delete --backup-set 3 --cf-only --userid sys/[password] --cf-only : Option to delete archive files or backup sets only within the control file