CNDBA社区
达梦数据库的dmmdf 工具可以对DM相关的文件的属性进行修改。 从dmmdf的帮助可以看出，支持的修改的文件类型有：dbf、rlog、original bak、bakset meta、bakset bkp、bakset，根据文件的不同，可修改的属性也有所不同，最主要的就是修改db_magic。
帮助如下：
[dave@www.cndba.cn dmarch]$ dmmdf help
Format: ./dmmdf KEYWORD=value
Example: ./dmmdf TYPE=1 FILE=/opt/data/DAMENG/SYSTEM.DBF
Keyword Explanation
--------------------------------------------------------------------------------
TYPE type
1: for dbf
2: for rlog
3: for original bak
4: for bakset meta
5: for bakset bkp
6: for bakset
7: batch modify db_magic for arch file
8: for database degrades
9:batch modify crc_check for DB specified by dm.ini.
10:batch modify crc_check for archive log in archive directory.
FILE file path
DCR_INI dmdcr.ini path
DB_MAGIC_SRC db_magic_src,for TYPE=7 and 10
DB_MAGIC_DST db_magic_dst,for TYPE=7
CRC_CHECK crc_check,for TYPE=9 and 10
HELP show this help info
--------------------------------------------------
Example: ./dmmdf TYPE=1 FILE=/opt/data/DAMENG/SYSTEM.dbf
./dmmdf TYPE=2 FILE=/opt/data/DAMENG/DAMENG01.log
./dmmdf TYPE=3 FILE=/opt/data/DAMENG/bak/dmdb.bak
./dmmdf TYPE=4 FILE=/opt/data/DAMENG/bak/bset/nbak.meta
./dmmdf TYPE=5 FILE=/opt/data/DAMENG/bak/bset/nbak.bak
./dmmdf TYPE=6 FILE=/opt/data/DAMENG/bak/bset
./dmmdf TYPE=7 FILE=/opt/data/DAMENG/arch DB_MAGIC_SRC=4734373 DB_MAGIC_DST=4734366
./dmmdf TYPE=8 FILE=/opt/data/DAMENG/dm.ctl
./dmmdf TYPE=9 FILE=/opt/data/DAMENG/dm.ini,CRC_CHECK=1
./dmmdf TYPE=10 FILE=/opt/data/DAMENG/arch£¬CRC_CHECK=0£¬DB_MAGIC_SRC=4734373
[dave@www.cndba.cn dmarch]$
修改数据文件：
[dave@www.cndba.cn dave_for_restore]$ pwd
/dm/dave_for_restore
[dave@www.cndba.cn dave_for_restore]$ ls
MAIN.DBF ROLL.DBF SYSTEM.DBF
[dave@www.cndba.cn dave_for_restore]$
[dave@www.cndba.cn dave_for_restore]$ dmmdf TYPE=1 FILE=/dm/dave_for_restore/SYSTEM.DBF
dmmdf V7.6.0.95-Build(2018.09.13-97108)ENT
**********************************************************
1 db_magic=1232911348
2 next_trxid=1762
3 pemnt_magic=1196983552
**********************************************************
#注意这里让我们选择修改的类型：
Please input which parameter you want to change(1-3), q to quit: 1
Please input new value: 88888888
**********************************************************
1 db_magic=88888888
2 next_trxid=1762
3 pemnt_magic=1196983552
**********************************************************
Do you want to save the change to file (y/n): y
Save to file success!
[dave@www.cndba.cn dave_for_restore]$
修改日志文件：
[dave@www.cndba.cn dmarch]$ pwd
/dm/dmarch
[dave@www.cndba.cn dmarch]$ ll
total 1432
-rw-r--r-- 1 dmdba dinstall 727040 Mar 6 18:11 ARCHIVE_LOCAL1_20290306172851155_0.log
-rw-r--r-- 1 dmdba dinstall 535552 Mar 6 21:00 ARCHIVE_LOCAL1_20290306181633020_0.log
-rw-r--r-- 1 dmdba dinstall 187904 Mar 6 21:03 ARCHIVE_LOCAL1_20290306210016425_0.log
-rw-r--r-- 1 dmdba dinstall 34 Mar 6 18:16 dmsql.buf1867483855255607.buf
[dave@www.cndba.cn dmarch]$ dmmdf TYPE=2 FILE=/dm/dmarch/ARCHIVE_LOCAL1_20290306210016425_0.log
dmmdf V7.6.0.95-Build(2018.09.13-97108)ENT
**********************************************************
1 sig = DMALOG
2 ver = 7004
3 chksum = 0
4 dbversion = 0x7000a
5 sta = 1
6 n_magic = 0
7 db_magic = -155201878
8 clsn_fil = 0
10 next_seq = 1396
11 arch_seq = 1038
12 len = 187904
13 free = 187904
14 clsn = 201449
15 clsn_off = 4096
16 arch_lsn = 197096
17 pemnt_magic = 1196983552
18 fil_id = 0
19 crc_check = 1
**********************************************************
#注意这里能修改的类型：
You can only reset sta(5) or db_magic (7) or clsn (14) or pemnt_magic(17) or fil_id(18).
Please input the num which one you want to change, q to quit: 7
Input the new value: 88888888
**********************************************************
1 sig = DMALOG
2 ver = 7004
3 chksum = 0
4 dbversion = 0x7000a
5 sta = 1
6 n_magic = 0
7 db_magic = 88888888
8 clsn_fil = 0
10 next_seq = 1396
11 arch_seq = 1038
12 len = 187904
13 free = 187904
14 clsn = 201449
15 clsn_off = 4096
16 arch_lsn = 197096
17 pemnt_magic = 1196983552
18 fil_id = 0
19 crc_check = 1
**********************************************************
Do you want to quit and save the change to file (y/n): y
Save to file success!
[dave@www.cndba.cn dmarch]$
修改备份集的信息：
[dave@www.cndba.cn db_full_bak_for_restore]$ pwd
/dm/dm_bak/db_full_bak_for_restore
[dave@www.cndba.cn db_full_bak_for_restore]$ ll
total 10844
-rw-r--r-- 1 dmdba dinstall 415232 Mar 6 15:05 db_full_bak_for_restore_1.bak
-rw-r--r-- 1 dmdba dinstall 10606592 Mar 6 15:05 db_full_bak_for_restore.bak
-rw-r--r-- 1 dmdba dinstall 74240 Mar 6 21:00 db_full_bak_for_restore.meta
[dave@www.cndba.cn db_full_bak_for_restore]$ dmmdf TYPE=4 FILE=/dm/dm_bak/db_full_bak_for_restore/db_full_bak_for_restore.meta
dmmdf V7.6.0.95-Build(2018.09.13-97108)ENT
**********************************************************
1 sig = BA
2 db_magic = 1232911348
3 type = 0
4 range = 1
5 level = 0
6 compress_level = 0
7 encrypt_type = 0
8 encpypt_id = 1184477142
9 bakfile_num = 2
10 dbfile_num = 4
11 oguid = 0
12 sguid = 8048991
**********************************************************
You can only reset db_magic (2).
Please input the num which one you want to change, q to quit: 2
Input the new value: 8888888
**********************************************************
1 sig = BA
2 db_magic = 8888888
3 type = 0
4 range = 1
5 level = 0
6 compress_level = 0
7 encrypt_type = 0
8 encpypt_id = 1184477142
9 bakfile_num = 2
10 dbfile_num = 4
11 oguid = 0
12 sguid = 8048991
**********************************************************
Do you want to quit and save the change to file (y/n): y
Save to file success!
[dave@www.cndba.cn db_full_bak_for_restore]$
版权声明：本文为博主原创文章，未经博主允许不得转载。
