GBase 8s 学习笔记 005 —— GBase 8s 运行模式与切换

GBase 8s的四种运行模式

离线模式

不能执行任何操作

shared memory not initialized for GBASEDBTSERVER ‘gbaseserver’（执行数据库管理员命令时）
908: Attempt to connect to database server (gbaseserver) failed.（执行数据库SQL操作时）

执行dbaccess时，可以出现菜单，选择数据库出现RUNNING后，一段时间报错。

在线模式

可以执行各种操作。

单用户模式

可以执行SQL操作和命令行维护操作。只能管理员（GBASEDBT / DBSA）连接，其它普通用户不能连接。

27010: Only an administrative user can connect in administrative user mode.

静态模式

只能执行命令行维护操作（如备份数据库）。

不能执行SQL命令（27002: No connections are allowed in quiescent mode.）

GBase 8s的3种过渡状态。

• 初始化（Initialization）
• 快速恢复（Fast Recovery）
• 关闭（Shutting Down）

GBase 8s的模式转换

GBase 8s 可从一个运行模式,转换到另一个运行模式。

离线转单用户

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[gbasedbt@192 ~]$ oninit -j
Your evaluation license will expire on 2024-02-07 00:00:00
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Single-User -- Up 00:00:17 -- 597864 Kbytes
[gbasedbt@192 ~]$

单用户转在线

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Single-User -- Up 00:02:04 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -m
Your evaluation license will expire on 2024-02-07 00:00:00
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:02:22 -- 597864 Kbytes

[gbasedbt@192 ~]$

离线转在线

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[gbasedbt@192 ~]$ oninit
Your evaluation license will expire on 2024-02-07 00:00:00
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:00:12 -- 597864 Kbytes

[gbasedbt@192 ~]$

离线转静态

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[gbasedbt@192 ~]$ oninit -s
Your evaluation license will expire on 2024-02-07 00:00:00
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Quiescent -- Up 00:00:13 -- 597864 Kbytes

[gbasedbt@192 ~]$

静态转在线

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Quiescent -- Up 00:01:28 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -m
Your evaluation license will expire on 2024-02-07 00:00:00
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:01:43 -- 597864 Kbytes

[gbasedbt@192 ~]$

在线转单用户

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:02:48 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -j
Your evaluation license will expire on 2024-02-07 00:00:00
This will change mode to single user. Only DBSA/gbasedbt can connect
in this mode.
Do you wish to continue (y/n)? y

All threads which are not owned by DBSA/gbasedbt will be killed.
Do you wish to continue (y/n)? y
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Single-User -- Up 00:03:09 -- 597864 Kbytes

[gbasedbt@192 ~]$

单用户转离线

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Single-User -- Up 00:04:29 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -k
Your evaluation license will expire on 2024-02-07 00:00:00

This will take GBase Database Server OFF-LINE -
Do you wish to continue (y/n)? y

There are 0 user threads that will be killed.
Do you wish to continue (y/n)? y
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[gbasedbt@192 ~]$

在线转离线

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:00:20 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -k
Your evaluation license will expire on 2024-02-07 00:00:00

This will take GBase Database Server OFF-LINE -
Do you wish to continue (y/n)? y

There are 0 user threads that will be killed.
Do you wish to continue (y/n)? y
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[gbasedbt@192 ~]$

在线转静态

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:00:19 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -s
Your evaluation license will expire on 2024-02-07 00:00:00

This will perform a GRACEFUL SHUTDOWN -
Do you wish to continue (y/n)? y
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Quiescent -- Up 00:00:44 -- 597864 Kbytes

[gbasedbt@192 ~]$

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
On-Line -- Up 00:02:16 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -u
Your evaluation license will expire on 2024-02-07 00:00:00

This will perform an IMMEDIATE SHUTDOWN -
Do you wish to continue (y/n)? y

There are 0 user threads that will be killed.
Do you wish to continue (y/n)? y
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Quiescent -- Up 00:02:28 -- 597864 Kbytes

[gbasedbt@192 ~]$

静态转离线

[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
Quiescent -- Up 00:03:53 -- 597864 Kbytes

[gbasedbt@192 ~]$ onmode -k
Your evaluation license will expire on 2024-02-07 00:00:00

This will take GBase Database Server OFF-LINE -
Do you wish to continue (y/n)? y

There are 0 user threads that will be killed.
Do you wish to continue (y/n)? y
[gbasedbt@192 ~]$ onstat -
Your evaluation license will expire on 2024-02-07 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
[gbasedbt@192 ~]$

GBase 8s的模式转换状态表