Document Type | Troubleshooting
Category | Backup/Recovery
Applicable Product Versions | 6FS06, 6FS07, 6FS07PS, 7FS02, 7FS02PS
Error Code | 24066
Document Number | TBATS006
Issue
When attempting rmgr backup,
SVR Error: -24066 Failed to get free backup set record number in the control file. RC=1 error occurs.
Cause
In Tibero, there is a MAXBACKUPSET (maximum number of backup sets that can be stored), and
SVR Error: -24066 this error message occurs when the number of currently stored backup sets exceeds MAXBACKUPSET.
Solutions
Delete unnecessary backup sets before backup and retry.
$ tbrmgr delete --backup-set --cf-only
Increase the maxbackupset value.
$ tbsql sys/[password] SQL> alter database backup controlfile to trace as 'ctl.sql'; SQL> exit; $ vi ctl.sql Modify the MAXBACKUPSET value in the backed-up ctl.sql file $ tbboot nomount $ tbsql sys/[password] SQL> @ctl.sql SQL> exit; tbdown tbboot
NoteYou can check the maxbackupset through controlfile dump.SQL> alter system dump controlfile ;
$TB_HOME/instance/dump/tracedump - When checking the CF dump content, you can verify the changed max value as follows.
Backup Sets sections (blkno = 0x59, pblkno = 0xa9, blkcnt = 1000 size = 8520, max = 1000, used = 0, last_rec