未开启归档模式也可以进行全量或增量备份,它们均为一致备份,在恢复时不需要应用归档日志,在恢复时注意使用NOREDO选项否则报错
When you are recovering a NOARCHIVELOG database, specify the NOREDO option on the RECOVER command to indicate that RMAN does not attempt to apply archived redo logs. Otherwise, RMAN returns an error.
To recover a NOARCHIVELOG database with incremental backups:
- After connecting to the target database and the recovery catalog, place the database in a mounted state:
STARTUP FORCE MOUNT
- Restore and recover the database.
RESTORE DATABASE FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;
- Open the database with the RESETLOGS option.
ALTER DATABASE OPEN RESETLOGS;