Each Oracle database has a redo log. This redo log records all changes made in datafiles. When you run your database in NOARCHIVELOG mode, you disable the archiving of the redo log.
By default, No Redo Log is disabled. Consequently, while restoring the database, RMAN searches for archived re-do logs after applying incremental backup data. Setting No Redo Logs enables the RMAN to suppress the archived re-do logs so that only data from incremental backups is restored. Enable No Redo Logs when you perform a point-in-time restore of a database that was backed up in NOARCHIVELOG mode.
Use the following steps to enable No Redo Logs and perform a restore operation:
-
From the CommCell Browser, go to Client Computers > client > Oracle.
-
Right-click the instance, then go to All Tasks > Browse and Restore.
The Browse and Restore Options dialog box appears.
-
Select Latest Backup, and then click the View Content button.
-
Optional: Use non-default browse and restore options. For more information, see Browse and Restore.
-
Select the database, and then click the Recover All Selected button.
The Oracle Restore Options dialog box appears.
-
Depending on the type of restore to be run, click Restore in place or Restore out of place, and then click Next.
The Oracle In Place Restore Options or Oracle Out of Place Restore Options dialog box appears.
-
Click Advanced.
The Advanced Restore Options dialog box appears.
-
On the Options tab, select the No Redo Logs check box.
-
On the Copy Precedence tab, select the Restore from Copy Precedence check box.
-
In the Copy Precedence box, type the copy precedence number for the backup copy.
-
Click OK.
-
Click OK.