一.备份
全备前数据查询
select object_type as "对象类型",count(*) as "数量" from dba_objects group by object_type;
SCH | 9 |
---|---|
TABLE | 73 |
VIEW | 138 |
CLASS | 5 |
TYPE | 4 |
PACKAGE | 42 |
PACKAGE BODY | 41 |
SEQUENCE | 1 |
FUNCTION | 4 |
PROCEDURE | 26 |
CONTEXT | 1 |
SYNONYM | 1 |
CONSTRAINT | 60 |
INDEX | 89 |
DSYNOM | 257 |
联机备份:
backup database;
备份时不加任何参数的话,会在达梦数据库的dm.ini配置文件中的BAK_PATH参数指定的备份目录下备份,备份名为’DB_数据库名_FULL_时间‘,刚才使用最简单全库备份命令‘backup database’备份出来的备份集为
把备份文件传到待还原的服务器上
附常用备份命令例子
BACKUP DATABASE BACKUPSET ‘/dm8/data/DAMENG/bak7/bak_full_20220322’; | 指定备份集路径进行全备 |
---|---|
BACKUP DATABASE TO “FULL_BAK_TEST” BACKUPSET ‘/dm8/data/DAMENG/bak7/test_full_20220322’; | 指定备份集名称进行全备 | </