Database state

To restore or recover a database, it must be offline. You can choose to automatically change the state of a database.

Select Take the database OFFLINE BEFORE restore/recover starts to shutdown and startup, in a mount state, the target database before the restore/recover is started.

Select Bring the database ONLINE AFTER restore/recover completes to shutdown and startup, in an open state, the target database after the restore/recover successfully completes.

Incomplete recovery differs in several ways from complete recovery. The most important difference is that incomplete recovery requires you to open the database with the RESETLOGS option. Using this option gives the online redo logs a new timestamp and SCN, thereby eliminating the possibility of corrupting your datafiles by the application of obsolete archived redo logs.

Select Reset logs on database open to open the database with the RESETLOGS option. If you are performing a Point In Time (PIT) recovery and you select Bring the database ONLINE AFTER restore/recovery completes, the wizard automatically enforces the Reset logs on database open option because Oracle needs the logs to be reset.

The Oracle database initialization parameter file contains information to initialize the database and instance. It is used here when the target database is started in the mount or open state. Starting with Oracle 9i, initialization parameters can also be maintained in a binary server parameter file (SPFILE). Do not enter a parameter file name if you are using an SPFILE.

For information on database states, as they pertain to recovery, refer to the Oracle Backup and Recovery Guide.