GaussDB T :如何启动和关闭数据库的归档模式 - ArchiveLog Mode

GaussDB 在创建数据库时，可以指定数据库的归档模式，也可以在创建之后自由修改。

可以通过 V$DATABASE 视图来查看数据库的归档模式：

SQL> select name,log_mode from v$database;

NAME                             LOG_MODE                      
-------------------------------- ------------------------------
GAUSS                            ARCHIVELOG   

修改数据库的归档模式需要在 Mount 状态下进行：

[eygle@enmodb1 ~]$ python /gaussdb/1.0.0/bin/zctl.py -t start -m mount
Successfully started instance.
[eygle@enmodb1 ~]$ zsql / as sysdba -q

connected.


SQL> alter database noarchivelog;

Succeed.

SQL> alter database open;

Succeed.

SQL> select name,log_mode from v$database;

NAME                             LOG_MODE                      
-------------------------------- ------------------------------
GAUSS                            NOARCHIVELOG                  

1 rows fetched.

SQL> shutdown immediate;

Succeed.

SQL> exit

[eygle@enmodb1 ~]$ python /gaussdb/1.0.0/bin/zctl.py -t start -m mount
Successfully started instance.
[eygle@enmodb1 ~]$ zsql / as sysdba -q

connected.


SQL> alter database archivelog;

Succeed.

SQL> alter database open;

Succeed.

SQL> select name,log_mode from v$database;

NAME                             LOG_MODE                      
-------------------------------- ------------------------------
GAUSS                            ARCHIVELOG                    

1 rows fetched.

数据库的归档目录可以通过 V$PARAMETER 视图查看：

SQL> select name,value from v$parameter where name='LOG_ARCHIVE_DEST_1';

NAME                                                             VALUE                                                           
---------------------------------------------------------------- ----------------------------------------------------------------
LOG_ARCHIVE_DEST_1                                               /gaussdb/gaussdata/archive_log