达梦数据库日期格式化_达梦数据库更换磁盘路径、空间不足问题处理

注意事项：

1. 所有操作，涉及到的目录，请确保 dmdba 均有权限

2. 备份命令详细语法，可以参考 help 等

3. 恢复完后，注意不要启动错了，请启动恢复后的数据库实例(即新的数据库实例)

[dmdba@localhost ~]# ps   -ef|grep dmserver

dmdba      1605  1485    8 03:30 pts/0    00:00:04   ./dmserver /opt/dmdata/DAMENG/dm.ini

dmdba      1713  1662    0 03:31 pts/1    00:00:00 grep   –color=auto dmserver

[dmdba @localhost ~]#

— 停掉数据库服务

— 进行脱机备份

[dmdba@localhost ~]#   cd  /opt/dmdbms/bin

[dmdba@localhost bin]#   ./dmbackup help

Format:  ./dmbackup  KEYWORD=value

Example: ./dmbackup    INI_PATH=/opt/dm7data/dameng/dm.ini NAME=test.bak

Imperative Argument: INI_PATH NAME

Keyword               explain(default value)

——————————————————————————–

INI_PATH            the path of   dmserver’s dm.ini file

BASE_BAK_DIR        the path   with increment backup Format (dir1,dir2,dir3,…)

NAME                backup name

TYPE                backup type (FULL, INCREMENT),   Default(FULL)

BAKFILE_PATH        the file   path of backup file

DESCRIBE            the   description of backup

MAXSIZE             the max   value capability of the single backup file Default(33MB~2048MB, default(2048))

ENCRYPT             encrypt   type (0, 1, 2), Default(0)

PASSWORD            encrypt key

ENCRYPT_NAME        encrypt   algorithm name

COMPRESS            compress   level(0-9), 0:no compress, 9:high compress, Default(1)

PARALLEL            parallel   mapping the file path

SHOW_BAK_INFO       the   directory of backup Format (dir1,dir2,dir3,…)

HELP                output help   info

[dmdba@localhost bin]# ./dmbackup  ini_path=/opt/dmdata/DAMENG/dm.ini   name=test.bak

backup V7.6.0.138-Build(2019.02.20-103049)ENT

file dm.key not found, use default license!

ndct db load finished

start backup tablespace: SYSTEM.

start backup file: /opt/dmdata/DAMENG/SYSTEM.DBF, pages: 2688

end backup file: /opt/dmdata/DAMENG/SYSTEM.DBF

end backup tablespace: SYSTEM.

start backup tablespace: ROLL.

start backup file: /opt/dmdata/DAMENG/ROLL.DBF, pages: 0

end backup file: /opt/dmdata/DAMENG/ROLL.DBF

end backup tablespace: ROLL.

start backup tablespace: MAIN.

start backup file: /opt/dmdata/DAMENG/MAIN.DBF, pages: 0

end backup file: /opt/dmdata/DAMENG/MAIN.DBF

end backup tablespace: MAIN.

backup fun end time used: 1064.291(ms)

backup successfully!

backup time used: 7244.440(ms)

— 在新路径下初始化数据库

[dmdba@localhost bin]#   ./dminit path=/dmbigdata

initdb V7.6.0.138-Build(2019.02.20-103049)ENT

db version: 0x7000a

file dm.key not found, use default license!

License will expire on 2020-02-20

log file path:   /dmbigdata/DAMENG/DAMENG01.log

log file path:   /dmbigdata/DAMENG/DAMENG02.log

write to dir [/dmbigdata/DAMENG].

create dm database success. 2019-10-18 03:34:42

— 在新路径下恢复数据库(因为数据库恢复必须恢复到一个已经存在数据库上)

[dmdba@localhost bin]#   ./dmrestore  help

Format: DMRESTORE    KEYWORD=value or KEYWORD=(value1,value2,…,valueN)

Eg: DMRESTORE    INI_PATH=/opt/dm7data/dameng/dm.ini FILE=/opt/dm7data/backup/test.bak

Imperative Argument: FILE

Keyword               explain(default value)

——————————————————————————–

INI_PATH            the path of   the dmserver’s dm.ini file

FILE                backup file

MAPPED_FIL          the path of mapped file, when   res_type assign 4.

TIME                the   timestamp of be going to recover

ARCHIVE_DIR         the   directory at backup, Format (dir1,dir2,dir3,…)

