Database state needed for the restore process

Contributors NetAppZacharyWambold akseldavis

The state of the database that is to be restored depends on the type of restore process that you want to perform and the type of files that are to be included.

The following table lists the state in which the database should be depending on the restore option selected and the type of files you want to include in the restore:

Type of restore

Files included

Database state for this instance

Restore only

Control files

Shutdown

System files

Mount or Shutdown

No system files

Any state

Restore and recovery

Control files

Shutdown

System files

Mount

The database state required by SnapManager for a restore operation depends on the type of restore being performed (complete, partial, or control files). SnapManager does not transition the database to a lower state (for example, from Open to Mount) unless the force option is specified.