Recovering a NOARCHIVELOG Database with Incremental Backups

Restore of a database running in NOARCHIVELOG mode is similar to restore of a database in ARCHIVELOG mode. The main differences are:

• Only consistent backups can be used in restoring a database in NOARCHIVELOG mode.
  
• Media recovery is not possible because no archived redo logs exist.
  

You can perform limited recovery of changes to a database running in NOARCHIVELOG mode by applying incremental backups. The incremental backups must be consistent, like all backups of a database run in NOARCHIVELOG mode, so you cannot make backups of the database when it is open.
When recovering a NOARCHIVELOG database, specify the NOREDO option on the RECOVER command to indicate that RMAN should not attempt to apply archived redo logs. Otherwise, RMAN returns an error.

To recover a NOARCHIVELOG database with incremental backups:

After connecting to trgt and the catalog database, place the database in a mounted state:

STARTUP FORCE MOUNT

Restore and recover the database.
For example, you can perform incomplete recovery with the following commands:

RESTORE DATABASE 
  FROM TAG "consistent_whole_backup";
RECOVER DATABASE NOREDO;

Open the database with the RESETLOGS option.
For example, enter the following command:

ALTER DATABASE OPEN RESETLOGS;