Mimer Database is OFFLINE

If you get the following error when using Oasis with multiple workstations.

 

image-20240521-205247.png

Steps to bring the database ONLINE again.

Backup the data directory (NB).

Open a Command Prompt – Start, Run, Cmd and <Enter>

At a command prompt type:BSQL OASIS <Enter>

The system will display a Mimer login. Login as “sysadm” using password “12345pass” and then <Enter>.

You will be presented with an SQL> prompt.

Type: SET DATABASE ONLINE PRESERVE LOG; <Enter>