目錄

1、表空間備份

2、表空間還原

3、表空間恢復

4、增量還原恢復

---

1、表空間備份

表空間只能在聯機狀態下進行備份。

BACKUP TABLESPACE TBS BACKUPSET '/dm/backup/dm_bak/ts_bak_01';

完全備份

BACKUP TABLESPACE TBS FULL BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';

增量備份

BACKUP TABLESPACE TBS INCREMENT WITH BACKUPDIR '/dm/backup/dm_bak' BACKUPSET '/dm/backup/dm_bak/ts_increment_bak_02';

備份語句中指定的 INCREMENT 參數表示執行的備份類型為增量備份，不可省略。若要創建累積增量備份，還需要指定 CUMULATIVE 參數，否則缺省為差異增量備份。WITH BACKUPDIR 參數用來指定基備份集的搜索目錄，如果基備份集不在默認備份目錄或當前備份目錄則該參數不可省略。

BASE ON BACKUPSET 參數用于增量備份中，用來指定基備份集路徑。如果不指定該參數，會在備份搜索目錄中搜索最近一次的完全備份或增量備份作為這次增量備份的基備份。

BACKUP TABLESPACE TBS BACKUPSET 'ts_full_bak_01';BACKUP TABLESPACE TBS INCREMENT BACKUPSET 'ts_increment_bak_01';BACKUP TABLESPACE TBS INCREMENT BASE ON BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01' BACKUPSET '/dm/backup/dm_bak/ts_increment_bak_02';

上述示例中，增量備份 ts_increment_bak_02 若不指定備份集 ts_full_bak_01 作為基備份，那么默認會使用最近一次的備份集 ts_increment_bak_01 作為基備份。

2、表空間還原

表空間還原的目標庫只能是備份集產生的源庫，否則將報錯。

RMAN>RESTORE DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';

3、表空間恢復

表空間恢復通過重做 REDO 日志，以將數據更新到一致狀態。

RMAN>RECOVER DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS;

4、增量還原恢復

RESTORE DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_increment_bak_02';RECOVER DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS;

SQL> BACKUP TABLESPACE TBS FULL BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';操作已執行已用時間: 00:00:02.961. 執行號:10105.SQL> create table test.tt (t int);操作已執行已用時間: 6.537(毫秒). 執行號:10106.SQL>SQL> BACKUP TABLESPACE TBS INCREMENT BASE ON BACKUPSET 'ts_full_bak_01' BACKUPSET 'ts_increment_bak_02';BACKUP TABLESPACE TBS INCREMENT BASE ON BACKUPSET 'ts_full_bak_01' BACKUPSET 'ts_increment_bak_02';[-10001]:[錯誤碼:-127]無效的備份集目錄[/dm/data/DMDB/bak/ts_full_bak_01].已用時間: 00:00:03.815. 執行號:0.SQL> BACKUP TABLESPACE TBS INCREMENT BASE ON BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01' BACKUPSET '/dm/backup/dm_bak/ts_increment_bak_02';操作已執行已用時間: 00:00:07.704. 執行號:10108.SQL> exit[dmdba@localhost ~]$ dmrmandmrman V8RMAN> RESTORE DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';RESTORE DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';file dm.key not found, use default license!Database mode = 0, oguid = 0Normal of FASTNormal of DEFAULTNormal of RECYCLENormal of KEEPNormal of ROLLEP[0]'s cur_lsn[580682], file_lsn[580682][Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]                                 restore successfully.time used: 00:00:02.413RMAN> RECOVER DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';[-8301]:SQL[RECOVER DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_full_bak_01';]第[1]行，第[55]列[FROM]附近出現錯誤[-2007]:語法分析出錯RMAN> RESTORE DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_increment_bak_02';RESTORE DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS FROM BACKUPSET '/dm/backup/dm_bak/ts_increment_bak_02';Database mode = 0, oguid = 0Normal of FASTNormal of DEFAULTNormal of RECYCLENormal of KEEPNormal of ROLLEP[0]'s cur_lsn[580682], file_lsn[580682][Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]                                 restore successfully.time used: 00:00:02.431RMAN> RECOVER DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS;RECOVER DATABASE '/dm/data/DMDB/dm.ini' TABLESPACE TBS;Database mode = 0, oguid = 0Normal of FASTNormal of DEFAULTNormal of RECYCLENormal of KEEPNormal of ROLLEP[0]'s cur_lsn[580682], file_lsn[580682]dres_backupset_recover_ts begin[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]                               dres_backupset_recover_ts endrecover successfully.time used: 447.118(ms)RMAN>[dmdba@localhost ~]$ disql SYSDBA:5238密碼:服務器[LOCALHOST:5238]:處于普通打開狀態登錄使用時間 : 4.995(ms)disql V8SQL> select * from test.tt;未選定行已用時間: 1.231(毫秒). 執行號:502.SQL> exit

達夢技術社區：https://eco.dameng.com/