GaussDB 在创建数据库时,可以指定数据库的归档模式,也可以在创建之后自由修改。
可以通过 V$DATABASE 视图来查看数据库的归档模式:
SQL> select name,log_mode from v$database;
NAME LOG_MODE
GAUSS ARCHIVELOG
修改数据库的归档模式需要在 Mount 状态下进行:
[omm@enmodb1 ~]$ python /opt/gaussdb/gassdb100/bin/zctl.py -t start -m mount
Successfully started instance.
[omm@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
[omm@enmodb1 ~]$ python /opt/gaussdb/gassdb100/bin/zctl.py -t start -m mount
Successfully started instance.
[omm@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 /opt/gaussdb/data/archive_log
1 rows fetched.