BACKUP_DIR          the stored   path of backup file, be used to search backup file, Format   (dir1,dir2,dir3,…)

DATAFIL_PATH        the file   path at the recovery, Format (id1,path1,id2,path2,id3,path3,…)

MIRROR_PATH         the mirror   file path at the recovery, Format (id1,path1,id2,path2,id3,path3,…)

PARALLEL_DIR        the full   path of parallel mapping file

RES_TYPE            restore   type(0,1,2,3,4), 0: bakfil restore, 1: bakfil show, 2: archfil restore, 3:   step increment restore, 4:output mapped file default(0)

END_LSN             restore to   end_lsn

LOG                 restore   output log file

DUMMY               quiet mode,   {(Y)es,(N)o} default:No

PASSWORD            restore   with password

ENCRYPT_NAME        restore   decrypt with encrypt name

HELP                output help   info

— 这里的 file ，就是备份生成的文件

[root@localhost bin]#   ./dmrestore    ini_path=/dmbigdata/DAMENG/dm.ini   file=/opt/dmdata/DAMENG/bak/DB_DAMENG_20191018033424000722.bak

restore V7.6.0.138-Build(2019.02.20-103049)ENT

file dm.key not found, use default license!

backup sig:            BA

backup tool version:   12595

backup db name:        DAMENG

backup db magic:         339279924

backup pemnt magic:      -222693460

backup name:           test.bak

backup type:           full

backup level:          offline

backup range:          database

backup description:

compressed level:      0

encrypt_type:          0

encrypt_id:            2052

rac node:              0

page check:            0

rlog encrypt:          0

external cipher id:    0

external hash id:      0

length in char:        0

use new hash:          1

backup time:             2019-10-18 03:34:24

page size:             8 KB

extent size:           16

case sensitive:        1

log page size:         512 B

charset:               0

data version:          0x7000A

sys version:             V7.1.6.138-Build(2019.02.20-103049)ENT

enable policy:         0

mpp_timestamp:         0

crc_check:             TRUE

parallel type:         0

parallel info len:     0

backup db fil num:     3

archive flag:          0

after backup LSN:      39863

$bak_seq |$file_path                                          |$size(K)       |$used(K)

1|/opt/dmdata/DAMENG/bak/DB_DAMENG_20191018033424000722.bak|       32768.00|        5366.00

$file_seq |$type|$ts_name         |$state    |$size(K)  |$seq_in_bak    |$off_in_bak(B) |$len_in_bak(B)   |$file_path                                          |$mirror_path

1|DBF  |SYSTEM         |ONLINE    |       21504|              1|          22528|          5152768|/opt/dmdata/DAMENG/SYSTEM.DBF                     |

2|DBF  |ROLL           |ONLINE    |      131072|              1|        5175296|         311296|/opt/dmdata/DAMENG/ROLL.DBF                       |

3|DBF  |MAIN           |ONLINE    |      131072|              1|        5486592|             8192|/opt/dmdata/DAMENG/MAIN.DBF                       |

n 这里需要输入 y 或者 Y

Continue?[Y/N]: y

restore bak_file:   /opt/dmdata/DAMENG/bak/DB_DAMENG_20191018033424000722.bak …

start restore database…

start restore file: /dmbigdata/DAMENG/SYSTEM.DBF(SYSTEM), pages: 629

end restore file: /dmbigdata/DAMENG/SYSTEM.DBF(SYSTEM)

start restore file: /dmbigdata/DAMENG/ROLL.DBF(ROLL), pages: 38

end restore file: /dmbigdata/DAMENG/ROLL.DBF(ROLL)

start restore file: /dmbigdata/DAMENG/MAIN.DBF(MAIN), pages: 1

end restore file: /dmbigdata/DAMENG/MAIN.DBF(MAIN)

end restore database data files.

Apply archive log LSN from 39864 to 39863, time used:0.000s.

restore finished, code = 0!

restore successfully!

restore time used: 2166.080(ms)

[dmdba@localhost bin]#

— 在启动数据库，即完成了替换

[dmdba@localhost bin]# ps   -ef|grep dmserver

dmdba      1781  1485    0 03:35 pts/0    00:00:00   ./dmserver /dmbigdata/DAMENG/dm.ini

dmdba      1840  1662    0 03:39 pts/1    00:00:00 grep   –color=auto dmserver

[dmdba@localhost bin]#