达梦V8联机开启归档和关闭归档

开启归档

SQL>  select ARCH_MODE,STATUS$ from v$database;

LINEID     ARCH_MODE STATUS$    
---------- --------- -----------
1          N         4

used time: 2.126(ms). Execute id is 500.
SQL> 
SQL> 
SQL> 
SQL> alter database mount;
executed successfully
used time: 1.212(ms). Execute id is 0.
SQL> ALTER DATABASE ADD ARCHIVELOG 'DEST=/dm8/arch, TYPE=local, FILE_SIZE=1024, SPACE_LIMIT=2048';
executed successfully
used time: 0.931(ms). Execute id is 0.
SQL> ALTER DATABASE ARCHIVELOG;
executed successfully
used time: 4.335(ms). Execute id is 0.
SQL> ALTER DATABASE OPEN;
executed successfully
used time: 10.069(ms). Execute id is 0.
SQL> select ARCH_MODE,STATUS$ from v$database;

LINEID     ARCH_MODE STATUS$    
---------- --------- -----------
1          Y         4

used time: 0.677(ms). Execute id is 501.
SQL> 

检查dm.ini和dmarch.ini配置文件

[dmdba@dmdb1 OA]$ cat dm.ini |grep ARCH_
                ARCH_INI                        = 1                     #dmarch.ini
[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ cat dmarch.ini
#DaMeng Database Archive Configuration file
#this is comments

[ARCHIVE_LOCAL1]
        ARCH_TYPE            = LOCAL        
        ARCH_DEST            = /dm8/arch        
        ARCH_FILE_SIZE       = 1024        
        ARCH_SPACE_LIMIT     = 2048        
        ARCH_FLUSH_BUF_SIZE  = 0        
        ARCH_HANG_FLAG       = 1        

[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ 

数据相关视图

SQL> select * from v$arch_status;

LINEID     ARCH_TYPE ARCH_DEST ARCH_STATUS ARCH_SRC  
---------- --------- --------- ----------- ----------
1          LOCAL     /dm8/arch VALID       OADBSERVER

used time: 0.560(ms). Execute id is 506.
SQL> 
SQL> select * from v$dm_arch_ini;

LINEID     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
           ------------------- ----------------- ---------------- ---------------------- ---------------
1          ARCHIVE_LOCAL1 LOCAL     /dm8/arch 1024           2048             1              NULL            Y             NULL            NULL               /dm8/arch
           0                   0                 0                0                      0


used time: 0.585(ms). Execute id is 505.
SQL> 

关闭归档

SQL> select ARCH_MODE,STATUS$ from v$database;

LINEID     ARCH_MODE STATUS$    
---------- --------- -----------
1          Y         4

used time: 0.677(ms). Execute id is 501.
SQL> 
SQL> 
SQL>  alter database mount;
executed successfully
used time: 4.498(ms). Execute id is 0.
SQL> ALTER DATABASE noarchivelog;
executed successfully
used time: 35.259(ms). Execute id is 0.
SQL>  ALTER DATABASE OPEN;
executed successfully
used time: 9.043(ms). Execute id is 0.
SQL> select ARCH_MODE,STATUS$ from v$database;

LINEID     ARCH_MODE STATUS$    
---------- --------- -----------
1          N         4

used time: 0.548(ms). Execute id is 502.
SQL> 

检查dm.ini和dmarch.ini配置文件

[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ cat dm.ini |grep ARCH_
                ARCH_INI                        = 0                     #dmarch.ini
[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ cat dmarch.ini        
#DaMeng Database Archive Configuration file
#this is comments

[ARCHIVE_LOCAL1]
        ARCH_TYPE            = LOCAL        
        ARCH_DEST            = /dm8/arch        
        ARCH_FILE_SIZE       = 1024        
        ARCH_SPACE_LIMIT     = 2048        
        ARCH_FLUSH_BUF_SIZE  = 0        
        ARCH_HANG_FLAG       = 1        

[dmdba@dmdb1 OA]$ 

dmarch.ini配置也清空

SQL> 
SQL> select * from v$arch_status;

LINEID     ARCH_TYPE ARCH_DEST ARCH_STATUS ARCH_SRC  
---------- --------- --------- ----------- ----------
1          LOCAL     /dm8/arch VALID       OADBSERVER

used time: 0.560(ms). Execute id is 506.
SQL> alter database mount;
executed successfully
used time: 3.315(ms). Execute id is 0.

SQL>  ALTER DATABASE NOARCHIVELOG;   
executed successfully
used time: 35.285(ms). Execute id is 0.
SQL>
SQL> ALTER DATABASE delete ARCHIVELOG 'DEST=/dm8/arch, TYPE=local, FILE_SIZE=1024, SPACE_LIMIT=2048';
executed successfully
used time: 0.585(ms). Execute id is 0.
SQL>  ALTER DATABASE open;
executed successfully
used time: 10.230(ms). Execute id is 0.
SQL> select * from v$dm_arch_ini;
no rows

used time: 0.565(ms). Execute id is 507.
SQL>  select * from v$arch_status;
no rows

used time: 0.504(ms). Execute id is 508.
SQL> 

[dmdba@dmdb1 OA]$ 
[dmdba@dmdb1 OA]$ cat dmarch.ini
#DaMeng Database Archive Configuration file
#this is comments

        ARCH_WAIT_APPLY      = 0        

[dmdba@dmdb1 OA]$ 

达梦在线服务平台：https://eco.dameng.com