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 叫整备。
但并不能作为增量备份的基础。