Skip to main content

Search

Welcome to Tibero GTS!

SVR Error: -24066 Occurs During rmgr Backup

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
Note
You 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

 

 

 

Related to