Document Type | Troubleshooting
Category | Backup/Recovery
Applicable Product Versions | 6FS06, 6FS07, 7FS01, 7FS02
Error Code | TBR-1024
Document Number | TBATS004
Issue
When starting the DB, error TBR-1024 occurs, and the database starts in MOUNT mode.
[TEST]tibero@tibero1:/home/tibero> tbboot "tbdown clean" is executed automatically. Listener port = 1521 Critical Warning : Raise svmode failed. The reason is TBR-1024 : Database needs media recovery: file needs end backup(/home/tibero/tibero_data/TEST/data/system001.dtf). Current server mode is MOUNT. Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started suspended at MOUNT mode.
You can verify through the v$backup view that the backup flag of the data files is set to 'ACTIVE' status.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
0 ACTIVE 257456 2025/04/08 14:06:20
.
.
4 ACTIVE 257464 2025/04/08 14:06:20
Cause
During backup, the backup flag was set on the data files, but due to an abnormal shutdown, the flag was not properly cleared before the DB was shut down.
Solutions
1. Execute the backup end command to clear the flag.
[TEST]tibero@tibero1:/home/tibero> tbsql sys/tibero tbSQL 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> alter database end backup; Database altered. SQL> q Disconnected.
2. Execute the shutdown command to stop the database.
[TEST]tibero@tibero1:/home/tibero> tbdown immediate Tibero instance terminated (IMMEDIATE mode). [TEST]tibero@tibero1:/home/tibero> tbboot Listener port = 1521 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode).