Recovering a NOARCHIVELOG Database with Incremental Backups

未开启归档模式也可以进行全量或增量备份，它们均为一致备份，在恢复时不需要应用归档日志，在恢复时注意使用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:

1. After connecting to the target database and the recovery catalog, place the database in a mounted state:

STARTUP FORCE MOUNT

1. Restore and recover the database.

RESTORE DATABASE FROM TAG "consistent_whole_backup";

RECOVER DATABASE NOREDO;

1. Open the database with the RESETLOGS option.

ALTER DATABASE OPEN RESETLOGS;