Oracle 备份与还原

1. 全备、整备、增备、镜像备

0级整镜像备:

BACKUP  FOR RECOVER OF COPY database;

增量1 的镜像备:

BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY database;
Note

说明:镜像备份无法加压缩

整备:备份database 某一部分并是全部数据叫整备。
0级备份片整备

BACKUP AS COMPRESSED BACKUPSET DATABASE;

1级备份片整备

BACKUP INCREMENTAL LEVEL 1  AS COMPRESSED BACKUPSET DATABASE;

全备:
说明:备份归档日志,control file ,database ,spfile 叫整备。
但并不能作为增量备份的基础。