达梦数据库在线修改redo日志大小及本地归档上限

weixin_44971915

于 2023-07-25 16:08:40 发布

阅读量451

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_44971915/article/details/131920176

版权

1、在线修改redo日志大小

[dmdba@localhost ~]$ disql sysdba:5366
密码:

服务器[LOCALHOST:5366]:处于普通打开状态
登录使用时间 : 3.806(ms)
disql V8
SQL> select PATH,RLOG_SIZE/1024/1024 from v$rlogfile;

行号     PATH                        RLOG_SIZE/1024/1024
---------- --------------------------- --------------------
1          /dm8/dmdata/book/book01.log 256
2          /dm8/dmdata/book/book02.log 256

已用时间: 1.878(毫秒). 执行号:1000.
SQL>

alter database resize logfile '/dm8/dmdata/book/book01.log' to 2048;
alter database resize logfile '/dm8/dmdata/book/book02.log' to 2048;

SQL> select PATH,RLOG_SIZE/1024/1024 from v$rlogfile;

行号     PATH                        RLOG_SIZE/1024/1024
---------- --------------------------- --------------------
1          /dm8/dmdata/book/book01.log 2048
2          /dm8/dmdata/book/book02.log 2048

已用时间: 1.433(毫秒). 执行号:1200.

2、在线修改设置归档上限：

SQL> select * from v$dm_arch_ini;

行号     ARCH_NAME      ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT ARCH_HANG_FLAG ARCH_TIMER_NAME
---------- -------------- --------- --------- -------------- ---------------- -------------- ---------------
           ARCH_IS_VALID ARCH_WAIT_APPLY ARCH_INCOMING_PATH ARCH_CURR_DEST ARCH_FLUSH_BUF_SIZE ARCH_RESERVE_TIME
           ------------- --------------- ------------------ -------------- ------------------- -----------------
           ARCH_LOCAL_SHARE ARCH_LOCAL_SHARE_CHECK ARCH_SEND_DELAY ARCH_DEST_IP ARCH_DEST_PORT ARCH_DEST_ID
           ---------------- ---------------------- --------------- ------------ -------------- ------------
           ARCH_ASM_MIRROR ARCH_ASM_STRIPING ARCH_RECOVER_TIME ARCH_CENTER_ID ARCH_FAILOVER ARCH_SUBSCRIBE_MODE
           --------------- ----------------- ----------------- -------------- ------------- -------------------
           ARCH_THRESHOLD_PER_SECOND
           -------------------------
1          ARCHIVE_LOCAL1 LOCAL     /dm8/arch 2048           0                1              NULL
           Y             NULL            NULL               /dm8/arch      0                   0
           0                0                      0               NULL         NULL           NULL
           NULL            NULL              NULL              NULL           NULL          NULL
           NULL


已用时间: 0.720(毫秒). 执行号:1202.
SQL>    alter database modify archivelog 'DEST= /dm8/arch,TYPE=LOCAL,FILE_SIZE=2048,SPACE_LIMIT=30720';
操作已执行
已用时间: 0.508(毫秒). 执行号:0.
SQL>  select * from v$dm_arch_ini;

行号     ARCH_NAME      ARCH_TYPE ARCH_DEST ARCH_FILE_SIZE ARCH_SPACE_LIMIT ARCH_HANG_FLAG ARCH_TIMER_NAME
---------- -------------- --------- --------- -------------- ---------------- -------------- ---------------
           ARCH_IS_VALID ARCH_WAIT_APPLY ARCH_INCOMING_PATH ARCH_CURR_DEST ARCH_FLUSH_BUF_SIZE ARCH_RESERVE_TIME
           ------------- --------------- ------------------ -------------- ------------------- -----------------
           ARCH_LOCAL_SHARE ARCH_LOCAL_SHARE_CHECK ARCH_SEND_DELAY ARCH_DEST_IP ARCH_DEST_PORT ARCH_DEST_ID
           ---------------- ---------------------- --------------- ------------ -------------- ------------
           ARCH_ASM_MIRROR ARCH_ASM_STRIPING ARCH_RECOVER_TIME ARCH_CENTER_ID ARCH_FAILOVER ARCH_SUBSCRIBE_MODE
           --------------- ----------------- ----------------- -------------- ------------- -------------------
           ARCH_THRESHOLD_PER_SECOND
           -------------------------
1          ARCHIVE_LOCAL1 LOCAL     /dm8/arch 2048           30720            1              NULL
           Y             NULL            NULL               /dm8/arch      0                   0
           0                0                      0               NULL         NULL           NULL
           NULL            NULL              NULL              NULL           NULL          NULL
           NULL


已用时间: 1.474(毫秒). 执行号:1203.
SQL> select STATUS$ from v$database;

行号     STATUS$
---------- -----------
1          4

已用时间: 0.744(毫秒). 执行号:1204.
SQL>