Skip to main content

Search

Welcome to Tibero GTS!

Issue of Starting in MOUNT Mode After Abnormal DB Shutdown and Restart

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).

 

 

 

Related to