DM8数据库备份与恢复 DMRMAN

目录

打开DM8数据库的归档模式

一次性备份以及脚本

备份结果：

定时调度备份

恢复数据库

恢复脚本：

---

1. 打开DM8数据库的归档模式

SQL> select ARCH_MODE from v$database;

LINEID     ARCH_MODE
---------- ---------
1          Y

used time: 1.335(ms). Execute id is 64.

 

1. 一次性备份以及脚本

全库备份

backup database full to "DB_dm1_FULL_2020_03_02_20_30_13" backupset 'DB_dm1_FULL_2020_03_02_20_30_13' backupinfo '/dm/dmbak/';

全库增量备份

backup database increment to "DB_dm1_INCRE_2020_03_02_21_20_24" backupset 'DB_dm1_INCRE_2020_03_02_21_20_24' backupinfo '/dm/dmbak/';
 

备份表
backup table "TEST"."TEST" to "TAB_TEST_TEST_2020_03_02_21_25_58" backupset 'TAB_TEST_TEST_2020_03_02_21_25_58' backupinfo '/dm/dmbak/';

备份表空间

backup tablespace "MAIN" full to "TS_MAIN_FULL_2020_03_02_21_26_57" backupset 'TS_MAIN_FULL_2020_03_02_21_26_57' backupinfo '/dm/dmbak/';

备份所有归档日志

backup archivelog all to "ARCH_2020_03_02_21_27_25" backupset 'ARCH_2020_03_02_21_27_25' backupinfo '/dm/dmbak/';

备份归档日志以LSN between

backup archivelog lsn between 12 and 23 to "ARCH_2020_03_02_21_27_25" backupset 'ARCH_2020_03_02_21_27_25' backupinfo '/dm/dmbak/';

备份归档日志以 from lsn

backup archivelog from lsn 12 to "ARCH_2020_03_02_21_27_25" backupset 'ARCH_2020_03_02_21_27_25' backupinfo '/dm/dmbak/';

备份归档日志以 from time

backup archivelog from time '2020-03-02 21:27:25' to "ARCH_2020_03_02_21_27_25" backupset 'ARCH_2020_03_02_21_27_25' backupinfo '/dm/dmbak/';

备份归档日志以 time between

backup archivelog time